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 “aoudads” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
aoudads97376(None) 
aoudad835041aoudad_
audads8167101a_udads
alidads936292alidads
audad71511392a_udad_
doodads1035092doodads
hodads1147962ho_dads
houdahs1434242houdahs
soudans8309352soudans
abounds10217083abou_nds
adds67622453a__d_ds
ajugas1435263ajuga_s
alidad838883alidad_
alidade936993alidade
alidades1037003alidades
aludels835303aludels
anurans73810553anurans
aortas65417783aorta_s
aquas142412613aqu_a_s
arousals866273arousals
aubade939223a_ubade
aubades1038753a_ubades
audios72312283a_udios
audits72814113a_udits
auras55932563a_ura_s
boudins10311313boudins
bounds94415803bou_nds
caudad10157673caudad_
codas84724243co_da_s
coheads13289233coheads
coleads102911423coleads
cougars1038443cougars
couvade1335063couvade
couvades1435613couvades
dads67442773___dads
doodad936423doodad_
doulas75114993doula_s
doumas95314813douma_s
dourahs11487253dourahs
douras75016723doura_s
duads76515343_du_ads
foulards12266463foulards
founds104814193fou_nds
goads77022853go__ads
goddams1233983goddams
gonads84511733go_nads
gourds8108253gou_rds
hodad10311353ho_dad_
hondas10313353honda_s
houdah1335173houda_h
hounds104413133hou_nds
howdahs1733613howdahs
iodids83711153io_dids
jordans1566833jordans
jouals1338923jou_als
judas134911883_juda_s
loads65323373lo__ads
loudens8368053loudens
loumas84812333louma_s
modals93914453mo_dals
monads94515303mo_nads
moulds94910993mou_lds
mounds93915133mou_nds
nomads94711603no_mads
nougats8427413nougats
octads987333_octads
odahs95610083_o_dahs
odas57230263_o_da_s
odds68919923_o_d_ds
ogdoads1042993_ogdoads
oreads73915773_oreads
ouds56430103_ou__ds
outadd837803_outadd
outadds936203_outadds
poulards11288233poulards
poundals1145013poundals
pounds93714383pou_nds
quads154515843_qu_ads
roads66523623ro__ads
roulade857003roulade
roulades957173roulades
rounds73615623rou_nds
rudds74811703_rud_ds
sodas64123543so_da_s
soldans83210403soldans
soucars938423soucars
soudan73210353souda_n
sounds74616183sou_nds
squads164410293squ_ads
sudds75513593_sud_ds
toads65621073to__ads
todays10458103to_days
toucans937583toucans
voudons1135323voudons
woads94818443wo__ads
wounds103811633wou_nds
zounds164310173zou_nds

Search took 8 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 Filter1786911340270.390458182.1
2DLD Change Limit134027977.23618522.2
3Display Results97970.0303233.3
 (SQL Overall)178691977.65623340.0
 
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.