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

165 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
miladies113992(None) 
maladies11311931maladies
miladis1049821miladi_s
beladies11310422beladies
ladies75124882__ladies
melodies11310122melodies
middies113116152mi_ddies
miladi938882miladi__
milages103114402mila_ges
baldies105317703bal_dies
beladied1236663beladied
bialies93618413bi_alies
biddies113514493bi_ddies
bigamies1337373bigamies
bilbies114712343bil_bies
billies93923503bil_lies
binaries10314183binaries
birdies104016213bi_rdies
blades95221253_blad_es
clades94920463_clad_es
claries93422203_claries
diaries83321953di_aries
didies84621833di__dies
digamies1238643digamies
dilates83220663dila_tes
dildoes9229243dil_does
dillies84122163dil_lies
dipodies1238413dipodies
filarees1187643filarees
fillies103420253fil_lies
galaxies1637163galaxies
giddies103713363gi_ddies
gillies84120963gil_lies
glades84820343_glad_es
gladier93810993_gladier
gladiest101710333_gladiest
gliadines1144773gliadines
gliadins1035193gliadins
imbodies1345483imbodies
indies73822783_i_ndies
irades74517393_irad_es
kiddies133412283ki_ddies
killdees1373963killdees
killies113318113kil_lies
kilties113014143kil_ties
laddies93715053__laddies
lades65141273__lad_es
ladles74619543__ladles
lazies154418783__lazies
lilies63021413lil__ies
lindies8416583li_ndies
litanies8310993litanies
madres93718183m__adres
malaise9312673mala_ise
malaises10312333malaises
malarias10313773malarias
malarkies1545113malarkies
malates93522603mala_tes
mamies104626243m__amies
maundies1137853maundies
mavies114923193m__avies
mealies92821933m_ealies
meanies93620743m_eanies
melamines1339763melamines
melanges1138613melanges
melanics1237733melanics
melanins10310383melanins
melanites11410723melanites
melanizes20410383melanizes
melodias1148703melodias
melodise1147593melodise
melodises1247603melodises
melodizes2146753melodizes
midairs1037203mida_irs
middles113415303mi_ddles
midges103516483mi__dges
midis85923413mi__di_s
mikados1444683mikad_os
milady1236613milad__y
milage93414123mila_ge_
milded104416153mil_d_ed
milden94113153mil_d_en
mildens10339933mil_dens
milder93818453mil_d_er
mildest102812063mil_d_est
mildew12319043mil_d_ew
mildews13365883mil_dews
milding113615453mil_ding
mildness1136523mil_dness
milds86422053mil_d__s
mileages11249693mileages
miles74645073mil___es
milfoils1343893milfoils
miliarias1148783miliarias
milieu8314113mil__ieu
milieus939803mil__ieus
militaries1249443militaries
militias1048633militias
milkier133411163mil_kier
milkiest142911083mil_kiest
millages113212903millages
milldams1344633milldams
milles84526563mil__les
milliaries1248243milliaries
millier93716703mil_lier
milliers102611903mil_liers
millimes122411373millimes
millines102718063millines
milreis937323milrei_s
miltier93214963mil_tier
miltiest103015173mil_tiest
minifies13312903minifies
minnies93617363mi_nnies
miracles1238333miracles
miradors1146853miradors
mirages102213533mira_ges
mirandizes2244123mirandizes
misadded1335753misadded
misadds1136303misad_ds
misadvices1842203misadvices
misadvise1542933misadvise
misadvises1642893misadvises
misaims11310113misa_ims
misallies1148383misallies
misandries1345063misandries
misdates111113633misdates
misdoes10312493mi_sdoes
misedits1147963misedits
miseries10320403miseries
mislies92922283mi_slies
mislodges1344363mislodges
missies93423983mi_ssies
molasses1037233molasses
moldier103110033mol_dier
moldiest11249693mol_diest
molies84429513mol__ies
mollies93420233mol_lies
monades103713823monad_es
monodies11312503monodies
muddies113513953m_uddies
oldies7314423_ol_dies
paladins11911003paladins
piracies12312643piracies
platies93722543_platies
readies83324713_readies
roadies83317443_roadies
salaries8319573salaries
silages82514443sila_ges
silanes72517163sila_nes
silkies113715693sil_kies
sillies73425083sil_lies
smilaxes1744653smila_xes
steadies9311123steadies
tidies74721833ti__dies
tilapias1045293tilapias
tildes74513963til_d_es
tirades8311723tirad_es
toadies82914863_toadies
tuladis835703tuladi_s
unlades82612833unlad_es
vilifies1439593vilifies
vivaries1439263vivaries
wadies105121203__wadies
widdies123514033wi_ddies
willies103920153wil_lies

Search took 10 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 Filter1786911461620.436409841.7
2DLD Change Limit1461621659.00316234.8
3Display Results1651650.0602750.0
 (SQL Overall)1786911659.49918811.6
 
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.