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

291 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
puppets1031701(None) 
poppets10338851poppets
puppet93514591puppet_
cuppers133712212cuppers
lappets11329122lappets
moppets13307162moppets
peppers103311442peppers
pipets105714772p_ipets
poppers103414862poppers
poppet92717322poppet_
pullets94015162pullets
pulpers114612282pulpers
pulpits1137242pulpits
pumpers133113672pumpers
punnets9409262punnets
pupates113311432pupates
pupped105013272puppe_d
puppetry1442502puppetry
puppies103212612puppies
sippets113310182sippets
suppers113314702suppers
tappets113610012tappets
tippets11339372tippets
uppers102912292_uppers
upsets8409682_upsets
appels104312793_appels
applets115710063applets
auklets11298573auklets
boppers133911923boppers
buckets153811693buckets
budgets11489863budgets
buffets15317593buffets
bullets93516393bullets
bumpers133912053bumpers
bupkes144811483bupke_s
buppies133011063buppies
burets84321263bu_rets
burnets93813263burnets
caplets114914523caplets
cappers134419403cappers
carpets113915333carpets
coppers133519753coppers
couplets12389873couplets
crumpets14335943crumpets
cruppers14317323cruppers
culets85518513cu_lets
cullets94015613cullets
cupels10310203cu_pels
cuppas12458593cupp_as
cupped134413983cuppe_d
cupper124313863cuppe_r
cuppiest1448193cuppiest
curets84922343cu_rets
curvets12399913curvets
cutlets94113653cutlets
dipnets10109033dipnets
dippers123615183dippers
duets65323883du__ets
dulcets1046283dulcets
dumpers123412663dumpers
dupers94615603du_pers
dupes86425933du_pe_s
dupped124411643duppe_d
duvets1039223du_vets
eupneas935233eupneas
fumets114311813fu_mets
gippers123212083gippers
guglets9369693guglets
gullets84013713gullets
gulpers10299013gulpers
guppies123310523guppies
gurnets84010793gurnets
gussets837443gussets
gyppers15235503gyppers
happens14359173happens
heppest14228143heppest
hippest14219753hippest
hoppers143115143hoppers
humpers142713523humpers
huppahs1743333huppahs
jumpers18399843jumpers
junkets18377623junkets
jupes145218553ju_pe_s
kippers153211433kippers
lappers113717463lappers
lappet103817723lappet_
limpets11329783limpets
lippens11328533lippens
lippers113416443lippers
loppers113014103loppers
lumpens11298263lumpens
lumpers113514483lumpers
lunets66914763lu_nets
mappers133313783mappers
moppers133412463moppers
moppet126915093moppet_
mullets93614783mullets
mumpers133311373mumpers
muskets13258643muskets
nappers114214863nappers
nappes104515623nappe_s
nippers113012623nippers
nuggets936383nuggets
nutlets74111253nutlets
ouphes113614633ouphe_s
outlets73616363outlets
outputs988493outputs
outsets73514923outsets
packets155114773packets
palets85122313p_alets
pallets93919303pallets
pampers133615933pampers
papers105125323p_apers
papists112110453papists
pappies103214823pappies
pappiest112611113pappiest
pappous1057463pappous
pappus9408373papp_us
parapets1239763parapets
pargets105215193pargets
paupers114311073paupers
peepers113713673peepers
pellets94014783pellets
pelmets11309693pelmets
pepped103113403peppe_d
pepper93512943peppe_r
peppery13286253peppery
peppiest11278563peppiest
perpents122312043perpents
pets66248333___pets
pickets154314183pickets
piglets103311793piglets
pigpens1235503pigpens
piolets93513193piolets
pipers104318663p_ipers
pipes96030143p_ipe_s
pipet95533323p_ipet_
pipiest113114493pipiest
pipits104713063p_ipits
pipped104516543pippe_d
pippins10319753pippins
piquets1836603piquets
placets113911223placets
planets93914083planets
plummets14304773plummets
plumpens14304953plumpens
plumpers14357293plumpers
plumpest14236353plumpest
pockets154612253pockets
poets76024443__poets
popes95933813p_ope_s
poppas93710713popp_as
popped104117813poppe_d
popper93615963poppe_r
poppies102816193poppies
popples103011873popples
possets94212773possets
presets94216423presets
privets122910053privets
projets1639163projets
propels113412843propels
propers113619033propers
prophets1539503prophets
propjets1935493propjets
pubes94423403pu_be_s
puces94924633pu_ce_s
puckers153514673puckers
puffers15349203puffers
pugrees10218523pugrees
pukes114523023pu_ke_s
pulers83820283pu_lers
pules74538813pu_le_s
pullers93618483pullers
pullet84026333pullet_
pulleys12399143pulleys
pulped114612533pulpe_d
pulper103513273pulpe_r
pulpiest1258433pulpiest
pulpit10310933pulpit_
pulpless12224953pulpless
pulpous1177013pulpous
pulps95116483pulp__s
pulsers94213153pulsers
pulses83818663pulse_s
pummels13236543pummels
pumped133915563pumpe_d
pumper124415553pumpe_r
pumpless14236373pumpless
pumps115520603pump__s
pundits10379293pundits
puniest92918093puniest
punkers133714853punkers
punkest132611693punkest
punkeys16366493punkeys
punners94114233punners
punnet83518843punnet_
punters93617043punters
punts75828003pu__nts
pupae96515643pupae__
pupas95219283pu_p_as
pupate104213123pu_pate
pupated12319353pupated
pupils10389913pu_pils
puppeteer1242443puppeteer
puppeteers1361983puppeteers
puppetries1343883puppetries
pupping114412503pupping
puppy114912413pupp__y
puppyish1742453puppyish
pups86032233pu_p__s
pupus94614043pu_p_us
purees84721683pu_rees
purest84021933pu_rest
purgers104714003purgers
purges94421763purge_s
purists94014073purists
purples112712833purples
purplest12249133purplest
purports1265783purports
pursers93916093pursers
purses84826373purse_s
purveys15615903purveys
puses75532203pu_se_s
pushers123814503pushers
pushes114621663pushe_s
pusleys12286233pusleys
pusses84322843pusse_s
putouts937083putouts
puts65641753pu___ts
puttees93612913puttees
putters94219193putters
putts75719273pu__tts
putzes174212523putze_s
quiets154014373qu_iets
quippers2184813quippers
rappees113611453rappees
rappels11448803rappels
rappers113618443rappers
rippers114115033rippers
ripplets12316733ripplets
runlets73310773runlets
rupees8312573ru_pees
russets738163russets
sappers113518903sappers
scuppers1446543scuppers
septets998953septets
sippers113117753sippers
sippet103519393sippet_
skippets16284563skippets
snippets12225623snippets
sublets92616703sublets
subnets92512083subnets
subsets92813103subsets
suets55126103su__ets
sunkets113511283sunkets
sunsets72911573sunsets
supers84622403su_pers
supes75628303su_pe_s
supped114415703suppe_d
supper104115433suppe_r
supples11511283supples
supplest1248943supplest
supports1246513supports
suppress1236443suppress
suspects1254863suspects
tappers113416543tappers
tappet103820113tappet_
tippers113414353tippers
tippet103917873tippet_
toppers113914603toppers
trippets12357423trippets
trumpets12315573trumpets
tuckets134810333tuckets
tuffets13266523tuffets
tupped114013233tuppe_d
turpeth1284813turpeth
turpeths1373153turpeths
turrets73010673turrets
unpegs9256233_unpegs
unpens82511013_unpens
unsets64116163_unsets
upbeats1195733_upbeats
upped103715163_uppe_d
upper93714263_uppe_r
uppity1335103_uppity
upset73222593_upset_
whippets18255253whippets
yappers144012253yappers
yuppies14339263yuppies
zappers203911633zappers
zippers203310383zippers

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.406440125.6
2DLD Change Limit1340272915.78023188.1
3Display Results2912910.0933129.0
 (SQL Overall)1786912916.27928458.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.