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

203 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
milles8452656(None) 
filles94224521filles
miles74645071mi_les
mille75029131mille_
milled94326171milled
miller84625411miller
millers93621341millers
millet84030741millet
millets94216841millets
mills75435051mill_s
rilles64725501rilles
aisles64721142aisles
belles85325992belles
bibles104617642bibles
biles75542142bi_les
bilges94915632bilges
billed94224902billed
biller84923482biller
billers94720832billers
billet86029722billet
billets94516152billets
billies93923502billies
bills75632862bill_s
birles84920642birles
dalles74222062dalles
dilled84122222dilled
dillies84122162dillies
dills65530972dill_s
failles102914132failles
files85441272fi_les
fille84327402fille_
filled104922262filled
filler94623622filler
fillers104320212fillers
fillet95027082fillet
fillets103414752fillets
fillies103420252fillies
fillos94415082fillos
fills84632372fill_s
folles93820472folles
gilled84521632gilled
giller74519732giller
gillers84216902gillers
gillies84120962gillies
gills64728192gill_s
grilles83715022grilles
hilled104022222hilled
hiller94421632hiller
hillers103718732hillers
hilloes103815962hilloes
hillos94618892hillos
hills85431352hill_s
idles66720122_idles
iller54821292_iller
illest63615722_illest
ills47030422_ill_s
isles54220562_isles
jills125122822jill_s
killed113918772killed
killer104917952killer
killers114215582killers
killies113318112killies
kills94526172kill_s
lilies63021412lilies
lisles63416282lisles
macles107023222macles
mailes84329112mailes
mailless10248582mailless
maills84215282maill_s
males75049792m_ales
malled94626112malled
mallee84525592mallee
mallees93315972mallees
mallei84414632mallei
mallet84433052mallet
mallets93318492mallets
malleus92911312malleus
malls76233432mall_s
manilles102312602manilles
maples104819422maples
melees83618082melees
melled95023022melled
mells75031332mell_s
merles85322762merles
micelles1288832micelles
miches134320732miches
mickles153415002mickles
middles113415302middles
midges103516482midges
midleg1038552midleg
midlegs1156322midlegs
miggles113512032miggles
mikes115129892mi_kes
milages103114402milages
milded104416152milded
milden94113152milden
mildens10339932mildens
milder93818452milder
mildest102812062mildest
mildew12319042mildew
mildews13365882mildews
milds86422052mi_lds
mile66352572mi_le_
miler75733062mi_ler
milers84625162milers
milieu8314112milieu
milieus939802milieus
milked134612572milked
milker124814322milker
milkers134411612milkers
milkless1434772milkless
milks115020582mi_lks
mill66541482mill__
millages113212902millages
millier93716702millier
milliers102611902milliers
millimes122411372millimes
millines102718062millines
milneb1095952milneb
milnebs11113792milnebs
milos75428012mi_los
milpas101710272milpas
milreis937322milreis
mils66045332mi_l_s
milted93919942milted
milter84921232milter
milters93619092milters
milts75430712mi_lts
mimes95732022mi_mes
minces104420802minces
mines75651952mi_nes
mingles103719002mingles
minkes124618782minkes
minxes154612982minxes
mioses84318852mioses
mires75640882mi_res
mises74740562mi_ses
misled94719312misled
mislies92922282mislies
misses85130872misses
mites75141802mi_tes
mitres83922072mitres
mixes147224402mi_xes
mizzles17329492mizzles
moles74747922m_oles
molies84429512molies
mollies93420232mollies
molls75129782moll_s
mules75034292m_ules
mullas84215932mullas
mulled94721552mulled
mullen83714762mullen
mullens93611312mullens
muller83820352muller
mullers93217302mullers
mullet84126822mullet
mullets93614782mullets
mulley114013452mulley
mulleys12299202mulleys
mulls75124152mull_s
nilled73919452nilled
nills54926672nill_s
piles74742612pi_les
pilled94222752pilled
pills74130972pill_s
pilules9510622pilules
rifles94217702rifles
riles55343642ri_les
rille55728732rille_
rilled74525652rilled
rillet64828852rillet
rillets74216152rillets
rills55032712rill_s
selles64426982selles
sidles74721152sidles
siller64026062siller
sillers73822102sillers
sillies73425082sillies
sills55135992sill_s
smiles84522292smi_les
tailles72516472tailles
tildes74513962tildes
tiles55542102ti_les
tilled74722952tilled
tiller64222542tiller
tillers73418742tillers
tills54631712till_s
titles63719922titles
tuilles72411922tuilles
tulles63218892tulles
villas96117262villas
vills86429322vill_s
villus93611222villus
wiles85437872wi_les
willed104722452willed
willer94021062willer
willers103517912willers
willet95124832willet
willets104414322willets
willies103920152willies
wills84528962will_s
yills83921552yill_s
zills144020782zill_s

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 Filter178691825510.326548131.9
2DLD Change Limit825512032.42334069.7
3Display Results2032030.0603383.3
 (SQL Overall)1786912032.80963613.7
 
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.