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

459 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
riddler9341126(None) 
diddler103511511diddler
fiddler12309951fiddler
middler112712271middler
piddler112911521piddler
ridder84015141ridd_er
riddle83915711riddle_
riddled103012041riddled
riddlers10269101riddlers
riddles93215021riddles
tiddler93110001tiddler
bidder104114862bidd_er
bridler103811072bri_dler
coddler113710832coddler
cuddler113810742cuddler
diddle94915212diddle_
diddled114212052diddled
diddlers11359152diddlers
diddles103915072diddles
diddley13388102diddley
fiddle113613382fiddle_
fiddled13329632fiddled
fiddlers13328282fiddlers
fiddles123212602fiddles
giddier10308722giddier
girdler9227312girdler
gridder10367762gridd_er
griddle1035502griddle_
griddled1244202griddled
griddles1145752griddles
huddler12379422huddler
idler65015662_i_dler
kidder123811092kidd_er
kindler12309982kindler
meddler11319952meddler
middle103414982middle_
middled123311902middled
middlers123410192middlers
middles113415302middles
muddler113411622muddler
paddler113711552paddler
peddler113210492peddler
piddle103514912piddle_
piddled123311252piddled
piddlers12359592piddlers
piddles114314272piddles
puddler112910752puddler
raddle84816172raddle_
raddled103812222raddled
raddles93615702raddles
redder83918132redd_er
reddle83815912reddle_
reddled102912322reddled
reddles93315772reddles
ridded93615122ridd_ed
ridden83511722ridd_en
ridders93612492ridd_ers
rider65231302ri_d_er
ridgier937882ridgier
ridley10169542ri_dley
riffler13328352riffler
rifler94014262ri_fler
rippler113210102rippler
rudder83812802rudd_er
ruddier9338522ruddier
ruddle83414202ruddle_
ruddled103010872ruddled
ruddles92813872ruddles
saddler93811962saddler
sidler74716962si_dler
tiddlers10288652tiddlers
toddler9379042toddler
twiddler13244872twiddler
unriddler1142782unriddler
waddler124010792waddler
widder112913972widd_er
widdle113814842widdle_
widdled133511232widdled
widdles123514342widdles
adder75419593_add_er
addle74318353_addle_
addled94112523_addled
addles84216603_addles
aider65431133ai_d_er
arider74717743ari_d_er
badder103817513badd_er
bedder104215783bedd_er
bidden104010793bidd_en
bidders114012313bidd_ers
biddies113514493biddies
bider85728373bi_d_er
biller84923483bi_ller
binder94422873bind_er
bindle94516263bindle_
bindles104016453bindles
birder94915493bird_er
birler85715083bi_rler
boodler103312003boodler
bridle94115463bri_dle_
bridled113611143bri_dled
bridlers11359183bri_dlers
bridles104114473bri_dles
brindle104210103brindle_
brindled12407853brindled
brindles113710223brindles
brittler10165983brittler
budder104314813budd_er
buddle104313083buddle_
buddles113913073buddles
bundler104011723bundler
candler103516593candler
cider84723313ci_d_er
cinder94119123cind_er
circler1136423circler
codder104416343codd_er
coddle104713853coddle_
coddled123410573coddled
coddlers12359173coddlers
coddles114213593coddles
cradler102910513cradler
crippler14826713crippler
cruddier1244153cruddier
cuddle104414533cuddle_
cuddled124110763cuddled
cuddlers12388383cuddlers
cuddles114014093cuddles
cuddlier1234013cuddlier
curdler103511563curdler
daddle94214283daddle_
daddled113810743daddled
daddles104213803daddles
dandler94414273dandler
dawdler12356793dawdler
dialer74315433di_aler
dialler848813dialler
dibbler124510283dibbler
diddleys14334633diddleys
diddlies1137593diddlies
diddly12389573diddl_y
dindle84417223dindle_
dindled104412723dindled
dindles93817243dindles
dodder94712913dodd_er
doodler93310153doodler
dribbler13316313dribbler
driller84311883dri_ller
driveler1284693driveler
eider64624743ei_d_er
faddier1237783faddier
fickler16348423fickler
fiddly14328483fiddl_y
fielder11217413fielder
filer85433003fi__ler
filler94623623fi_ller
finder104020233find_er
fodder114712113fodd_er
fondler11348883fondler
fribbler15265953fribbler
friller104111743fri_ller
frivoler1443933frivoler
frizzler19345843frizzler
fuddle113312103fuddle_
fuddled13309393fuddled
fuddles123611933fuddles
gadder93714713gadd_er
giddied11257713giddied
giddies103713363giddies
giggler101029883giggler
gilder84415533gild_er
giller74519733gi_ller
girder84312063gird_er
girdle82110463girdle_
girdled10217453girdled
girdlers10195403girdlers
girdles92210003girdles
gridded11387583gridd_ed
gridders11286293gridd_ers
griller84513353gri_ller
grinder93312393grind_er
grizzler17335033grizzler
handler113516163handler
heddle114211163heddle_
heddles123311623heddles
hidden11429743hidd_en
hider95024083hi_d_er
higgler12369803higgler
hiller94421633hi_ller
hinder104120063hind_er
huddle113712993huddle_
huddled13349783huddled
huddlers13337633huddlers
huddles123712573huddles
hurdler113610003hurdler
idle55423763_i_dle_
idled74915213_i_dled
idlers74012813_i_dlers
idles66720123_i_dles
iller54821293_i_ller
jingler154311093jingler
judder15439423judd_er
kidded13299383kidd_ed
kidders13399173kidd_ers
kiddie12359393kiddie_
kiddies133412283kiddies
kiddoes13387063kiddoes
killer104917953ki_ller
kinder113716843kind_er
kindle114414233kindle_
kindled133410543kindled
kindlers13318483kindlers
kindles123614843kindles
kindlier1345763kindlier
kittler11338163kittler
ladder84617623ladd_er
ladler74314933_ladler
landler84113203landler
libeler9219003libeler
lidded93410243lidd_ed
lieder74912323lied_er
littler7348553littler
madder103515593madd_er
meddle103312763meddle_
meddled123210033meddled
meddlers12318203meddlers
meddles113213253meddles
mickler153310233mickler
midden104112853midd_en
middies113116153middies
midleg1038553mi_dleg
milder93818453mild_er
miler75733063mi__ler
miller84625413mi_ller
minder94822503mind_er
mingler104213843mingler
misdoer1048633misdoer
modeler1039293modeler
mudder104413493mudd_er
muddier114110023muddier
muddle103414633muddle_
muddled124111593muddled
muddlers12428813muddlers
muddles112914353muddles
needler8388893needler
nibbler11379273nibbler
niggler93610293niggler
nimbler11358063nimbler
nodder84811943nodd_er
noddle83211363noddle_
noddled10358563noddled
noddles92911293noddles
odder74515393_odd_er
oiler54628283oi__ler
padder103415493padd_er
paddle104615143paddle_
paddled123612023paddled
paddlers12329153paddlers
paddles113515643paddles
pedaler103410693pedaler
peddle103512823peddle_
peddled123410543peddled
peddlers12298533peddlers
peddlery15224013peddlery
peddles112913703peddles
pedler93614613_pedler
piddly13319143piddl_y
pinder94523453pind_er
prodder1147953prodd_er
puddle103914153puddle_
puddled123011193puddled
puddlers12298683puddlers
puddles113613823puddles
puddlier1234213puddlier
rabbler113514093rabbler
radded94716493radd_ed
radular837833radular
raffler13339223raffler
raider74318743raid_er
railer64524933r_ailer
rambler113313263rambler
randier83618473randier
rattler74012743rattler
raveler104212463raveler
reader73628293read_er
readier83117423readier
realer63528593r_ealer
redded94019543redd_ed
redden83613613redd_en
redders93615343redd_ers
redleg839263r_edleg
reducer1059003reducer
reedier83815303reedier
reeler63822573r_eeler
regaler83814623regaler
reindeer936293reindeer
render74024143rend_er
reveler104116343reveler
reviler104314973reviler
ribber103515493ri_bber
ribbier1137593ribbier
ribier84414233ri_bier
riblet84222443ri_blet
ricer74726613ri__cer
richer114015043ri_cher
ridable101412493ridable_
ridding103314193ridding
riddling11249443riddling
ride55945123ri_d_e_
riders74123903ri_d_ers
rides66140813ri_d_es
ridge75018663ri_dge_
ridged94014213ri_dged
ridgel8399963ri_dgel
ridgels9348023ridgels
ridges85817003ri_dges
ridiculer1242593ridiculer
ridleys11145783ri_dleys
riever94811653ri_ever
rifer84721983ri__fer
riffle124210233riffle_
riffled14338603riffled
rifflers14336443rifflers
riffles133911163riffles
rifle85518333ri_fle_
rifled104115003ri_fled
riflers103512193ri_flers
riflery13345803ri_flery
rifles94217703ri_fles
rigger85616713ri_gger
righter113212383righter
rile45650533ri__le_
riled65833253ri__led
riles55343643ri__les
riley84420583ri__ley
rille55728733ri_lle_
rilled74525653ri_lled
rilles64725503ri_lles
rillet64828853ri_llet
rimer75429243ri__mer
rimier83916273ri_mier
rimmer103516033ri_mmer
rimple103814583rimple_
rimpled123311423rimpled
rimples113114223rimples
rinded84418983rind_ed
rindless92510193rindless
ringer74526063ri_nger
ringlet82818173ringlet
rinser64317213ri_nser
rioter64817283ri_oter
ripener937903ripener
riper74328403ri__per
ripper103518653ri_pper
ripple103413913ripple_
rippled123110273rippled
ripplers12337113ripplers
ripples113513293ripples
ripplet113412583ripplet
ripplier1234463ripplier
riser55431053ri__ser
risker105414493ri_sker
riskier1138423riskier
ritter63822423ri_tter
ritzier16297203ritzier
rivaled1138933rivaled
river85731693ri__ver
riveter10208753riveter
rivulet1069723rivulet
rodded93713703rodd_ed
roller63919793r_oller
rowdier11348593rowdier
rudders93210653rudd_ers
ruder65320543r_ud_er
ruffler13369723ruffler
ruler54923343r__uler
rumbler113514113rumbler
rundle73214233rundle_
rundles83214713rundles
rundlet83114153rundlet
rustler73512343rustler
sadder82916973sadd_er
saddle83915493saddle_
saddled103112033saddled
saddlers10289753saddlers
saddlery13274913saddlery
saddles95415743saddles
siddur834573sidd_ur
sidle65124033si_dle_
sidled84215173si_dled
sidlers83414233si_dlers
sidles74721153si_dles
siller64026063si_ller
simpler112910863simpler
sizzler15266863sizzler
skidder1365733skidd_er
skiddier1464193skiddier
spindler11297983spindler
straddler11205113straddler
swindler12257723swindler
tedder83312153tedd_er
tickler133612653tickler
tiddly11308783tiddl_y
tidier73515113ti_dier
tiler56131023ti__ler
tiller64222543ti_ller
tinder73821803tind_er
tingler83613343tingler
tinkler113610543tinkler
tippler11348343tippler
toddle85811033toddle_
toddled10328823toddled
toddlers10346963toddlers
toddles93211533toddles
treadler936863treadler
treddle936433treddle_
treddled1134473treddled
treddles1036263treddles
trifler103912153tri_fler
triller74215893tri_ller
trindle83311363trindle_
trindled10388693trindled
trindles93211683trindles
trundler9256153trundler
twaddler13314643twaddler
twiddle12305483twiddle_
twiddled14284633twiddled
twiddlers14313693twiddlers
twiddles13265613twiddles
twiddlier1441863twiddlier
udder76314283_udd_er
unriddle1043983unriddle_
unriddled1243813unriddled
unriddlers1241823unriddlers
unriddles1143503unriddles
viler86324163vi__ler
wadder114215483wadd_er
waddle114715303waddle_
waddled133611643waddled
waddlers13298333waddlers
waddles124314843waddles
wedder113612293wedd_er
widders123512273widd_ers
widdie113410733widdie_
widdies123514033widdies
widener11318693widener
wider94826353wi_d_er
widower1435343widower
wielder11197673wielder
wiggler123110763wiggler
wilder103616473wild_er
willer94021063wi_ller
winder104025263wind_er
windier113412163windier
windle104617953windle_
windled123713483windled
windles113518493windles
wriggler13295263wriggler
yielder11175113yielder
yodeler1136343yodeler
yodler10389943_yodler

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.390458182.1
2DLD Change Limit1340274596.18621666.2
3Display Results4594590.1562942.3
 (SQL Overall)1786914596.73226543.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.