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

401 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
fiddler1230995(None) 
diddler103511511diddler
fiddle113613381fiddle_
fiddled13329631fiddled
fiddlers13328281fiddlers
fiddles123212601fiddles
middler112712271middler
piddler112911521piddler
riddler93411261riddler
tiddler93110001tiddler
bidder104114862bidd_er
coddler113710832coddler
cuddler113810742cuddler
diddle94915212diddle_
diddled114212052diddled
diddlers11359152diddlers
diddles103915072diddles
diddley13388102diddley
faddier1237782faddier
fickler16348422fickler
fiddly14328482fiddl_y
fielder11217412fielder
filer85433002fi__ler
filler94623622fi_ller
finder104020232find_er
fodder114712112fodd_er
fondler11348882fondler
fuddle113312102fuddle_
fuddled13309392fuddled
fuddles123611932fuddles
giddier10308722giddier
girdler9227312girdler
huddler12379422huddler
idler65015662_i_dler
kidder123811092kidd_er
kindler12309982kindler
meddler11319952meddler
middle103414982middle_
middled123311902middled
middlers123410192middlers
middles113415302middles
muddler113411622muddler
paddler113711552paddler
peddler113210492peddler
piddle103514912piddle_
piddled123311252piddled
piddlers12359592piddlers
piddles114314272piddles
puddler112910752puddler
ridder84015142ridd_er
riddle83915712riddle_
riddled103012042riddled
riddlers10269102riddlers
riddles93215022riddles
saddler93811962saddler
sidler74716962si_dler
tiddlers10288652tiddlers
toddler9379042toddler
twiddler13244872twiddler
waddler124010792waddler
widder112913972widd_er
widdle113814842widdle_
widdled133511232widdled
widdles123514342widdles
adder75419593_add_er
addle74318353_addle_
addled94112523_addled
addles84216603_addles
aider65431133ai_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
bridler103811073bridler
budder104314813budd_er
buddle104313083buddle_
buddles113913073buddles
bundler104011723bundler
candler103516593candler
cider84723313ci_d_er
cinder94119123cind_er
circler1136423circler
codder104416343codd_er
coddle104713853coddle_
coddled123410573coddled
coddlers12359173coddlers
coddles114213593coddles
cradler102910513cradler
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
eider64624743ei_d_er
fabler116115813f_abler
fader94421513f_ad_er
faller94621233f_aller
feebler1235823feebler
feeder103513843feed_er
feeler93215173f_eeler
feller94419553f_eller
fender103718723fend_er
fibber134811933fi_bber
fiber104921133fi__ber
fibster12146533fibster
fibular12267973fibular
fickle153912973fickle_
fiddling14217873fiddling
fidge104516053fi_dge_
fidged124610923fi_dged
fidges114114383fi_dges
fidget114216473fi_dget
fidgeter1343783fidgeter
fielded12206813fielded
fielders12156773fielders
fiercer12356953fiercer
fierier103511193fierier
fifer115519973fi__fer
fighter143010773fighter
figurer11215863figurer
filar84819293fi__lar
filcher15377793filcher
file75446643fi__le_
filed95331903fi__led
filers94623723fi__lers
files85441273fi__les
filet85540163fi__let
fille84327403fi_lle_
filled104922263fi_lled
fillers104320213fi_llers
filles94224523fi_lles
fillet95027083fi_llet
filmer114112403fi_lmer
filmier1237503filmier
filter94517633fi_lter
fimble133611753fimble_
fimbles143510663fimbles
finagler12194953finagler
finale94116763finale_
finales104016013finales
finders113717873find_ers
finer85431563fi__ner
finger104920333fi_nger
finnier10319953finnier
fipple13329063fipple_
fipples14298653fipples
firer811229253fi__rer
firmer114712443fi_rmer
firrier103410133firrier
fisher124917143fi_sher
fishier13359853fishier
fitter94120033fi_tter
fiver116024943fi__ver
fixer154717833fi__xer
fizzer17369383fi_zzer
fizzier18326713fizzier
fizzle17369713fizzle_
fizzled19357273fizzled
fizzles18339063fizzles
flinder11319873flind_er
fodders124010753fodd_ers
folder104317543fold_er
fonder104120063fond_er
fondle104412943fondle_
fondled12399423fondled
fondlers12338023fondlers
fondles113512613fondles
footler104011873footler
foozler19397593foozler
fouler93614903f_ouler
fowler123712583f_owler
frailer10319943frailer
fribbler15265953fribbler
friller104111743friller
frivoler1443933frivoler
frizzler19345843frizzler
fuddies123211203fuddies
fueler94313933f_ueler
fueller10279963fueller
fuller94220383f_uller
fumbler143610813fumbler
funder104016083fund_er
furler93616403f_urler
gadder93714713gadd_er
giddied11257713giddied
giddies103713363giddies
giggler101029883giggler
gilder84415533gild_er
giller74519733gi_ller
girder84312063gird_er
girdle82110463girdle_
girdled10217453girdled
girdlers10195403girdlers
girdles92210003girdles
gridder10367763gridd_er
griddle1035503griddle_
griddled1244203griddled
griddles1145753griddles
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_
peddled123410533peddled
peddlers12298533peddlers
peddlery15224003peddlery
peddles112913703peddles
pedler93614613_pedler
piddly13319143piddl_y
pinder94523453pind_er
puddle103914153puddle_
puddled123011193puddled
puddlers12298683puddlers
puddles113613823puddles
puddlier1234213puddlier
raddle84816173raddle_
raddled103812223raddled
raddles93615703raddles
redder83918133redd_er
reddle83815913reddle_
reddled102912323reddled
reddles93315773reddles
ridded93615123ridd_ed
ridden83511723ridd_en
ridders93612493ridd_ers
rider65231303ri_d_er
ridgier937883ridgier
ridley10169543ri_dley
riffler13328353riffler
rifler94014263ri_fler
rippler113210103rippler
rudder83812803rudd_er
ruddier9338523ruddier
ruddle83414203ruddle_
ruddled103010873ruddled
ruddles92813873ruddles
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
swindler12257723swindler
tedder83312153tedd_er
tickler133612653tickler
tiddly11308783tiddl_y
tidier73515113ti_dier
tiler56131023ti__ler
tiller64222543ti_ller
tinder73821803tind_er
tingler83613343tingler
tinkler113610543tinkler
tippler11348343tippler
toddle85811033toddle_
toddled10328823toddled
toddlers10346963toddlers
toddles93211533toddles
twaddler13314643twaddler
twiddle12305483twiddle_
twiddled14284633twiddled
twiddlers14313693twiddlers
twiddles13265613twiddles
twiddlier1441863twiddlier
udder76314283_udd_er
unriddler1142783unriddler
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
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.1701051123.5
2DLD Change Limit1340274015.81323056.4
3Display Results4014010.1732317.9
 (SQL Overall)1786914016.15629027.1
 
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.