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 “looed” 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.

275 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
looed6462613(None) 
booed85127271booed
cooed84534341cooed
lobed86022131lobed
locoed94312191locoed
looey84822911looey
looked114717071looked
loomed94616761loomed
looped95217171looped
loosed75520891loosed
looted74421111looted
loped85128331loped
loved95021361loved
lowed95233901lowed
loxed135017051loxed
mooed85123981mooed
pooed85226241pooed
wooed94419871wooed
blood85319522bloo_d
blooded11379802blooded
blooey115110792blooey
bloomed12439432bloomed
blooped12398542blooped
blowed125016692blowed
boded95124962boded
boned85133242boned
boobed114514872boobed
booked135319502booked
boomed115318132boomed
booted94822732booted
boozed184813832boozed
bored85034302bored
bowed114533422bowed
boxed154318612boxed
cloned94518802cloned
closed95317972closed
cloyed125111562cloyed
coded95433182coded
coed77140542_coed
coked124730692coked
coled85540762coled
coned86040052coned
cooee74531022cooee
cooeed95917862cooeed
cooer74831012cooer
cooey105828222cooey
cooked135921362cooked
cooled95224592cooled
cooped114821612cooped
coped105036852coped
cored85044222cored
coted85033852coted
coved115027372coved
cowed115637852cowed
coxed154322812coxed
coyed114623802coyed
doled75430912doled
domed95423262domed
doomed104113292doomed
doped95326712doped
dosed76626912dosed
doted75227072doted
dowed104632612dowed
dozed165619352dozed
eloped95914152eloped
flood95215602floo_d
flooded12307932flooded
flooey123910172flooey
floored11268682floored
flowed133513762flowed
food86830572foo_d
fooled104317822fooled
footed104418622footed
foxed165115212foxed
globed104811762globed
gloomed11337412gloomed
gloved114811872gloved
glowed114913832glowed
glozed173711222glozed
good66531802goo_d
gooey95522862gooey
goofed114911382goofed
goosed86817032goosed
gored75227082gored
hoboed124511682hoboed
hoed87837982_hoed
hoked135326992hoked
holed95634132holed
homed115425422homed
honed95332262honed
hood85132332hoo_d
hooded114616742hooded
hooey114926602hooey
hoofed134614892hoofed
hooked145320552hooked
hooped125518182hooped
hooted104422662hooted
hooved134713122hooved
hoped115628182hoped
hosed95830982hosed
joked175217912joked
jowed164724422jowed
joyed164811832joyed
laced87132642laced
laded74232612laded
laked105731122laked
lamed85235292lamed
lased65132342lased
lated65240672lated
laved95028592laved
lawed96028322lawed
layed95127382layed
lazed154925842lazed
led46254552l__ed
lied55838092l_ied
liked104523812liked
limed85426802limed
lined64934642lined
lived95523722lived
load56730602l_oad
loaded84616872loaded
loafed104011152loafed
loamed94414612loamed
loaned73816292loaned
lobbed113114612lobbed
lobe65535362lobe_
lobes75331002lobes
locked134921662locked
locoes85516582locoes
lode56240112lode_
loden66621142loden
lodes66436912lodes
lodged913815712lodged
lofted103811892lofted
loge56837192loge_
loges66534202loges
logged96622942logged
loid55531492l_oid
loided83414022loided
lolled74315822lolled
lone45849132lone_
loner55431042loner
longed87121372longed
loo38359822loo__
looby108115622looby
looeys95110122looeys
loof78141052loo_f
loofa85912812loofa
loofs85623782loofs
looie55624242looie
looies65025832looies
look87333472loo_k
looker104816952looker
looks95124862looks
loom67035052loo_m
looms75124642looms
loon47344792loo_n
looney94712412looney
loons55731722loons
loony86918962loony
loop67835012loo_p
looper83817112looper
loops75723962loops
loopy105316642loopy
loos49051122loo_s
loose56627682loose
loosen66615962loosen
looser65219942looser
looses67328252looses
loot46955822loo_t
looter64222322looter
loots55431422loots
lope65941922lope_
loper75129232loper
lopes76437342lopes
lopped114218622lopped
lord55032082l_ord
lorded84916732lorded
lore45850352lore_
lores55045402lores
lose45144582lose_
losel54419422losel
loser54728672loser
loses56742012loses
lotted74222402lotted
loud55228042l_oud
louped95316382louped
loured74617402loured
loused74822912loused
louted74920692louted
love75234762love_
lover85526452lover
loves85332012loves
lowe75435312lowe_
lower85830412lower
lowes85732462lowes
loxes125227472loxes
lubed85319892lubed
luged74019092luged
lured65427492lured
luted64826142luted
lysed95011562lysed
mood76332062moo_d
mooned94216642mooned
moored93814172moored
mooted94120372mooted
moped105424732moped
moved114218152moved
mowed113629012mowed
noosed75018022noosed
nosed65524562nosed
noted65123842noted
ohed87825182_ohed
oohed94214212oohed
oozed154214262oozed
oped76230152_oped
owed86833872_owed
plowed124213202plowed
ployed124310562ployed
poked125425392poked
poled84934842poled
pood75934322poo_d
poohed123912522poohed
pooled94619812pooled
pooped113915942pooped
pored85234512pored
posed85828412posed
poxed154817862poxed
robed85323732robed
rood56733002roo_d
roofed105214742roofed
rooked114918142rooked
roomed95218542roomed
roosed75621602roosed
rooted75424002rooted
roped84630812roped
rosed65930352rosed
roved95323552roved
rowed94034322rowed
shoed95723012shoed
shooed103916082shooed
sloped94216852sloped
slowed104617072slowed
soled65835172soled
soloed74515742soloed
sooey84522432sooey
sooted73922592sooted
sored66141782sored
sowed94933862sowed
toed56137042_toed
toked105626492toked
toled65934922toled
toned65435342toned
tooled74918902tooled
tooted74620122tooted
toped85631312toped
toted64929482toted
towed95134582towed
toyed96019802toyed
voled95323722voled
voted93919142voted
vowed124424572vowed
wood85329382woo_d
wooded114213682wooded
wooer84316692wooer
woofed134511202woofed
wooled103715502wooled
wowed124023772wowed
yoked134821622yoked
yowed1253025182yowed
zoned154020262zoned
zooey173914802zooey
zooid15312102zooid
zoomed183610362zoomed
zooned164011082zooned

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.310576422.6
2DLD Change Limit538002751.59633709.3
3Display Results2752750.0763618.4
 (SQL Overall)1786912751.98290156.9
 
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.