Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “rewet” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

140 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
rewet8513515(None) 
relet54749821relet
remet74843721remet
reset55051861reset
revet84938841revet
rewed95425451rewed
rewets94617211rewets
beet66457542be_et
beget85632562beget
beret74946362beret
beset76739132beset
bewept13410322bewept
brevet115717332brevet
brewed125411872brewed
brewer114812552brewer
crewed125316562crewed
crewel114310482crewel
deet57356582de_et
dewed105020302dewed
ewe66630982_ewe_
ewer77523982_ewer
ewes76328702_ewes
feet75352212fe_et
fewer115216122fewer
fewest12311662fewest
genet66038682genet
greet65835322gre_et
hewed125619432hewed
hewer115719932hewer
jewed165114832jewed
jewel156711702jewel
keet85347342ke_et
krewe1238192krewe_
krewes1337922krewes
leet45957902le_et
meet65350552me_et
mewed115218012mewed
newel86114132newel
newer85717462newer
newest9314212newest
newt76933742new_t
pewee10319972pewee
pewit104622792pewit
preset84430982preset
ramet75743142ramet
rawer84623732rawer
rawest93615062rawest
react74634332react
rebec94416542rebec
rebel73421292rebel
rebut75927382rebut
recent83630852recent
recept103319082recept
recit75235102recit
recut74729242recut
rede55037672rede_
reded74829122reded
redes65139132redes
ree37974072re_e_
reed55549622re_ed
reef74938212re_ef
reek85232522re_ek
reel45240532re_el
rees45364192re_es
reest54938092reest
refect114319332refect
refed93921922refed
refel84920812refel
refelt94521422refelt
refer84822142refer
refit84230062refit
reflet94024232reflet
reft75141272re_ft
regent74127672regent
reges65628792reges
reglet73724232reglet
regret73723532regret
reheat94423942reheat
rehem103815352rehem
reject154116282reject
rekey124014732rekey
relent64431852relent
relets64025672relets
relit55340682relit
remeet86325472remeet
remelt85123122remelt
remex146315792remex
remit75737222remit
renest64529712renest
renew83917512renew
rennet64624852rennet
rent46661242re_nt
rente54733782rente
repeat85127212repeat
repeg84015052repeg
repel74921402repel
repent84728872repent
repot75132622repot
rerent63832452rerent
resat55139682resat
reseat64131492reseat
resect84424702resect
resee54336332resee
resent63833622resent
resets65427612resets
resew84519502resew
resit54241042resit
rest46459842re_st
ret35982832r__et
rete44944132rete_
retem74221952retem
retest64028452retest
revel84423162revel
revert93529112revert
revest94623602revest
revets94022172revets
rewan85623662rewan
rewax155713922rewax
rewear93012002rewear
reweds104412302reweds
reweld103711112reweld
rewin85623962rewin
rewon86920582rewon
rexes124526952rexes
rivet85636362rivet
roset55945242roset
rowed94034322rowed
rowel84721412rowel
rowen84921152rowen
rower85430492rower
sewed95325162sewed
sewer84426222sewer
sweet85330522sweet
tenet55542212tenet
tewed94718532tewed
trevet94818912trevet
tweet84823982tweet
unwet84423172unwet
weet75254152we_et
wet65966622__wet

Search took 3 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691538000.326548131.9
2DLD Change Limit538001401.81329674.6
3Display Results1401400.0463043.5
 (SQL Overall)1786911402.18581780.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.