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

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

206 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
voudon103587(None) 
voudons1135321voudons
voudoun1143601voudoun
boudin9412372boudin
bourdon1036422bourdon
bouton8311532bouton
codon86522852co_don
cordon95017292cordon
coupon102810992coupon
louden73711792louden
mouton8410852mouton
soudan73210352soudan
udon56017742__udon
vodou939342vo_dou
vodoun1036232vo_doun
vodun937222vo_dun
voodoo10127532voodoo
voudouns1243202voudouns
youpon11366002youpon
aoudad835033aoudad
blouson974893blouson
bolson8410683bolson
bonbon10310073bonbon
boon67142173bo__on
boron76727143bo_ron
boson76019733bo_son
boston8513043boston
boubou1038433boubou
boudins10311313boudins
boudoir1043853boudoir
bounden10389453bounden
bourbon1135813bourbon
bourdons1136433bourdons
bourn75518483bou_rn
boutons9310783boutons
cardon94120853cardon
cocoon10312263cocoon
coden86128543co_den
codons96119463co_dons
cogon89120903co_gon
colon78630193co_lon
common12310803common
condo85322593condo_
condom114215363condom
condone102616293condone
condor94616973condor
condos94322333condos
coon67248943co__on
cordons104415763cordons
cotton8312993cotton
coude85022633coud_e
coupons112710563coupons
cousin8517163cousin
coydog1335133coydog
crouton947133crouton
diuron738573diuron
doblon938013doblon
dobson936593dobson
dodo66024913do_do_
dodos75819393do_dos
dogdom1186363dogdom
don46757653___don
donjon1436463donjon
doodoo8108893doodoo
fogdog1234223fogdog
foison948933foison
fordo97218653fordo_
fordone1149383fordone
fourgon1134863fourgon
futon83113773_futon
gluon6311223glu_on
godown1136033go_down
godson857383godson
golden84411153golden
gonion73612833gonion
goon57236173go__on
gorgon8310243gorgon
guidon837373guidon
hagdon1188283hagdon
hodden113811453hodden
hoddin11369933hoddin
hoedown14125753hoedown
hoiden103612333hoiden
holden104113953holden
hoodoo10109983hoodoo
hotdog1134793hotdog
houdah1335173houdah
hoyden13328933hoyden
iodin64419353io_din
jomon14610083jo_mon
jordan1468063jordan
journo13135293journo
judo125315303_judo_
judos134711733_judos
jupon14479193_jupon
koodoo11107773koodoo
kouroi1036513kouroi
kouros1039183kouros
kudo96115103_kudo_
kudos105011253_kudos
lardon74415063lardon
leukon1036143leukon
loden66621143lo_den
logion76013723logion
logon615922313lo_gon
loon47344793lo__on
lotion65716523lotion
loud55228043loud__
loudens8368053loudens
louder74414603louder
loudly1037783loudly
loupen84510293loupen
lowdown1454483lowdown
mondo85721233mondo_
mondos95217333mondos
monuron937463monuron
moon67140813mo__on
morion86217733morion
moron76925423mo_ron
motion85217553motion
mouflon12104083mouflon
moulin8313283moulin
mourn77215013mou_rn
moutons9410313moutons
muon65722733_mu_on
muton73817003_muton
neuron6310373neuron
noon47134623no__on
notion64516583notion
noun45724183nou__n
odeon6411483_odeon
odor55718093_o_dor
olden65114853_olden
onion54320973_onion
ordo54622353_ordo_
ordos65216203_ordos
orlon5415003_orlon
oud47439073_oud__
ouds56430103_oud_s
outdo6312703_outdo_
outdone8311643_outdone
ouzo133516933_ouzo_
ouzos143210413_ouzos
pardon94618733pardon
pluton838853pluton
poison8312223poison
pompon1238943pompon
ponton83217643ponton
poon67341263po__on
potion84519573potion
puton73617913_puton
radon64620503_radon
redon65424883_redon
rondo65218373rondo_
rondos74616733rondos
ronion63315643ronion
ronyon9309133ronyon
rouen54920903rou_en
scudo85412213scudo_
sodden84011513sodden
sodom8814903so_dom
soldan73511853soldan
soldo67116563soldo_
solion6616383solion
solon55026133so_lon
soon46240503so__on
sordor7310213sordor
soudans8309353soudans
soupcon1144163soupcon
sudor6312623_sudor
tauon54816583tau_on
tendon7312033tendon
tondo69718683tondo_
tondos75115923tondos
toon47740633to__on
toucan838193toucan
toyon86715673to_yon
udo49027303__udo_
udons65411463__udons
udos56619903__udos
upon65817583__upon
vendor10359803vendor
verdin103113023verdin
virion9310683virion
vision9311313vision
vodka1354343vo_dka
vodouns1134763vo_douns
vodous1038603vo_dous
voduns1035053voduns
void86220563void__
voided114011133voided
voider103611553voider
voiding122910363voiding
voids95414673void_s
volutin1098103volutin
volution1198603volution
volvox1933363volvox
voodoos1196343voodoos
vouch134611903vou_ch
wonton93410963wonton
wooden103610303wooden
yaupon11345493yaupon
youpons12265983youpons
yourn87512773you_rn
yupon10469483_yupon
zoon137326983zo__on

Search took 7 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 Filter1786911127160.1261418182.5
2DLD Change Limit1127162066.29617902.8
3Display Results2062060.0762710.5
 (SQL Overall)1786912066.49827499.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.