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

431 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
mildens1033993(None) 
middens11379381middens
milden94113151milden_
mildews13365881mildews
gilders94212462gilders
guldens9356572guldens
lindens839412lindens
maddens11359752maddens
maidens10349662maidens
melders103213912melders
midden104112852midden_
midlegs1156322midlegs
miens76118302mi__ens
milded104416152milde_d
mildened1235772mildened
milder93818452milde_r
mildest102812062mildest
mildew12319042milde_w
mildewy16353532mildewy
milding113615452milding
mildness1136522mildness
milds86422052mild__s
milers84625162mil_ers
miles74645072mil_e_s
milieus939802milieus
milkers134411612milkers
millers93621342millers
milles84526562mille_s
millets94216842millets
milnebs11113792milnebs
milreis937322milreis
milters93619092milters
minders103720122minders
mispens11311072mispens
mittens9349882mittens
mizens174610252mi_zens
mizzens17366122mizzens
molders103315552molders
mullens93611312mullens
tildes74513962tilde_s
widens106212722wi_dens
wilders113513502wilders
aiders74524633ai_ders
aides65336603ai_de_s
aidless83612073aidless
ailment9314233ailment
ailments1039433ailments
alders74218423_alders
aliens65619213_aliens
amides95722663ami_de_s
amidins103713103ami_dins
baleens938473baleens
bidden104010793bidden_
bidders114012313bidders
biders94822803bi_ders
bides85536773bi_de_s
bidets95215533bi_dets
biles75542143bil_e_s
bilges94915633bilge_s
bilkers134711863bilkers
billers94720833billers
billets94516153billets
billons93013363billons
binders103920743binders
biogens1038963biogens
birders103913263birders
builders1146743builders
burdens1039713burdens
childes134211273childe_s
ciders94620093ci_ders
cinders104617763cinders
codens94821013_codens
deadens93410693deadens
dens55945073___dens
diadems1135393diadems
dickens144410133dickens
dildoes9229243dildoes
dildos8179303dild_os
diluent8310263diluent
diluents946053diluents
diodes83915783diode_s
dizens164911393di_zens
dolmens10388693dolmens
eiders74321363ei_ders
elders74817303_elders
elides74420693elide_s
emboldens1463563emboldens
fielders12156773fielders
filers94623723fil_ers
files85441273fil_e_s
filets94718953fil_ets
fillers104320213fillers
filles94224523fille_s
fillets103414753fillets
filmers124211293filmers
filters103816553filters
finders113717873finders
folders113514393folders
gardens93312093gardens
gelders93812573gelders
gilded94413223gilde_d
gilder84415533gilde_r
gilding103813003gilding
gildings11356973gildings
gilds75417523gild__s
gillers84216903gillers
girders9379943girders
givens10379733gi_vens
glens66519853_gl_ens
gliders94811843gliders
glides84518863glide_s
golden84411153golden_
guilders1035513guilders
gulden8328763gulden_
hardens113815023hardens
hidden11429743hidden_
hiders104919653hi_ders
hides95129423hi_de_s
hilding123713533hilding
hildings13347503hildings
hillers103718733hillers
hinders113718503hinders
hoddens12378803hoddens
hoidens11329083hoidens
holden104113953holden_
holders113715903holders
hoydens14347403hoydens
ideas65919013_i_deas
ides57734233_i_de_s
idlers74012813_idlers
idles66720123_idle_s
ileus54616893_il_eus
imboldens1442623imboldens
imides94515343imide_s
indene73215373_indene
indenes82916253_indenes
indent73021243_indent
indents83114663_indents
iodins74216523_iodins
jilters144211963jilters
kidders13399173kidders
killdees1373963killdees
killers114215583killers
kilns95112983kil__ns
kilters113813603kilters
kittens11347583kittens
ladens74516233_ladens
leadens83610983leadens
lens46146493__l_ens
lichens123510683lichens
lidless8309273lidless
liens56525503__liens
likens105613703li_kens
lilies63021413lilie_s
limens84618033li_mens
linden7411453linden_
linens64818393li_nens
lippens11328533lippens
listens74014133listens
livens94314893li_vens
lodens74315063_lodens
loudens8368053loudens
madden103912523madden_
madders113513213madders
maiden93512283maiden_
mailers94420333mail_ers
mailes84329113mail_e_s
mailless10248583mailless
mailmen1137273mailmen_
males75049793mal_e_s
maligns1038133maligns
malines93625603malines
malkins133311803malkins
mallees93315973mallees
mallets93318493mallets
malleus92911313malleus
malteds10377603malteds
martens93714953martens
mavens114312973m_avens
medleys13115333medleys
melded104714713melde_d
melder93915813melde_r
melding113414273melding
melds84822383meld__s
melees83618083mel_ees
melena81110473mel_ena
melenas999203mel_enas
melodeons1243353melodeons
melons84117713mel_ons
melters93918313melters
meltons9410923meltons
menders103818803menders
merdes94518603merde_s
miches134320733miche_s
mickeys18447943mickeys
microns113814783microns
middays14335663middays
middies113116153middies
middlers123410193middlers
middles113415303middles
midges103516483mi_dges
midgets113910253midgets
midis85923413mi_d_is
midland1136613midland
midlands1245543midlands
midleg1038553midle_g
midline102315103midline
midlines112613333midlines
mids76541793mi_d__s
midsts95510053mi_dsts
mien65028363mi__en_
mignons1037863mignons
mikes115129893mi_ke_s
mikrons13428413mikrons
mikvehs19111683mikvehs
miladies1139923miladies
miladis1049823miladis
milages103114403milages
mild75330853mild___
mildening1345673mildening
mildewed1543763mildewed
mildewing1643733mildewing
mildly12318243mild_ly
mile66352573mil_e__
miler75733063mil_e_r
milieu8314113milie_u
milieux1643783milieux
milked134612573milke_d
milker124814323milke_r
milking143712763milking
milkless1434773milkless
milkmen1565213milkmen_
milks115020583mil__ks
milldams1344633milldams
mille75029133mille__
milled94326173mille_d
miller84625413mille_r
millet84030743mille_t
milliers102611903milliers
milline92519113milline
millines102718063millines
milling103223683milling
millings113712583millings
millions101712433millions
millruns1043643millruns
mills75435053mil__ls
milneb1095953milne_b
milords10117853milords
milos75428013mil__os
milpas101710273mil_pas
mils66045333mil___s
milted93919943milte_d
milter84921233milte_r
milting103619123milting
milts75430713mil__ts
mimeos104511543mi_meos
mimers105520183mi_mers
mimes95732023mi_me_s
mincers113714853mincers
minces104420803mince_s
minded103817833minde_d
minder94822503minde_r
minding113317893minding
mindless11319443mindless
minds85427123mind__s
mindsets1135683mindsets
miners84126633mi_ners
mines75651953mi_ne_s
minions93314623minions
minkes124618783minke_s
minters93822473minters
minuend1035383minuend
minuends1143893minuends
minuets9259853minuets
minxes154612983minxe_s
minyans1237263minyans
miocene1147923miocene
mioses84318853miose_s
mires75640883mi_re_s
mirins83918903mi_rins
misdeal1037663misdeal
misdeals1147223misdeals
misdeed113211053misdeed
misdeeds12276813misdeeds
misdeem12217873misdeem
misdeems13255653misdeems
misdoers1137103misdoers
misdoes10312493misdoes
misdone10310863misdone
misers85025703mi_sers
mises74740563mi_se_s
mislies92922283mislie_s
mispen10312173mispen_
missels94614813missels
missend104411373missend
missends11368233missends
missense1037963missense
missent94318713missent
misses85130873misse_s
missets94516573missets
mistend103812523mistend
mistends11419593mistends
misters93927513misters
miters84328783mi_ters
mites75141803mi_te_s
mithers123516733mithers
mitogens1146973mitogens
mitres83922073mitre_s
mitten83914093mitten_
mixers154513563mi_xers
mixes147224403mi_xe_s
mizen164815273mi_zen_
mizzen16447953mizzen_
models94216353m_odels
modems114610763m_odems
moderns1037963m_oderns
modes85537413m_ode_s
moilers93615203moil_ers
moistens10268773moistens
molded104414083molde_d
molder93819273molde_r
molding114213753molding
moldings12267203moldings
molds85324833mold__s
moles74747923mol_e_s
molies84429513molie_s
molten83311813molten_
molters93816973molters
mondes94322353monde_s
mordent10313993mordent
mordents1138813mordents
moreens939963moreens
morgens10310463morgens
moulders11348343moulders
mudders113211113mudders
mudhens1335103mudhens
mules75034293mul_e_s
muleys11409643mul_eys
mulleins10277053mulleins
mullen83714763mullen_
mullers93217303mullers
mullets93614783mullets
mulleys12299203mulleys
murders103311363murders
nides65229133ni_de_s
oilcans936813oilcans
oilers64721193oil_ers
oilmen848313oilmen_
olden65114853_olden_
pigpens1235503pigpens
piles74742613pil_e_s
pileus84514943pil_eus
pilfers1238963pilfers
pinders103720473pinders
pinkens13419643pinkens
polders103617373polders
pollens93713303pollens
reddens9259783reddens
richens12349733richens
ridden83511723ridden_
ridders93612493ridders
rident7520193ri_dent
riders74123903ri_ders
rides66140813ri_de_s
ridleys11145783ridleys
riles55343643ril_e_s
rilles64725503rille_s
rillets74216153rillets
ripens85012173ri_pens
saddens9309603saddens
sickens134411483sickens
sides65838363si_de_s
sidlers83414233sidlers
sidles74721153sidle_s
siemens938413siemens
silanes72517163silanes
silds65520523sild__s
sileni63312143sil_eni
silent64125843sil_ent
silents73514493sil_ents
silenus7369693sil_enus
silken104410853silken_
sillers73822103sillers
silvans10308333silvans
silvers104714043silvers
sirens65318153si_rens
sithens1039383sithens
sliders83515223sliders
slides73922183slide_s
smidgens12325643smidgens
smilers94113853smil_ers
smiles84522293smil_e_s
smileys12336323smil_eys
smolders11287193smolders
soddens9348413soddens
soldans83210403soldans
solders83517773solders
spleens937103spleens
suddens9308783suddens
suldans8299723suldans
swiddens1342713swiddens
tides64830153ti_de_s
tilde65017343tilde__
tilers63523503til_ers
tiles55542103til_e_s
tillers73418743tillers
tilters73315953tilters
tinders84219173tinders
videos104911373vi_deos
villeins1136043villeins
vixens16286203vi_xens
wardens113711903wardens
welders113313413welders
widders123512273widders
widen94717973wi_den_
wides94832823wi_de_s
wielders12196613wielders
wilded113714503wilde_d
wilder103616473wilde_r
wildest113311273wildest
wilding123814293wilding
wildings13287933wildings
wildness1236203wildness
wilds94818203wild__s
wiles85437873wil_e_s
willers103517913willers
willets104414323willets
winders113721263winders
wizens186110263wi_zens
wizzens18385483wizzens
yielders12164743yielders

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 Filter1786911340270.403443402.0
2DLD Change Limit1340274316.00322326.7
3Display Results4314310.1532817.0
 (SQL Overall)1786914316.55927243.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.