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

363 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
midlegs115632(None) 
midleg1038551midleg_
aidless83612072aidless
idlers74012812_idlers
idles66720122_idle_s
lidless8309272lidless
medleys13115332medleys
middens11379382middens
middlers123410192middlers
middles113415302middle_s
midges103516482midge_s
midgets113910252midgets
mildens10339932mildens
mildews13365882mildews
milers84625162mi_lers
miles74645072mi_le_s
millers93621342millers
milles84526562mille_s
millets94216842millets
mindless11319442mindless
redlegs936822redlegs
ridleys11145782ridleys
sidlers83414232sidlers
sidles74721152sidle_s
addles84216603addle_s
aiders74524633aid_ers
aides65336603aid_e_s
aiglets84012913aiglets
aimless93610813aimless
airless73712043airless
aisles64721143aisle_s
amides95722663amid_e_s
bedless1039703bedless
bibles104617643bible_s
bibless11439173bibless
bidders114012313bidders
biders94822803bid_ers
bides85536773bid_e_s
bidets95215533bid_ets
biles75542143bi_le_s
bilges94915633bi_lges
billers94720833billers
billets94516153billets
bindles104016453bindle_s
birlers93813003birlers
birles84920643birle_s
bowlegs13366823bowlegs
bridlers11359183bridlers
bridles104114473bridle_s
budless1038873budless
ciders94620093cid_ers
dialers83614303dialers
dialogs938103dialogs
diddlers11359153diddlers
diddles103915073diddle_s
diddleys14334633diddleys
didies84621833didie_s
didoes85716963didoe_s
dindles93817243dindle_s
doglegs1034783doglegs
dregs76114863__dregs
ediles74016983edile_s
eiders74321363eid_ers
endless839833endless
fiddlers13328283fiddlers
fiddles123212603fiddle_s
fidges114114393fidge_s
fidgets12388763fidgets
filers94623723fi_lers
files85441273fi_le_s
filets94718953fi_lets
fillers104320213fillers
filles94224523fille_s
fillets103414753fillets
finless102810783finless
giblets103210423giblets
giglets93211553giglets
gilders94212463gilders
gillers84216903gillers
gimlets10338433gimlets
girdlers10195403girdlers
girdles92210003girdle_s
godless938403godless
hideless12278713hideless
hiders104919653hid_ers
hides95129423hid_e_s
hidings12349703hidings
hillers103718733hillers
hipless12399923hipless
hitless103211193hitless
ideas65919013_id_eas
ides57734233_id_e_s
idle55423763_idle__
idled74915213_idle_d
idler65015663_idle_r
idlesse834193_idlesse
idlest74014863_idlest
ileus54616893_i_leus
imides94515343imid_e_s
inlets63915573_inlets
isles54220563_isle_s
islets64513083_islets
kidders13399173kidders
kidneys1533423kidneys
killers114215583killers
kindlers13318483kindlers
kindles123614843kindle_s
kindless13289243kindless
kinless113310273kinless
ladlers84613573ladlers
ladles74619543ladle_s
legs56133693___legs
lipless9259553lipless
lisles63416283lisle_s
macles107023223macle_s
maddens11359753maddens
madders113513213madders
madness10310073madness
madres93718183madre_s
maglevs1334693maglevs
maidens10349663maid_ens
mailers94420333mailers
mailes84329113maile_s
mailless10248583mailless
males75049793m_ale_s
mallees93315973mallees
mallets93318493mallets
malleus92911313malleus
manless93012933manless
maples104819423maple_s
maskegs14375413maskegs
matless93014043matless
maulers94213303maulers
meddlers12318203meddlers
meddles113213253meddle_s
medlars10259443medlars
medley1298343medle_y
megs75530633m___egs
melders103213913melders
melees83618083m_elees
merles85322763merle_s
mewlers12288983mewlers
micells11107683micells
miches134320733miche_s
mickeys18447943mickeys
mickles153415003mickle_s
midairs1037203midairs
middays14335663middays
midden104112853midde_n
middies113116153middies
middle103414983middle__
middled123311903middle_d
middler112712273middle_r
middlings14194313middlings
midge95016553mid__ge
midget103718453midge_t
midguts11296013midguts
midis85923413mid__is
midland1136613midland
midlands1245543midlands
midlife13248303midlife
midlifers15254933midlifers
midline102315103midline
midlines112613333midlines
midlist10312513midlist
midlists1137523midlists
midlives14287463midlives
midribs1235513midribs
mids76541793mid___s
midsoles1137763midsole_s
midsts95510053mid_sts
midterm12316013midterm
midterms13284863midterms
midways16386183midways
midweek1743273midweek
midweeks1842383midweeks
midyear1343343midyear
midyears1443403midyears
miens76118303mi__ens
miggles113512033miggle_s
miggs96311373mi__ggs
migs76935323mi___gs
mikes115129893mi_ke_s
mikvehs19111683mikvehs
milage93414123mi_lage
milages103114403mi_lages
milded104416153milde_d
milden94113153milde_n
milder93818453milde_r
mildest102812063mildest
mildew12319043milde_w
mildewy16353533mildewy
mildness1136523mildness
milds86422053mi_l_ds
mile66352573mi_le__
mileage10299313mi_leage
mileages11249693mi_leages
miler75733063mi_le_r
milieus939803milieus
milkers134411613milkers
milkless1434773milkless
milks115020583mi_l_ks
millage103112753millage
millages113212903millages
mille75029133mille__
milled94326173mille_d
miller84625413mille_r
millet84030743mille_t
milliers102611903milliers
millings113712583millings
mills75435053mi_l_ls
milnebs11113793milnebs
milos75428013mi_l_os
milpas101710273mi_lpas
milreis937323milreis
mils66045333mi_l__s
milters93619093milters
milts75430713mi_l_ts
mimeos104511543mi_meos
mimers105520183mi_mers
mimes95732023mi_me_s
mincers113714853mincers
minces104420803mince_s
minders103720123minders
mindsets1135683mindsets
miners84126633mi_ners
mines75651953mi_ne_s
minglers113011293minglers
mingles103719003mingle_s
minings103912073minings
minkes124618783minke_s
minters93822473minters
minuets9259853minuets
minxes154612983minxe_s
mioses84318853miose_s
mirages102213533mirages
mires75640883mi_re_s
misdeeds12276813misdeeds
misdeems13255653misdeems
misdoers1137103misdoers
misdoes10312493misdoe_s
misers85025703mi_sers
mises74740563mi_se_s
mislays12349243mislays
mislead10419973mislead
misleads11358543misleads
misled94719313misle_d
mislies92922283mislies
mispens11311073mispens
missels94614813missels
misses85130873misse_s
missets94516573missets
misters93927513misters
miters84328783mi_ters
mites75141803mi_te_s
mithers123516733mithers
mitres83922073mitre_s
mittens9349883mittens
mixers154513563mi_xers
mixes147224403mi_xe_s
mizens174610253mi_zens
mizzens17366123mizzens
mizzles17329493mizzle_s
modelers1138463modelers
models94216353mod_els
modems114610763mod_ems
modes85537413mod_e_s
modules102511003module_s
moilers93615203moilers
molders103315553molders
moles74747923m_ole_s
mooleys1236863mooleys
motleys1235683motleys
mudbugs1342853mudbugs
mudders113211113mudders
muddlers12428813muddlers
muddles112914353muddle_s
mudhens1335103mudhens
mules75034293m_ule_s
muleys11409643m_uleys
mullens93611313mullens
mullers93217303mullers
mullets93614783mullets
mulleys12299203mulleys
muskegs14285013muskegs
nides65229133nid_e_s
nidgets9358143nidgets
oilers64721193oi_lers
oodles73517183oodle_s
padles95221123padle_s
pedlers103013273pedlers
piddlers12359593piddlers
piddles114314273piddle_s
piglets103311793piglets
piles74742613pi_le_s
pileus84514943pi_leus
piolets93513193piolets
prolegs10379993prolegs
redleg839273redleg_
ribless93410343ribless
riblets93412553riblets
ridders93612493ridders
riddlers10269103riddlers
riddles93215023riddle_s
riders74123903rid_ers
rides66140813rid_e_s
ridgels9348023ridgels
ridges85817013ridge_s
ridings93412093ridings
ridley10169543ridle_y
riflers103512193riflers
rifles94217703rifle_s
riles55343643ri_le_s
rilles64725503rille_s
rillets74216153rillets
rimless9369363rimless
rindless92510193rindless
rodless8310073rodless
sides65838363sid_e_s
sidings94011463sidings
sidle65124033sidle__
sidled84215173sidle_d
sidler74716963sidle_r
sillers73822103sillers
sinless73014213sinless
smidgens12325643smidgens
smidges11448193smidge_s
smilers94113853smi_lers
smiles84522293smi_le_s
smileys12336323smi_leys
tiddlers10288653tiddlers
tideless9269083tideless
tides64830153tid_e_s
tidiers8389773tidiers
tidies74721833tidie_s
tidings93810263tidings
tieless72512563tieless
tildes74513963tilde_s
tilers63523503ti_lers
tiles55542103ti_le_s
tillers73418743tillers
tipless92610063tipless
titles63719923title_s
videos104911373vid_eos
violets102210003violets
widders123512273widders
widdles123514343widdle_s
widens106212723wid_ens
wides94832823wid_e_s
widgets12318453widgets
wigless11359673wigless
wiglets113411423wiglets
wilders113513503wilders
wiles85437873wi_le_s
willers103517913willers
willets104414323willets
windles113518493windle_s
windless123310863windless
winless103212283winless
witless103310983witless
yodlers11298923yodlers
yodles103714333yodle_s
zipless18276303zipless

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.406440125.6
2DLD Change Limit1340273636.37621020.5
3Display Results3633630.1232951.2
 (SQL Overall)1786913636.90525878.5
 
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.