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

420 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
piddler11291152(None) 
diddler103511511diddler
fiddler12309951fiddler
middler112712271middler
paddler113711551paddler
peddler113210491peddler
piddle103514911piddle_
piddled123311251piddled
piddlers12359591piddlers
piddles114314271piddles
puddler112910751puddler
riddler93411261riddler
tiddler93110001tiddler
bidder104114862bidd_er
coddler113710832coddler
cuddler113810742cuddler
diddle94915212diddle_
diddled114212052diddled
diddlers11359152diddlers
diddles103915072diddles
diddley13388102diddley
fiddle113613382fiddle_
fiddled13329632fiddled
fiddlers13328282fiddlers
fiddles123212602fiddles
giddier10308722giddier
girdler9227312girdler
huddler12379422huddler
idler65015662_i_dler
kidder123811102kidd_er
kindler12309982kindler
meddler11319952meddler
middle103414982middle_
middled123311902middled
middlers123410192middlers
middles113415302middles
muddler113411622muddler
padder103415492padd_er
paddle104615142paddle_
paddled123612022paddled
paddlers12329152paddlers
paddles113515642paddles
pedaler103410692pedaler
peddle103512822peddle_
peddled123410542peddled
peddlers12298532peddlers
peddlery15224012peddlery
peddles112913702peddles
pedler93614622p_edler
piddly13319142piddl_y
pinder94523452pind_er
puddle103914152puddle_
puddled123011192puddled
puddlers12298682puddlers
puddles113613822puddles
puddlier1234212puddlier
ridder84015142ridd_er
riddle83915712riddle_
riddled103012042riddled
riddlers10269102riddlers
riddles93215022riddles
saddler93811962saddler
sidler74716962si_dler
spindler11297982spindler
tiddlers10288652tiddlers
toddler9379042toddler
twiddler13244872twiddler
waddler124010792waddler
widder112913972widd_er
widdle113814842widdle_
widdled133511232widdled
widdles123514342widdles
adder75419593_add_er
addle74318353_addle_
addled94112523_addled
addles84216603_addles
aider65431133ai_d_er
badder103817513badd_er
bedder104215793bedd_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
epistler1044833epistler
faddier1237783faddier
fickler16348423fickler
fiddly14328483fiddl_y
fielder11217413fielder
filer85433003fi__ler
filler94623623fi_ller
finder104020233find_er
fodder114712113fodd_er
fondler11348883fondler
fuddle113312103fuddle_
fuddled13309393fuddled
fuddles123611933fuddles
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
kidded13299393kidd_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
padded114113503padd_ed
padders113312873padd_ers
paddies113715723paddies
padle84522343p_adle_
padles95221123p_adles
paler75436933p__aler
pander93725523pand_er
pardner10239473pardner
pearler9310373pearler
pedaled113711893pedaled
pedalers11239393pedalers
pedalfer1443273pedalfer
pedalier1137603pedalier
pedaller1136093pedaller
pedlar93311273p_edlar
pedlers103013273p_edlers
pedlery13297083p_edlery
peeler83517383p_eeler
peopler1138083peopler
piaffer15104443piaffer
piaster93012883piaster
pickeer153710113pickeer
picker144422173pi_cker
pickier153912973pickier
pickle144215653pickle_
pickled164011883pickled
pickles153215443pickles
piddling13208953piddling
piddock17103653piddock
piecer105213083pi_ecer
pier66035293pi___er
piercer11337773piercer
piffle14418233piffle_
piffled16366403piffled
piffles15368763piffles
piggier113510003piggier
piglet93420923pi_glet
piker115622843pi__ker
pilar75221503pi__lar
pile65649693pi__le_
pilea75123953pi__lea
piled85232993pi__led
pilei74021783pi__lei
piles74742613pi__les
pilfer1139163pi_lfer
pillar8314023pi_llar
pilled94222753pi_lled
pilsner935343pilsner
pilular938203pilular
pilule8411123pilule_
pilules9510623pilules
pimple123512963pimple_
pimpled14289193pimpled
pimples133012423pimples
pimplier1445413pimplier
pincer104019173pi_ncer
pincher143812713pincher
pinders103720473pind_ers
pinger94324093pi_nger
pinier84024693pi_nier
pinker125322443pi_nker
pinner84521503pi_nner
pinole83218783pinole_
pinoles93418703pinoles
pintle83818263pintle_
pintles94118723pintles
piolet83225643pi_olet
pioneer936893pioneer
piper96523193pi__per
pipier104913983pi_pier
pisher114317753pi_sher
pisser84416383pi_sser
pitcher143813713pitcher
pithier123010293pithier
pitier84019823pi_tier
pizzle16279493pizzle_
pizzles17329273pizzles
pledger11359173pledger
plodder1146003plodder
podded115012713podd_ed
podgier11338723podgier
polder94019253pold_er
poler74431793p__oler
poller83921853p_oller
ponder94521693pond_er
poodle93112043poodle_
poodles103013513poodles
pooler83819843p_ooler
powder123611903powd_er
prodder1147953prodder
prowler123310013prowler
puddly13438133puddl_y
pudgier11377723pudgier
puler74826623p__uler
puller83820813p_uller
purfler12248733purfler
purpler11289273purpler
puzzler17276963puzzler
raddle84816173raddle_
raddled103812223raddled
raddles93615703raddles
redder83918143redd_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
spider94516803spi_d_er
spieler93111233spi_eler
spiller92914333spi_ller
spindle103210093spindle_
spindled12287643spindled
spindlers12286453spindlers
spindles112710353spindles
spindlier1253873spindlier
spudder11256553spudd_er
swindler12257723swindler
tedder83312163tedd_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
wedder113612303wedd_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 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.390458182.1
2DLD Change Limit1340274206.90619407.3
3Display Results4204200.1562692.3
 (SQL Overall)1786914207.45223978.9
 
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.