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

530 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
midden10411285(None) 
bidden104010791bidden
hidden11429741hidden
madden103912521madden
middens11379381middens
milden94113151milden
ridden83511721ridden
aidmen92610372aidmen
bidder104114862bidder
chidden14255222chidden
hodden113811452hodden
kidded13299392kidded
kidder123811102kidder
lidded93410242lidded
linden7411452linden
madded113513552madded
maddens11359752maddens
madder103515592madder
madmen113511742madmen
maiden93512282maiden
midday13327502midday
middies113116152middies
middle103414982middle
middled123311902middled
middler112712272middler
middles113415302middles
middy124812592midd_y
midge95016552midge_
midges103516482midges
midget103718452midget
midleg1038552midleg
mien65028362mi__en
milded104416152milded
mildens10339932mildens
milder93818452milder
mildew12319042mildew
minded103817832minded
minder94822502minder
mispen10312172mispen
mitten83914092mitten
mizen164815272mi_zen
mizzen16447952mizzen
mudded114511382mudded
mudder104413492mudder
mudhen1236882mudhen
redden83613622redden
ridded93615122ridded
ridder84015142ridder
sadden83212402sadden
slidden935152slidden
smidgen11426512smidgen
sodden84011512sodden
sudden83310832sudden
swidden1234232swidden
widder112913972widder
widen94717972wi_den
added84918433_added
addend9458453_addend
adder75419593_adder
admen84516183_admen
aide56045003ai_de_
aided75828933ai_ded
aider65431133ai_der
aides65336603ai_des
aidman92410623aidman
airmen82612353airmen
amide86128483ami_de_
amides95722663ami_des
amidin94015673ami_din
amidine103613853amidine
amidogen1243913amidogen
amidone10349313amidone
badder103817513badder
badmen114613833badmen
bedded115114073bedded
bedder104215793bedder
bemadden1443113bemadden
bidders114012313bidders
biddies113514493biddies
bidding123613513bidding
biddy124612693bidd_y
bide76041503bi_de_
bided95424963bi_ded
bider85728373bi_der
bides85536773bi_des
bidet84935623bi_det
binder94422873binder
biogen9310253biogen
birded104414303birded
birder94915493birder
birdmen1235833birdmen
bitten84715123bitten
budded113912333budded
budder104314813budder
burden9412473burden
cider84723313ci_der
cinder94119123cinder
codded114515303codded
codder104416343codder
coden86128543_coden
deaden83714323deaden
den47554343___den
diadem1037583diadem
diddle94915213diddle
diddled114212053diddled
diddler103511513diddler
diddles103915073diddles
diddley13388103diddley
diddly12389573diddly
didie74120563didie_
didies84621833didies
didoes85716963didoes
diode74716113diode_
diodes83915783diodes
dizen155214933di_zen
dodder94712913dodder
dudeen857173dudeen
eide55832243ei_de_
eider64624743ei_der
fiddle113613383fiddle
fiddled13329633fiddled
fiddler12309953fiddler
fiddles123212603fiddles
fiddly14328483fiddly
fidge104516063fidge_
fidged124610933fidged
fidges114114393fidges
fidget114216483fidget
finder104020233finder
fodder114712113fodder
gadded103913173gadded
gadder93714713gadder
garden84215083garden
giddap1143413giddap
giddied11257713giddied
giddier10308723giddier
giddies103713363giddies
giddy115810203gidd_y
gien56330023gi__en
gilded94413223gilded
gilder84415533gilder
girded93712493girded
girder84312063girder
given95915283gi_ven
gladden10376313gladden
godded104811803godded
golden84411153golden
gridded11387583gridded
gridder10367763gridder
gulden8328763gulden
harden105718533harden
hiddenly1642393hiddenly
hide85134643hi_de_
hided105222443hi_ded
hider95024083hi_der
hides95129423hi_des
hinder104120063hinder
hitmen11239193hitmen
hoddens12378803hoddens
hoddin11369943hoddin
hoiden103612333hoiden
holden104113953holden
hoyden13328933hoyden
idea59122773_i_dea
idem76121063_i_dem
ides57734233_i_des
idle55423763_idle_
idled74915213_idled
idler65015663_idler
idles66720123_idles
imide85716893imide_
imides94515343imides
indene73215373_indene
indent73021243_indent
index13310983_index
iodin64419353_iodin
judder15439423judder
kidders13399173kidders
kiddie12359393kiddie
kiddies133412283kiddies
kidding14389773kidding
kiddo11398953kidd_o
kiddoes13387063kiddoes
kiddos12416863kiddos
kiddy144910283kidd_y
kidney1434763kidney
kinder113716843kinder
kippen14299013kippen
kitten104611483kitten
ladder84617623ladder
laden65022193_laden
leaden74515223leaden
lichen114012743lichen
lidding103611433lidding
lieder74912323lieder
lien45339803li__en
liken911818843li_ken
limen75426033li_men
lindens839413lindens
linen55728723li_nen
lippen103911403lippen
listen64816813listen
litten64014873litten
liven85021733li_ven
loden66621143_loden
louden73711793louden
maddened1334893maddened
madders113513213madders
maddest112311213maddest
madding123711993madding
made75440243m_ade_
madman113712383madman
madre85720173madre_
madres93718183madres
maidens10349663maidens
mailmen1137273mailmen
marten84518263marten
maven104816893m_aven
meddle103312763meddle
meddled123210033meddled
meddler11319953meddler
meddles113213253meddles
median94117543median
medley1298343medley
melded104714713melded
melder93915813melder
men59252853m___en
mended104418683mended
mender93520793mender
merde84320123merde_
merdes94518603merdes
mermen10813813mermen
mice87442233mi_ce_
miche126219243miche_
miched143913393miched
miches134320733miches
mickey174211853mickey
micron103714283micron
mid67354473mi_d__
midair937993midair
midcap1336473midcap
middays14335663middays
middleman1542053middleman
middlemen1542733middlemen
middlers123410193middlers
middling13249343middling
midgets113910253midgets
midgut103510053midgut
midi75628483mi_d_i
midiron1046003midiron
midis85923413mi_dis
midland1136613midland
midlegs1156323midlegs
midline102315103midline
midnoon1044683midnoon
midrib1138243midrib
mids76541793mi_d_s
midst85922553mi_dst
midsts95510053midsts
midterm12316013midterm
midtown1343673midtown
midway15327153midway
midweek1743273midweek
midyear1343343midyear
miens76118303mi__ens
miffed15398713miffed
mignon937953mignon
mike105535293mi_ke_
miked125020453mi_ked
mikes115129893mi_kes
mikron12318503mikron
mikveh18132543mikveh
mild75330853mild__
mildened1235773mildened
mildest102812063mildest
mildews13365883mildews
mildewy16353533mildewy
milding113615453milding
mildly12318243mildly
milds86422053mild_s
mile66352573mi_le_
miler75733063mi_ler
miles74645073mi_les
milieu8314113milieu
milked134612573milked
milker124814323milker
milkmen1565213milkmen
mille75029133mille_
milled94326173milled
miller84625413miller
milles84526563milles
millet84030743millet
milneb1095953milneb
milted93919943milted
milter84921233milter
mime85736403mi_me_
mimed105622733mi_med
mimeo96018683mi_meo
mimer94825763mi_mer
mimes95732023mi_mes
minae75627723minae_
mince95325233mince_
minced114114913minced
mincer104017363mincer
minces104420803minces
mind75434383mind__
minders103720123minders
minding113317893minding
minds85427123mind_s
mindset10313343mindset
mine67256173mi_ne_
mined85333353mi_ned
miner76933543mi_ner
mines75651953mi_nes
minion83416243minion
minke115421763minke_
minkes124618783minkes
minted94220583minted
minter84425103minter
minuend1035383minuend
minuet82621033minuet
minxes154612983minxes
minyan1138173minyan
miocene1147923miocene
mioses84318853mioses
mire66748233mi_re_
mired85729223mi_red
mires75640883mi_res
mirex146816623mi_rex
mirier83918363mirier
mirin75023153mi_rin
mirker123712693mirker
misadded1335753misadded
misdeal1037663misdeal
misdeed113211053misdeed
misdeem12217873misdeem
misdid10510573misdid
misdo85413183misd_o
misdoer1048633misdoer
misdoes10312493misdoes
misdone10310863misdone
misdrew1335833misdrew
mise66043583mi_se_
miser75430403mi_ser
mises74740563mi_ses
misfed124113023misfed
misled94719313misled
mismet103722373mismet
mispens11311073mispens
missed94423603missed
missel85216523missel
missend104411373missend
missent94318713missent
misses85130873misses
misset85028153misset
misted93625823misted
mistend103812523mistend
mister84728563mister
mite66249413mi_te_
miter75734793mi_ter
mites75141803mi_tes
mither114218563mither
mitier83620673mitier
mitogen1036963mitogen
mitre75522423mitre_
mitred94414343mitred
mitres83922073mitres
mittens9349883mittens
mixed155717253mi_xed
mixer145017643mi_xer
mixes147224403mi_xes
mizens174610253mi_zens
mizzens17366123mizzens
mode75840303m_ode_
model84521693m_odel
modem103717143m_odem
modern939523modern
modes85537413m_odes
moisten93110143moisten
molded104414083molded
molder93819273molder
molten83311813molten
monde85723143monde_
mondes94322353mondes
mordent10313993mordent
moreen8313343moreen
morgen9312203morgen
mudders113211113mudders
muddied12339213muddied
muddier114110023muddier
muddies113513953muddies
mudding123310813mudding
muddle103414633muddle
muddled124111593muddled
muddler113411623muddler
muddles112914353muddles
muddly13418603muddly
muddy123812233mudd_y
mudhens1335103mudhens
mueddin1143423mueddin
mullen83714763mullen
murder93613783murder
nide55535793ni_de_
nided75920873ni_ded
nides65229133ni_des
nidget83715643nidget
nodded94012123nodded
nodder84811943nodder
odder74515393_odder
oilmen848313oilmen
olden65114853_olden
padded114113503padded
padder103415493padder
piddle103514913piddle
piddled123311253piddled
piddler112911523piddler
piddles114314273piddles
piddly13319143piddly
pidgin10259813pidgin
pigpen1136583pigpen
pinder94523453pinder
pinken124513283pinken
pitmen102510793pitmen
podded115012713podded
radded94716493radded
rebidden1243033rebidden
redded94019553redded
reddens9259783reddens
redder83918143redder
richen113812513richen
ridders93612493ridders
ridding103314193ridding
riddle83915713riddle
riddled103012043riddled
riddler93411263riddler
riddles93215023riddles
ride55945133ri_de_
rident7520193ri_dent
rider65231303ri_der
rides66140813ri_des
ridge75018673ridge_
ridged94014223ridged
ridgel8399973ridgel
ridges85817013ridges
ridley10169543ridley
rinded84418983rinded
ripen75619263ri_pen
risen54621883ri_sen
riven85121623ri_ven
rodded93713703rodded
rodmen939713rodmen
rudder83812803rudder
saddens9309603saddens
sadder82916973sadder
shodden12265763shodden
sicken124615253sicken
siddur834573siddur
side55444493si_de_
sided74825953si_ded
sidemen1037943sidemen
sides65838363si_des
sidhe95315103sidhe_
sidle65124033sidle_
sidled84215173sidled
sidler74716963sidler
sidles74721153sidles
silken104410853silken
siren54525823si_ren
sitten64113823sitten
skidded1465083skidded
skidder1365733skidder
smidge10378483smidge_
smidgens12325643smidgens
smidgeon12303273smidgeon
smidges11448193smidges
smidgin11335103smidgin
smitten936693smitten
sodded94113303sodded
soddens9348413soddens
stridden1044273stridden
suddens9308783suddens
swiddens1342713swiddens
tedded93810903tedded
tedder83312163tedder
tiddler93110003tiddler
tiddly11308783tiddly
tide55237383ti_de_
tided76322513ti_ded
tides64830153ti_des
tidied83613273tidied
tidier73515113tidier
tidies74721833tidies
tilde65017343tilde_
tildes74513963tildes
tinder73821803tinder
tinmen82310403tinmen
titmen8239883titmen
trodden934883trodden
udder76314283_udder
unbidden1263573unbidden
vide85432763vi_de_
video96014953vi_deo
vimen104114753vi_men
vixen153010023vi_xen
wadded124014173wadded
wadder114215483wadder
warden104515513warden
wedded123811843wedded
wedder113612303wedder
whidded1634423whidded
widders123512273widders
widdie113410733widdie
widdies123514033widdies
widdle113814843widdle
widdled133511233widdled
widdles123514343widdles
widdy136112183widd_y
wide85235413wi_de_
widens106212723wi_dens
wider94826353wi_der
wides94832823wi_des
widgeon1244143widgeon
widget113815263widget
wilded113714503wilded
wilder103616473wilder
winded114918213winded
winder104025263winder
wizen175813863wi_zen
wizzen17387203wizzen
wooden103610303wooden

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127165304.92322895.8
3Display Results5305300.1862849.5
 (SQL Overall)1786915305.49932495.2
 
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.