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

479 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
meddles11321325(None) 
heddles123311621heddles
meddle103312761meddle_
meddled123210021meddled
meddler11319951meddler
meddlers12318201meddlers
middles113415301middles
muddles112914351muddles
peddles112913691peddles
reddles93315771reddles
addles84216602_addles
aediles83413892aediles
beadles103414722beadles
buddles113913072buddles
coddles114213592coddles
cuddles114014092cuddles
daddles104213802daddles
diddles103915072diddles
eddies83313162_eddies
eddoes8199142_eddoes
ediles74016972_ediles
fiddles123212602fiddles
fuddles123611932fuddles
heddle114211162heddle_
huddles123712572huddles
measles92412752measles
medaled113411602medaled
medals94218042medal_s
medflies1435552medflies
medley1298332me_dley
medleys13115332me_dleys
merdes94518602merd_es
merles85322762me_rles
mettles94115022mettles
middies113116152middies
middle103414982middle_
middled123311892middled
middler112712272middler
middlers123410192middlers
modules102511002modules
muddies113513942muddies
muddle103414632muddle_
muddled124111582muddled
muddler113411622muddler
muddlers12428802muddlers
neddies92710702neddies
needles83211562needles
noddles92911292noddles
paddles113515632paddles
peddle103512822peddle_
peddled123410532peddled
peddler113210492peddler
peddlers12298532peddlers
piddles114314272piddles
puddles113613822puddles
raddles93615702raddles
reddle83815912reddle_
reddled102912322reddled
riddles93215022riddles
ruddles92813872ruddles
saddles95415742saddles
teddies92711282teddies
toddles93211532toddles
treddles1036262treddles
waddles124314842waddles
widdles123514342widdles
addle74318353_addle_
addled94112513_addled
aedes64625143ae_d_es
aedile73716653aedile_
audiles83112613audiles
baddies114017873baddies
beadle93314683beadle_
beagles103212123beagles
bedded115114063bedd_ed
bedder104215783bedd_er
bedders113513383bedders
bedells10379363bedells
bedels94015273bedel_s
bedless1039703be_dless
beedies10314203beedies
beetles9312083beetles
befuddles1642023befuddles
belles85325993be_lles
bemuddles1542453bemuddles
bendees103913863bendees
biddies113514493biddies
bindles104016453bindles
boodles103416043boodles
bridles104114473bridles
buddies113914353buddies
buddle104313083buddle_
bundles103515773bundles
caddies113718383caddies
candles104422343candles
caudles103912813caudles
cedes84927323ce_d_es
cedulas1058503cedulas
coddle104713853coddle_
coddled123410573coddled
coddler113710823coddler
coddlers12359163coddlers
cradles103114123cradles
cuddies113313263cuddies
cuddle104414533cuddle_
cuddled124110763cuddled
cuddler113810743cuddler
cuddlers12388383cuddlers
curdles103814573curdles
daddies103414943daddies
daddle94214283daddle_
daddled113810743daddled
dales66439743__dales
dandles94218533dandles
dawdles12379163dawdles
deciles104417713deciles
deckles143312803deckles
deduces1168793deduces
deedless10318253deedless
defiles114016843defiles
deles65139253__deles
diddle94915213diddle_
diddled114212053diddled
diddler103511513diddler
diddlers11359153diddlers
diddley13388103diddley
diddleys14334633diddleys
diddlies1137593diddlies
dindles93817243dindles
doles67843753__doles
doodles93614163doodles
eagles73819163_eagles
eddied9248323_eddied
edges75718723_e_dges
edibles1047993_edibles
edile64819493_edile_
educes94011953_educes
empales112411433empales
emydes1236173emyd_es
endless839833_endless
endues73813903_endues
exiles134816403_exiles
fedexes1835473fedexes
females12310663females
ferules103112723ferules
fettles103912733fettles
fiddle113613383fiddle_
fiddled13329633fiddled
fiddler12309953fiddler
fiddlers13328283fiddlers
fondles113512613fondles
fuddies123211203fuddies
fuddle113312103fuddle_
fuddled13309393fuddled
gentles83714343gentles
geodes8412153geod_es
giddies103713363giddies
girdles92210003girdles
griddles1145753griddles
handles114020653handles
headless12289863headless
heckles163711383heckles
hedges115016243he_dges
heedless12278813heedless
hondles113614523hondles
huddle113712993huddle_
huddled13349783huddled
huddler12379423huddler
huddlers13337633huddlers
hurdles113613373hurdles
idles66720123__idles
indoles83716363indoles
keckles12318763keckles
keddahs1642923keddahs
kedges124812943ke_dges
kettles113411613kettles
kiddies133412283kiddies
kiddoes13387063kiddoes
kindles123614843kindles
laddies93715053laddies
ladles74619543_ladles
leadless9248793leadless
ledges84917983le_dges
leudes75314093leud_es
mackles154415753mackles
macles107023223m_acles
macules114015133macules
madames12310063madames
madded113513553madd_ed
madden103912523madd_en
maddens11359753maddens
madder103515593madd_er
madders113513213madders
maddest112311213madd_est
madres93718183m_adres
mailes84329113m_ailes
males75049793m__ales
mangles104021463mangles
mantles94820703mantles
maples104819423m_aples
marbles114516653marbles
meadows1337333meadows
meads85425323mead__s
mealies92821933mealies
mealless10288363mealless
meals75933373me_al_s
meanies93620743meanies
measle83513223measle_
measled10339303measled
meatless103410863meatless
medakas1435763medakas
medal86221323medal__
medalist11414203medalist
medalled1246883medalled
meddlesome1651743meddlesome
meddling13257933meddling
medfly1535223medfl_y
mediae94217413mediae_
medials103914733medials
medians103214213medians
medias93620783me_dias
mediates112814063mediates
medicks16368413medicks
medicos12339833medicos
medics114115353me_dics
medinas103411463medinas
mediums12308723mediums
medius93613283me_dius
medlar93010463me_dlar
medlars10259443medlars
meds75735363me_d__s
medulla1044713medulla
medullas1144513medullas
medusas1036213medusas
meeds84920273meed__s
megilps1233563megilps
meikle1236653meikle_
meinies92516073meinies
meioses9310833meioses
melded104714713meld_ed
melder93915813meld_er
melders103213913melders
melds84822383me__lds
melee73729103me__lee
melees83618083me_lees
melled95023023me_lled
mells75031333me__lls
melodies11310123melodies
mels65941533me__l_s
melts74930103me__lts
memes94927703me__mes
menaces112715523menaces
menages103615393menages
mended104418683mend_ed
mender93520793mend_er
menders103818803menders
mends84927693mend__s
menses84222453me_nses
menshes12310443menshes
mentees93214503mentees
merces105720743me_rces
merches144013763merches
mercies113817563mercies
merde84320123merd_e_
meres75143573me__res
mergees104411233mergees
merges94122483me_rges
merises93421423merises
merle75824373me_rle_
merls77423903me_rl_s
mesdames1346043mesdames
meshes115019443me_shes
mesnes85216213me_snes
messes84924343me_sses
mestees94617753mestees
metages102714973metages
metaled102913873metaled
metals84520883metal_s
metates92720003metates
metes74736213me__tes
metols84115773metol_s
metopes11311363metopes
metres85121563me_tres
mettle83815723mettle_
mettled103510543mettled
mewled123710053me_wled
mewler113510233me_wler
mewlers12288983me_wlers
mewls105813233me_wl_s
mezes167719263me__zes
mickles153415003mickles
middays14335663middays
midden104112853midd_en
middens11379373middens
midges103516473m_idges
midleg1038553m_idleg
midlegs1156323m_idlegs
midsoles1137763midsoles
miggles113512033miggles
miles74645073m__iles
milles84526563m_illes
mindless11319443mindless
mingles103719003mingles
misdoes10312493misdoes
mizzles17329493mizzles
mobiles112813123mobiles
modals93914443modal_s
modeled1139453modeled
modeler1039293modeler
modelers1138463modelers
models94216353model_s
modes85537413m_od_es
module93011033module_
modulus10245333modulus
moles74747923m__oles
mondes94322353mond_es
morales93619403morales
motiles93317433motiles
mottles93415803mottles
muckles153413253muckles
mudded114511383mudd_ed
mudder104413493mudd_er
mudders113211103mudders
muddied12339213muddied
muddier114110013muddier
muddiest12298733muddiest
muddly13418603muddl_y
mudholes1444873mudholes
mueddins1243483mueddins
muffles153910443muffles
mules75034293m__ules
mumbles133014433mumbles
muscles11310563muscles
mutules9311843mutules
muzzles17299683muzzles
myceles1435213myceles
myrtles1235733myrtles
needle73310613needle_
needled9358513needled
needler8388893needler
needlers9287423needlers
needless9308333needless
nestles73015463nestles
nettles73214083nettles
noddies93512043noddies
noddle83211363noddle_
noddled10358563noddled
nodules8269703nodules
noodles83513193noodles
odyles10348563_odyles
oodles73517183_oodles
paddies113715723paddies
paddle104615143paddle_
paddled123612023paddled
paddler113711553paddler
paddlers12329153paddlers
padles95221113_padles
pebbles1337573pebbles
pedaled113711873pedaled
pedaler103410693pedaler
pedalers11239393pedalers
pedalos10329683pedalos
pedals94316033pedal_s
peddlery15224003peddlery
pedes85327283pe_d_es
pedicles1338663pedicles
pedler93614613pe_dler
pedlers103013273pe_dlers
peles75738083pe__les
peoples11312213peoples
perdues103511333perdues
pestles93217693pestles
pettles93916483pettles
piddle103514913piddle_
piddled123311253piddled
piddler112911523piddler
piddlers12359593piddlers
poodles103013513poodles
puddle103914153puddle_
puddled123011193puddled
puddler112910753puddler
puddlers12298683puddlers
raddle84816173raddle_
raddled103812223raddled
readies83324703readies
reales64934123re_ales
redates83423863redates
redded94019543redd_ed
redden83613613redd_en
reddens9259783reddens
redder83918133redd_er
redders93615343redders
reddest9311953redd_est
redds74617833redd__s
redes65139123re_d_es
redeyes112910973redeyes
redleg839263re_dleg
redlegs936823re_dlegs
redoes74623753re_does
redoxes15310883redoxes
redries83721713redries
reduces10513343reduces
redyes104214083re_dyes
refiles104122423refiles
regales83520793regales
resaddles11114683resaddles
resales74724903resales
resiles74026543resiles
resoles73823653resoles
retiles74426993retiles
reviles104421353reviles
riddle83915713riddle_
riddled103012043riddled
riddler93411263riddler
riddlers10269103riddlers
ruddle83414203ruddle_
ruddled103010873ruddled
rundles83214713rundles
saddle83915493saddle_
saddled103112033saddled
saddler93811963saddler
saddlers10289753saddlers
sedates83418033sedates
sedges83817793se_dges
sedile73517233sedile_
seduces1069283seduces
seedless9319513seedless
seidels838393seidels
selles64426983se_lles
seniles72618023seniles
settles73916003settles
sidles74721153_sidles
smeddums1441983smeddums
soddies92312853soddies
staddles10258693staddles
swaddles13296453swaddles
teazles16308913teazles
tedded93810893tedd_ed
tedder83312153tedd_er
tedders94010233tedders
teles54536003te__les
temples112610893temples
tiddler93110003tiddler
tiddlers10288653tiddlers
toddies93011993toddies
toddle85811033toddle_
toddled10328823toddled
toddler9379043toddler
toddlers10346953toddlers
treadles939693treadles
treddle936433treddle_
treddled1134473treddled
twaddles13315723twaddles
tweedles1234113tweedles
twiddles13265613twiddles
vendees114011453vendees
vendues11318623vendues
venules104011483venules
waddies124214753waddies
waddle114715303waddle_
waddled133611643waddled
waddler124010793waddler
waddlers13298333waddlers
wedded123811833wedd_ed
wedder113612293wedd_er
wedders123610723wedders
wedeled1237783wedeled
wedelns11325243wedelns
wedels103811033wedel_s
wedges114614553we_dges
wedgies123910203wedgies
weedless12287963weedless
weldless12285813weldless
wheedles1534643wheedles
widdies123514033widdies
widdle113814843widdle_
widdled133511233widdled
windles113518493windles
yodles103714333_yodles

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.1561145455.1
2DLD Change Limit1340274796.97019229.1
3Display Results4794790.1862575.3
 (SQL Overall)1786914797.31224438.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.