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

431 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
puppet9351459(None) 
poppet92717321poppet
pupped105013271pupped
puppets10317011puppets
cupped134413982cupped
cupper124313862cupper
dupped124411642dupped
lappet103817732lappet
moppet126915092moppet
pepped103113402pepped
pepper93512942pepper
pipet95533322p_ipet
pipped104516542pipped
popped104117812popped
popper93615962popper
poppets10338852poppets
pullet84026332pullet
pulped114612532pulped
pulper103513272pulper
pulpit10310932pulpit
pumped133915562pumped
pumper124415552pumper
punnet83518842punnet
pupae96515642pupae_
pupate104213122pupate
puppetry1442502puppetry
puppies103212622puppies
puppy114912412pupp_y
sippet103519392sippet
supped114415702supped
supper104115432supper
tappet103820112tappet
tippet103917872tippet
tupped114013232tupped
upped103715162_upped
upper93714262_upper
upset73222592_upset
appel94615893_appel
applet105917433applet
auklet104216833auklet
auspex1574793auspex
bopped134413403bopped
bopper123813833bopper
bucket144620733bucket
budget104618123budget
buffet143113783buffet
bullet84528613bullet
bumped134414003bumped
bumper123714343bumper
bupkes144811483bupkes
buppie12288733buppie
buppies133011063buppies
buppy144810073bupp_y
buret77444013bu_ret
burnet84326173burnet
burped116215503burped
caplet104226813caplet
capped134721853capped
capper124421983capper
carpet104530093carpet
copped135221253copped
copper124321893copper
couplet114717943couplet
crumpet133711063crumpet
crupper13338563crupper
culet76040343cu_let
cullet84727313cullet
cupel9514303cu_pel
cuppa11398523cupp_a
cuppas12458593cuppas
cuppers133712213cuppers
cuppier1368323cuppier
cuppiest1448203cuppiest
cuppy144710383cupp_y
curet75447643cu_ret
curvet114720243curvet
cusped114312043cusped
cutlet84924363cutlet
dapped124516763dapped
dapper114016633dapper
dipnet91317473dipnet
dipped123517493dipped
dipper114017793dipper
duet56446263du__et
dulcet9314493dulcet
dumped123814493dumped
dumper114615213dumper
dupe76630603du_pe_
duped95118323du_ped
duper85519003du_per
dupes86425933du_pes
duple85315863duple_
duplex16386973duplex
duvet9321873du_vet
eupnea835033eupnea
fopped144012673fopped
fumet105630223fu_met
gapped124217123gapped
gipped124815903gipped
gipper114215303gipper
guglet84018223guglet
gullet74924833gullet
gulped104610373gulped
gulper93410213gulper
guppies123310523guppies
guppy135211273gupp_y
gurnet74920873gurnet
gusset7316433gusset
gypped15377113gypped
gypper14347293gypper
happed144820103happed
happen134812193happen
hepper133412663hepper
heppest14228153heppest
hipped144317693hipped
hipper133818023hipper
hippest14219763hippest
hopped144318113hopped
hopper134218483hopper
humped144015243humped
humper134115883humper
huppah1644183huppah
jumped183511553jumped
jumper173612373jumper
junket173815023junket
jupe134921003ju_pe_
jupes145218553ju_pes
kepped15309543kepped
keppen14346573keppen
kipped153114573kipped
kippen14299013kippen
kipper143414213kipper
lapped114320033lapped
lapper104319953lapper
lappets11329133lappets
limpet103518633limpet
lipped114419543lipped
lippen103911403lippen
lipper104219633lipper
lopped114218623lopped
lopper103717203lopper
lumped114216963lumped
lumpen104010663lumpen
lumper103816653lumper
lunet56835423lu_net
mapped134015883mapped
mapper124516093mapper
mopped134114323mopped
mopper126215003mopper
moppets13307163moppets
mullet84126823mullet
mumped133813163mumped
mumper123513523mumper
musket122818203musket
nappe96114993nappe_
napped114218163napped
napper103718283napper
nappes104515623nappes
nipped113615853nipped
nipper103715713nipper
nugget8311723nugget
nutlet64220563nutlet
ouphe104413263ouphe_
ouphes113614633ouphes
outlet63728683outlet
output8712853output
outset64027453outset
packet144726503packet
palet74650803p_alet
pallet84232653pallet
palped114513643palped
pamper124316663pamper
paper95128663p_aper
papist102618753papist
pappi84810893papp_i
pappier103511603pappier
pappies103214833pappies
pappiest112611123pappiest
pappus9408373pappus
pappy114713803papp_y
parapet11317643parapet
parget94529393parget
pauper103511943pauper
peeped113915393peeped
peeper103614803peeper
pellet83326553pellet
pelmet103419243pelmet
peppers103311443peppers
peppery13286253peppery
peppier10268323peppier
peppiest11278573peppiest
peppy114310363pepp_y
perpent112318813perpent
pet56477303___pet
phpht1538063p_hpht
picket144924313picket
piglet93420923piglet
pigpen1136583pigpen
pimped134913483pimped
piolet83225643piolet
pipe86434433p_ipe_
piped105123163p_iped
piper96523193p_iper
pipes96030143p_ipes
pipets105714773p_ipets
pipier104913983pipier
pipiest113114503pipiest
pipit95224873p_ipit
pippin92810303pippin
piquet17412353piquet
placet103923673placet
planet84228353planet
plopped11288773plopped
plummet13278353plummet
plumped14318643plumped
plumpen13276403plumpen
plumper13318773plumper
plumpest14236353plumpest
pocket144622623pocket
poet65552903__poet
pooped113915943pooped
pope85535613p_ope_
popes95933813p_opes
poppa8409893popp_a
poppas93710713poppas
poppers103414863poppers
poppied11388983poppied
poppies102816203poppies
popple92710983popple
poppled11339243poppled
popples103011873popples
poppy114813193popp_y
posset84923253posset
prepped11329903prepped
preset84430983preset
privet113821343privet
projet15315183projet
propel103714063propel
proper104319953proper
prophet14316033prophet
propjet1839913propjet
propped113311953propped
pubes94423403pu_bes
puce85127883pu_ce_
puces94924633pu_ces
pucker143817633pucker
puffed153510603puffed
puffer144610733puffer
pugged114314533pugged
pugree92112473pugree
puke105025463pu_ke_
puked124716223pu_ked
pukes114523023pu_kes
pule65040953pu_le_
puled84926523pu_led
puler74826623pu_ler
pules74538813pu_les
pulled94322193pulled
puller83820813puller
pullets94015163pullets
pulley113713403pulley
pulp84825353pulp__
pulpal10408453pulpal
pulpers114612283pulpers
pulpier1148623pulpier
pulpiest1258443pulpiest
pulpits1137243pulpits
pulps95116483pulp_s
pulpy124612363pulp_y
pulse74219973pulse_
pulsed94013723pulsed
pulser84215193pulser
pulses83818663pulses
pummel12278043pummel
pump105726853pump__
pumpers133113673pumpers
pumps115520603pump_s
pundit92914183pundit
pungent10311233pungent
punier84519223punier
puniest92918093puniest
punker123718823punker
punkest132611693punkest
punkey154011173punkey
punned93416193punned
punner84918153punner
punnets9409263punnets
punt65747203pu__nt
punted94618713punted
punter84320023punter
pup76339883pu_p__
pupa85422813pu_p_a
pupal97616873pu_pal
pupas95219283pu_pas
pupated12319353pupated
pupates113311433pupates
pupil94712983pu_pil
pupils10389913pupils
puppeteer1242443puppeteer
pupping114412503pupping
pups86032233pu_p_s
pupu87620713pu_p_u
pupus94614043pu_pus
pure65543333pu_re_
puree74632843pu_ree
pureed95017813pureed
purees84721683purees
purer75127903pu_rer
purest84021933purest
purge85324603purge_
purged104918263purged
purger94717233purger
purges94421763purges
purist85525053purist
purled94520753purled
purple102712683purple
purpled12299783purpled
purpler11289273purpler
purples112712833purples
purplest12249133purplest
purply13369053purply
purport1159393purport
purred94218073purred
purse76028893purse_
pursed95220883pursed
purser85020473purser
purses84826373purses
purvey14559573purvey
puses75532203pu_ses
pushed125017463pushed
pusher114318283pusher
pushes114621663pushes
pusley11379613pusley
pusses84322843pusses
put55759073pu___t
putout8315113putout
putt66937843pu__tt
putted94220253putted
puttee85919723puttee
putter83921443putter
putzed18409113putzed
putzes174212523putzes
quiet144530733qu_iet
quipped2175163quipped
quipper2095823quipper
rapped114122683rapped
rappee103618673rappee
rappel104211953rappel
rappen103512713rappen
rapper104621573rapper
repped114616723repped
ripped114419013ripped
ripper103518653ripper
ripplet113412583ripplet
roupet84218343roupet
runlet63821413runlet
rupee7321283ru_pee
rupees8312573rupees
russet6319433russet
sapped114422013sapped
sapper103822353sapper
scupper1367423scupper
septet8921133septet
sipped113720633sipped
sipper103920993sipper
sippets113310183sippets
skippet15288463skippet
snippet113310433snippet
sopped114819903sopped
sublet82827243sublet
subnet82520933subnet
subset83122583subset
suet46754823su__et
sunket103721363sunket
sunset63723633sunset
supe65932763su_pe_
super74924483su_per
supes75628303su_pes
suppers113314703suppers
supple10410203supple
suppled1248463suppled
suppler1148433suppler
supples11511283supples
supplest1248953supplest
supply1346893supply
support11310523support
suspect1158513suspect
tapped113820053tapped
tapper104419613tapper
tappets113610013tappets
tipped114418263tipped
tipper103918413tipper
tippets11339373tippets
topped114617723topped
topper103817603topper
trippet113714113trippet
trumpet113810723trumpet
tucket124219483tucket
tuffet122612083tuffet
tumped114216233tumped
turpeth1284813turpeth
turret63121853turret
umped104717273_umped
unlet54133333_unlet
unmet74426393_unmet
unpeg8309363_unpeg
unpen72913573_unpen
unpent83117373_unpent
unset54532433_unset
unwet84423173_unwet
upbeat10911513_upbeat
uplit76020803_uplit
uppers102912293_uppers
uppity1335103_uppity
upsent83314063_upsent
upsets8409683_upsets
urped84615283_urped
wapped144416473wapped
whippet17328843whippet
whupped18365413whupped
yapped144415143yapped
yapper133714513yapper
yipped143613283yipped
yippee132810743yippee
yuppie13297133yuppie
yuppies14339263yuppies
yuppy15487913yupp_y
zapped204213523zapped
zapper193414023zapper
zipped203612983zipped
zipper193813123zipper

Search took 6 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 Filter1786911127160.393454684.5
2DLD Change Limit1127164314.79623502.1
3Display Results4314310.1403078.6
 (SQL Overall)1786914315.32933531.8
 
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.