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

484 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
diddles10391507(None) 
daddles104213801daddles
diddle94915211diddle_
diddled114212051diddled
diddler103511511diddler
diddlers11359151diddlers
diddley13388101diddley
diddleys14334631diddleys
diddlies1137591diddlies
dindles93817241dindles
fiddles123212601fiddles
middles113415301middles
piddles114314271piddles
riddles93215021riddles
widdles123514341widdles
addles84216602_addles
biddies113514492biddies
bindles104016452bindles
buddles113913072buddles
coddles114213592coddles
cuddles114014092cuddles
daddies103414942daddies
daddle94214282daddle_
daddled113810742daddled
dandles94218532dandles
dawdles12379162dawdles
dibbles124013332dibbles
diddly12389572diddl_y
didies84621832di_dies
didoes85716962di_does
dildoes9229232dildoes
dimples122813212dimples
dindle84417222dindle_
dindled104412722dindled
dingles93818322dingles
diodes83915782diod_es
dipoles101013752dipoles
doodles93614162doodles
dwindles13366022dwindles
fiddle113613382fiddle_
fiddled13329632fiddled
fiddler12309952fiddler
fiddlers13328282fiddlers
fuddles123611932fuddles
giddies103713362giddies
girdles92210002girdles
griddles1145752griddles
heddles123311622heddles
huddles123712572huddles
idles66720122_i_dles
kiddies133412282kiddies
kiddoes13387062kiddoes
kindles123614842kindles
meddles113213252meddles
middies113116152middies
middle103414982middle_
middled123311892middled
middler112712272middler
middlers123410192middlers
muddles112914352muddles
noddles92911292noddles
paddles113515632paddles
peddles112913692peddles
piddle103514912piddle_
piddled123311252piddled
piddler112911522piddler
piddlers12359592piddlers
puddles113613822puddles
raddles93615702raddles
reddles93315772reddles
riddle83915712riddle_
riddled103012042riddled
riddler93411262riddler
riddlers10269102riddlers
ruddles92813872ruddles
saddles95415742saddles
sidles74721152si_dles
tiddler93110002tiddler
tiddlers10288652tiddlers
toddles93211532toddles
twiddles13265612twiddles
waddles124314842waddles
widdies123514032widdies
widdle113814842widdle_
widdled133511232widdled
windles113518492windles
addle74318353_addle_
addled94112513_addled
aediles83413893aediles
aides65336603ai_d_es
aidless83612073ai_dless
aisles64721143ai_sles
audiles83112613audiles
baddies114017873baddies
beadles103414723beadles
bibles104617643bi_bles
bidden104010793bidd_en
bidder104114863bidd_er
bidders114012303bidders
bides85536773bi_d_es
biles75542143bi__les
bindle94516263bindle_
birdies104016213birdies
birles84920643bi_rles
boodles103416043boodles
bridles104114473bridles
brindles113710223brindles
buddies113914353buddies
buddle104313083buddle_
bundles103515773bundles
caddies113718383caddies
candles104422343candles
caudles103912813caudles
circles1139903circles
citoles9312553citoles
coddle104713853coddle_
coddled123410573coddled
coddler113710823coddler
coddlers12359163coddlers
cradles103114123cradles
cuddies113313263cuddies
cuddle104414533cuddle_
cuddled124110763cuddled
cuddler113810743cuddler
cuddlers12388383cuddlers
curdles103814573curdles
dabbles124514773dabbles
dadoes85616533d_adoes
daggles103611913daggles
dales66439743__dales
dalles74222063d_alles
dandies94121443dandies
dandle84218093dandle_
dandled103313543dandled
dandler94414273dandler
dandlers103912053dandlers
dangles93618423dangles
dapples1238993dapples
darkles124011933darkles
dartles84014133dartles
dawdle11399503dawdle_
dawdled13376723dawdled
dawdler12356793dawdler
dawdlers13375673dawdlers
dazzles1636413dazzles
deciles104417713deciles
deckles143312803deckles
deduces1168793deduces
deedless10318253deedless
defiles114016843defiles
deles65139253__deles
dholes104914793d_holes
diadem1037583diad_em
diadems1135393diadems
dialed84716453di_aled
dialer74315433di_aler
dialers83614293di_alers
dialled9510133dialled
diallel845683diallel
dialler848813dialler
diallers957773diallers
dials64925343di_al_s
diaries83321953diaries
diazoles1836323diazoles
dibble114013843dibble_
dibbled133510843dibbled
dibbler124510283dibbler
dibblers13377583dibblers
dices86434243di__ces
dickies143416343dickies
didacts1186063didacts
diddling12228733diddling
didie74120563di_die_
didos76820813di_d_os
dienes75719903di_enes
dies55653523di___es
diesels8429143diesels
dieses75218693di_eses
dikdiks1242563dikdiks
dikes105831333di__kes
dilates83220653dilates
dildoe8198673dildoe_
dildos8179303dild_os
dilled84122223di_lled
dillies84122153dillies
dills65530973di__lls
dilutes82911963dilutes
dimes85833043di__mes
dimple113512793dimple_
dimpled132810303dimpled
dines66449153di__nes
dinges83825423di_nges
dingies93618243dingies
dingle84317073dingle_
dingoes94114823dingoes
dinkies123716033dinkies
diode74716113diod_e_
diols65521013di_ol_s
diplex16408053di_plex
diploes101111483diploes
dipodies1238413dipodies
dipole91112853dipole_
dirdums1134383dirdums
dirges84915103di_rges
dirled84514903di_rled
dirls64720503di_rl_s
dirndls933893dirndl_s
dirties83119383dirties
disables11410903disables
dishes104622653di_shes
dismes95617673di_smes
dispels10310503dispels
disses75225963di_sses
disuses84015403disuses
ditches133215713ditches
dites66339153di__tes
ditties83116983ditties
ditzes163212423di_tzes
dives95832403di__ves
divides123211453divides
divines113514723divines
divulges1343603divulges
divulse1134913divulse
divulses1244763divulses
divvies1457663divvies
dizzies16279753dizzies
dodder94712913dodd_er
dodders105511793dodders
dodges96119073d_odges
dodoes85716103d_odoes
doles67843753__doles
dongles93212873dongles
doodies94218773doodies
doodle83212853doodle_
doodled10369463doodled
doodler93310153doodler
doodlers10338843doodlers
dottles83912283dottles
doubles103113353doubles
dowdies123412733dowdies
dredges10379343dredges
dribbles13348393dribbles
drizzles17295293drizzles
drudges10308873drudges
duddie9348863duddie_
dudes75424373d_ud_es
duffles14308913duffles
dwindle12415883dwindle_
dwindled14385023dwindled
eddies83313163_eddies
eddoes8199143_eddoes
edibles1047993edi_bles
ediles74016973_ediles
fiddly14328483fiddl_y
fidges114114383fi_dges
files85441273fi__les
filles94224523fi_lles
fimbles143510653fimbles
finales104016013finales
fipples14298653fipples
fizzles18339063fizzles
fondles113512613fondles
fuddies123211203fuddies
fuddle113312103fuddle_
fuddled13309393fuddled
giddied11257713giddied
giddier10308723giddier
giddiest11298553giddiest
giggles103312933giggles
girdle82110463girdle_
girdled10217453girdled
girdler9227313girdler
girdlers10195403girdlers
griddle1035503griddle_
griddled1244203griddled
handles114020653handles
heddle114211163heddle_
hidden11429743hidd_en
hideless12278713hideless
hides95129423hi_d_es
higgles123911803higgles
hirples12149643hirples
hirsles101510073hirsles
hondles113614523hondles
huddle113712993huddle_
huddled13349783huddled
huddler12379423huddler
huddlers13337633huddlers
hurdles113613373hurdles
ides57734233_i_d_es
idle55423763_i_dle_
idled74915213_i_dled
idler65015663_i_dler
idlers74012813_i_dlers
idlest74014863_i_dlest
idols65514133_idol_s
idylls10425253_idylls
idyls9498803_idyl_s
indies73822773_indies
indoles83716363indoles
indues73515263_indues
ingles74420873_ingles
inkles103515653_inkles
isles54220563_i_sles
istles62814983_istles
ixtles13217063_ixtles
jiggles164111433jiggles
jingles153816383jingles
kibbles153510253kibbles
kidded13299383kidd_ed
kidder123811093kidd_er
kidders13399163kidders
kiddie12359393kiddie_
kiddos12416863kidd_os
kindle114414233kindle_
kindled133410543kindled
kindler12309983kindler
kindlers13318483kindlers
kindless13289243kindless
kirtles11309663kirtles
kittles113012493kittles
laddies93715053laddies
ladles74619543_ladles
lidded93410243lidd_ed
lidless8309273li_dless
ligules82210913ligules
lindies8416583lindies
lisles63416283li_sles
littles73212783littles
meddle103312763meddle_
meddled123210023meddled
meddler11319953meddler
meddlers12318203meddlers
mickles153415003mickles
middays14335663middays
midden104112853midd_en
middens11379373middens
midges103516473mi_dges
midleg1038553mi_dleg
midlegs1156323mi_dlegs
midsoles1137763midsoles
miggles113512033miggles
miles74645073mi__les
milles84526563mi_lles
mindless11319443mindless
mingles103719003mingles
misdoes10312493misdoes
mizzles17329493mizzles
modules102511003modules
muddies113513943muddies
muddle103414633muddle_
muddled124111583muddled
muddler113411623muddler
muddlers12428803muddlers
neddies92710703neddies
needles83211563needles
nibbles114011693nibbles
nickles133713823nickles
nidates8311883nidates
nides65229133ni_d_es
niduses837013niduses
niggles93512203niggles
nipples11319663nipples
noddies93512043noddies
noddle83211363noddle_
noddled10358563noddled
nodules8269703nodules
noodles83513193noodles
odyles10348563_odyles
oodles73517183_oodles
paddies113715723paddies
paddle104615143paddle_
paddled123612023paddled
paddler113711553paddler
paddlers12329153paddlers
padles95221113_padles
peddle103512823peddle_
peddled123410533peddled
peddler113210493peddler
peddlers12298533peddlers
pickles153215443pickles
piddly13319143piddl_y
piffles15368763piffles
piles74742613pi__les
pilules9510623pilules
pimples133012423pimples
pinoles93418703pinoles
pintles94118723pintles
pizzles17329273pizzles
poodles103013513poodles
puddle103914153puddle_
puddled123011193puddled
puddler112910753puddler
puddlers12298683puddlers
raddle84816173raddle_
raddled103812223raddled
reddle83815913reddle_
reddled102912323reddled
ridded93615123ridd_ed
ridden83511723ridd_en
ridder84015143ridd_er
ridders93612483ridders
rides66140813ri_d_es
ridgels9348023ridgels
ridges85817003ri_dges
ridley10169543ri_dley
ridleys11145783ri_dleys
riffles133911163riffles
rifles94217703ri_fles
riles55343643ri__les
rilles64725503ri_lles
rimples113114223rimples
rindless92510193rindless
ripples113513293ripples
ruddle83414203ruddle_
ruddled103010873ruddled
rundles83214713rundles
saddle83915493saddle_
saddled103112033saddled
saddler93811963saddler
saddlers10289753saddlers
sickles133417543sickles
siddurs934173siddurs
sides65838363si_d_es
sidle65124033si_dle_
sidled84215173si_dled
sidler74716963si_dler
sidlers83414223si_dlers
similes92915233similes
simples113014943simples
singles83520433singles
sizzles15349633sizzles
soddies92312853soddies
spindles112710353spindles
staddles10258693staddles
swaddles13296453swaddles
swindles12319503swindles
teddies92711283teddies
tickles133416853tickles
tiddly11308783tiddl_y
tideless9269083tideless
tides64830153ti_d_es
tidies74721833ti_dies
tildes74513963tild_es
tiles55542103ti__les
tingles83818313tingles
tinkles113713923tinkles
tipples112811253tipples
titles63719923ti_tles
tittles73413253tittles
toddies93011993toddies
toddle85811033toddle_
toddled10328823toddled
toddler9379043toddler
toddlers10346953toddlers
treddles1036263treddles
trindles93211683trindles
twaddles13315723twaddles
twiddle12305483twiddle_
twiddled14284633twiddled
twiddler13244873twiddler
twiddlers14313693twiddlers
unriddles1143503unriddles
vittles103211113vittles
waddies124214753waddies
waddle114715303waddle_
waddled133611643waddled
waddler124010793waddler
waddlers13298333waddlers
widder112913973widd_er
widders123512263widders
widdie113410733widdie_
wides94832823wi_d_es
wiggles123312463wiggles
wiles85437873wi__les
wimbles143010843wimbles
wimples143311173wimples
windle104617953windle_
windled123713483windled
windless123310863windless
winkles143412773winkles
wintles103414983wintles
yodles103714333_yodles
zizzles14307093zizzles

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.1561145455.1
2DLD Change Limit1340274845.90622693.4
3Display Results4844840.1702847.1
 (SQL Overall)1786914846.23228673.1
 
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.