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

367 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
middens1137938(None) 
maddens11359751maddens
midden104112851midden_
mildens10339931mildens
bidden104010792bidden_
bidders114012312bidders
hidden11429742hidden_
hoddens12378802hoddens
kidders13399172kidders
lindens839412lindens
madden103912522madden_
madders113513212madders
maidens10349662maidens
middays14335662middays
middies113116152middies
middlers123410192middlers
middles113415302middles
midges103516482midge_s
midgets113910252midgets
midlegs1156322midlegs
miens76118302mi__ens
milden94113152milden_
mildews13365882mildews
minders103720122minders
mispens11311072mispens
mittens9349882mittens
mizens174610252mi_zens
mizzens17366122mizzens
mudders113211112mudders
mudhens1335102mudhens
reddens9259782reddens
ridden83511722ridden_
ridders93612492ridders
saddens9309602saddens
smidgens12325642smidgens
soddens9348412soddens
suddens9308782suddens
swiddens1342712swiddens
widders123512272widders
widens106212722wi_dens
addend9458453_addend
addends10356053_addends
adders84315703_adders
aiders74524633ai_ders
aides65336613ai_de_s
aidless83612073aidless
aidmen92610373aidmen_
amides95722663ami_de_s
amidines113010853amidines
amidins103713103ami_dins
amidogens1343653amidogens
amidones11348663amidones
bedders113513383bedders
bemaddens1542103bemaddens
bidder104114863bidde_r
biddies113514493biddies
bidding123613513bidding
biddings13397563biddings
biders94822803bi_ders
bides85536783bi_de_s
bidets95215533bi_dets
binders103920743binders
biogens1038963biogens
birders103913263birders
budders113812103budders
burdens1039713burdens
chidden14255223chidden_
ciders94620093ci_ders
cinders104617763cinders
codders114114453codders
codens94821013_codens
deadens93410693deadens
dens55945073___dens
diadems1135393diadems
dickens144410133dickens
diddlers11359153diddlers
diddles103915073diddles
diddleys14334633diddleys
didies84621833didie_s
didoes85716963didoe_s
diodes83915783diode_s
dizens164911393di_zens
dodders105511793dodders
dudeens934863dudeens
eiders74321363ei_ders
fiddlers13328283fiddlers
fiddles123212603fiddles
fidges114114393fidge_s
fidgets12388763fidgets
finders113717873finders
fodders124010753fodders
gadders103611503gadders
gardens93312093gardens
giddies103713363giddies
gilders94212463gilders
girders9379943girders
givens10379733gi_vens
gladdens11364463gladdens
goddess1035263goddess
gridders11286293gridders
guldens9356573guldens
hardens113815023hardens
hiddenly1642393hiddenly
hiders104919653hi_ders
hides95129433hi_de_s
hinders113718503hinders
hodden113811453hodden_
hoddins12289373hoddins
hoidens11329083hoidens
hoydens14347403hoydens
ideas65919013_i_deas
ides57734243_i_de_s
idlers74012813_idlers
idles66720123_idle_s
imides94515343imide_s
indene73215373_indene
indenes82916253_indenes
indent73021243_indent
indents83114663_indents
iodins74216523_iodins
judders16347793judders
kidded13299403kidde_d
kidder123811113kidde_r
kiddies133412283kiddies
kidding14389773kidding
kiddoes13387063kiddoes
kiddos12416873kidd_os
kidneys1533423kidneys
kittens11347583kittens
ladders94115173ladders
ladens74516233_ladens
leadens83610983leadens
lichens123510683lichens
lidded93410243lidde_d
lidding103611433lidding
lidless8309273lidless
liens56525503li__ens
likens105613703li_kens
limens84618033li_mens
linden7411453linden_
linens64818393li_nens
lippens11328533lippens
listens74014133listens
livens94314893li_vens
lodens74315063_lodens
loudens8368053loudens
madded113513553madde_d
maddened1334893maddened
madder103515593madde_r
maddest112311213maddest
madding123711993madding
madmen113511743madmen_
madness10310073madness
madres93718183madre_s
maiden93512283maiden_
martens93714953martens
mavens114312973m_avens
meddlers12318203meddlers
meddles113213253meddles
medians103214213medians
medleys13115333medleys
melders103213913melders
menders103818803menders
merdes94518603merde_s
miches134320733miche_s
mickeys18447943mickeys
microns113814783microns
midairs1037203midairs
midday13327503midd_ay
middle103414983midd_le
middled123311903middled
middler112712273middler
middling13249343middling
middlings14194313middlings
middy124812603midd__y
midge95016563midge__
midget103718453midge_t
midguts11296013midguts
midirons1145883midirons
midis85923423mi_d_is
midland1136613midland
midlands1245543midlands
midleg1038553midle_g
midline102315103midline
midlines112613333midlines
midnoons1144403midnoons
midribs1235513midribs
mids76541803mi_d__s
midsts95510053mi_dsts
midterm12316013midterm
midterms13284863midterms
midtowns1443243midtowns
midways16386183midways
midweek1743273midweek
midweeks1842383midweeks
midyear1343343midyear
midyears1443403midyears
mien65028373mi__en_
mignons1037863mignons
mikes115129893mi_ke_s
mikrons13428413mikrons
mikvehs19111683mikvehs
milded104416153milde_d
mildened1235773mildened
milder93818453milde_r
mildest102812063mildest
mildew12319043milde_w
mildewy16353533mildewy
milding113615453milding
mildness1136523mildness
milds86422063mild__s
milers84625163mi_lers
miles74645073mi_le_s
milieus939803milieus
milkers134411613milkers
millers93621343millers
milles84526563mille_s
millets94216843millets
milnebs11113793milnebs
milreis937323milreis
milters93619093milters
mimeos104511543mi_meos
mimers105520183mi_mers
mimes95732023mi_me_s
mincers113714853mincers
minces104420803mince_s
minded103817833minde_d
minder94822503minde_r
minding113317893minding
mindless11319443mindless
minds85427133mind__s
mindsets1135683mindsets
miners84126633mi_ners
mines75651953mi_ne_s
minions93314623minions
minkes124618783minke_s
minters93822473minters
minuend1035383minuend
minuends1143903minuends
minuets9259853minuets
minxes154612983minxe_s
minyans1237263minyans
miocene1147923miocene
mioses84318853miose_s
mires75640883mi_re_s
mirins83918903mi_rins
misdeal1037663misdeal
misdeals1147233misdeals
misdeed113211053misdeed
misdeeds12276813misdeeds
misdeem12217873misdeem
misdeems13255653misdeems
misdoers1137103misdoers
misdoes10312493misdoes
misdone10310863misdone
misers85025703mi_sers
mises74740563mi_se_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_
models94216363m_odels
modems114610763m_odems
moderns1037963moderns
modes85537413m_ode_s
moistens10268773moistens
molders103315553molders
mondes94322353monde_s
mordent10313993mordent
mordents1138813mordents
moreens939963moreens
morgens10310463morgens
mudded114511383mudde_d
mudder104413493mudde_r
muddies113513953muddies
mudding123310813mudding
muddlers12428813muddlers
muddles112914353muddles
mudhen1236883mudhen_
mueddins1243483mueddins
mullens93611313mullens
murders103311363murders
nides65229143ni_de_s
nidgets9358143nidgets
nodders94410263nodders
padders113312873padders
piddlers12359593piddlers
piddles114314273piddles
pidgins11259123pidgins
pigpens1235503pigpens
pinders103720483pinders
pinkens13419653pinkens
redden83613623redden_
redders93615343redders
richens12349733richens
ridded93615123ridde_d
ridder84015143ridde_r
ridding103314193ridding
riddlers10269103riddlers
riddles93215023riddles
rident7520193ri_dent
riders74123903ri_ders
rides66140823ri_de_s
ridgels9348023ridgels
ridges85817013ridge_s
ridleys11145783ridleys
ripens85012173ri_pens
rudders93210653rudders
sadden83212403sadden_
sickens134411483sickens
siddurs934173siddurs
sides65838373si_de_s
sidlers83414233sidlers
sidles74721153sidle_s
siemens938413siemens
sirens65318153si_rens
sithens1039383sithens
skidders1454823skidders
slidden935153slidden_
smidgen11426513smidgen_
smidgeons13272733smidgeons
smidges11448193smidge_s
smidgins12314843smidgins
sodden84011513sodden_
sudden83310833sudden_
swidden1234233swidden_
tedders94010233tedders
tiddlers10288653tiddlers
tides64830163ti_de_s
tidiers8389773tidiers
tidies74721833tidie_s
tildes74513963tilde_s
tinders84219173tinders
udders83911293_udders
videos104911373vi_deos
vixens16286203vi_xens
wadders123812443wadders
wardens113711903wardens
wedders123610723wedders
widder112913973widde_r
widdies123514033widdies
widdles123514343widdles
widen94717983wi_den_
wides94832833wi_de_s
widgeons1343853widgeons
widgets12318453widgets
wilders113513503wilders
winders113721263winders
wizens186110263wi_zens
wizzens18385483wizzens

Search took 8 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 Limit1340273676.59320328.7
3Display Results3673670.1402621.4
 (SQL Overall)1786913677.13925030.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.