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

528 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
poppet9271732(None) 
moppet126915091moppet
popped104117811popped
popper93615961popper
poppets10338851poppets
puppet93514591puppet
bopped134413402bopped
bopper123813832bopper
copped135221262copped
copper124321892copper
fopped144012672fopped
hopped144318112hopped
hopper134218482hopper
lappet103817732lappet
lopped114218622lopped
lopper103717202lopper
mopped134114322mopped
mopper126215002mopper
moppets13307162moppets
pepped103113402pepped
pepper93512942pepper
pipet95533322p_ipet
pipped104516542pipped
plopped11288772plopped
pocket144622622pocket
poet65552902po__et
pooped113915942pooped
pope85535612po_pe_
popes95933812po_pes
poppa8409892popp_a
poppas93710712poppas
poppers103414862poppers
poppied11388992poppied
poppies102816202poppies
popple92710982popple
poppled11339242poppled
popples103011872popples
poppy114813192popp_y
posset84923252posset
prophet14316032prophet
propjet1839912propjet
propped113311962propped
pupped105013272pupped
puppets10317012puppets
roupet84218342roupet
sippet103519392sippet
sopped114819902sopped
tappet103820112tappet
tippet103917872tippet
topped114617722topped
topper103817602topper
appel94615893_appel
applet105917433applet
bonnet85524633bonnet
bopeep1236763bopeep
boppers133911923boppers
bosket124919223bosket
bowpot13410073bowpot
caplet104226813caplet
capped134721853capped
capper124421983capper
carpet104530093carpet
chopped174511013chopped
chopper163611893chopper
clopped143611533clopped
coapt96131533coap_t
collet84030363collet
comet95946073co_met
comped135919873comped
compel124412893compel
compete134716553compete
compt116328223comp_t
cooped114821613cooped
cooper104221123cooper
coopt95929853coop_t
cope86847383co_pe_
coped105036853co_ped
copen94826433co_pen
coper95336093co_per
copes97747103co_pes
copied114618573copied
copier103722903copier
copies104130313copies
coplot10518273coplot
copout10418783copout
coppers133519753coppers
coppery16409393coppery
coppra12306833coppra
copse95623933copse_
copses104922483copses
copter109822013copter
coquet174318013coquet
cornet84436733cornet
corset85636223corset
corvet114626933corvet
coset75748843co_set
cosset84125863cosset
coupe96023483coupe_
couped115019313couped
coupes105022523coupes
couplet114717943couplet
covet105638943co_vet
cowpat13312033cowpat
cowpea1337643cowpea
cropped143812073cropped
cropper133312973cropper
cupped134413983cupped
cupper124313863cupper
dapped124516763dapped
dapper114016633dapper
dipnet91317473dipnet
dipped123517493dipped
dipper114017793dipper
docket134721173docket
dopant9316133dopant
dope76038893do_pe_
doped95326713do_ped
doper86128393do_per
dopes84935043do_pes
dopey116020353do_pey
dopier93515923dopier
dopiest103315993dopiest
dorper94314573dorper
droplet10312113droplet
dropped13329293dropped
dropper12329873dropper
dupped124411643dupped
epopee10312503epo_pee
epopees1137233epopees
flopped15338763flopped
flopper14328473flopper
foppery17385623foppery
forget106326393forget
gapped124217123gapped
gipped124815903gipped
gipper114215303gipper
glopped13347613glopped
gobbet114214443gobbet
goblet93219483goblet
godet7530043go_det
goglet84618583goglet
gopher1239183gopher
gorget87123863gorget
gospel936533gospel
gypped15377113gypped
gypper14347293gypper
happed144820103happed
happen134812193happen
hepper133412663hepper
heppest14228153heppest
hipped144317693hipped
hipper133818023hipper
hippest14219763hippest
hogget114715763hogget
holpen11299413holpen
hooped125518183hooped
hooper114518313hooper
hope96639673ho_pe_
hoped115628183ho_ped
hoper105829143ho_per
hopes105835643ho_pes
hoppers143115143hoppers
hoppier143110703hoppier
hoppiest152610733hoppiest
hopple132910483hopple
hoppled15338083hoppled
hopples142810713hopples
hoppy154912353hopp_y
hornet94926433hornet
howlet123518343howlet
kepped15309543kepped
keppen14346573keppen
kipped153114573kipped
kippen14299013kippen
kipper143414213kipper
knopped16355453knopped
kopek1037813ko_pek
kopje1835273kopje_
kopjes1935363kopjes
koppa13397293kopp_a
koppas14407603koppas
koppie14277883koppie
koppies153210013koppies
lapped114320033lapped
lapper104319953lapper
lappets11329133lappets
limpet103518633limpet
lipped114419543lipped
lippen103911403lippen
lipper104219633lipper
locket123922473locket
looped95217173looped
looper83817113looper
lope65941923lo_pe_
loped85128333lo_ped
loper75129233lo_per
lopes76437343lo_pes
loppers113014103loppers
loppier11369723loppier
loppiest122410113loppiest
loppy125911663lopp_y
loupe75319513loupe_
louped95316383louped
loupen84510293loupen
loupes84918053loupes
mapped134015883mapped
mapper124516093mapper
mope86838043mo_pe_
moped105424733mo_ped
moper94925923mo_per
mopes95134983mo_pes
mopey124821823mo_pey
mopier103914783mopier
mopiest113014293mopiest
moppers133412463moppers
motet75641193mo_tet
nappe96114993nappe_
napped114218163napped
napper103718283napper
nappes104515623nappes
nipped113615853nipped
nipper103715713nipper
nonet54540843no_net
nope65934193no_pe_
objet141213143_objet
octet7324063_octet
oncet74626543_oncet
onset54730173_onset
ope56845243_o_pe_
oped76230153_o_ped
open66427003_o_pen
opes65942613_o_pes
opt57545543_o_p_t
opted84914273_opted
owlet83324463_owlet
packet144726503packet
palet74650803p_alet
pallet84232653pallet
palped114513643palped
pamper124316663pamper
paper95128663p_aper
papist102618753papist
pappi84810893papp_i
pappier103511603pappier
pappies103214833pappies
pappiest112611123pappiest
pappus9408373pappus
pappy114713803papp_y
parapet11317643parapet
parget94529393parget
pauper103511943pauper
peeped113915393peeped
peeper103614803peeper
pellet83326553pellet
pelmet103419243pelmet
people10310193people_
peopled1238513peopled
peopler1138083peopler
peoples11312223peoples
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
pocked154818983pocked
pockets154612253pockets
podded115012713podded
podite93315353podite
poem86225773po__em
poets76024443po__ets
pogey116017893po_gey
pogies94123543pogies
point75338733po_int
pointe84619313pointe
poise75127893poise_
poised94918473poised
poiser84217243poiser
poises84226543poises
poke105335363po_ke_
poked125425393po_ked
poker115122883po_ker
pokes116133013po_kes
pokey145318973po_key
pokier124914633pokier
pokies125921333pokies
pokiest133314913pokiest
polder94019253polder
pole65951303po_le_
poled84934843po_led
poler74431793po_ler
poles75351003po_les
polies84034583polies
polite83625073polite
polled94022003polled
pollee83623273pollee
pollen83416453pollen
poller83921853poller
pollex153711163pollex
polyped1537173polyped
pome85636693po_me_
pomes94833933po_mes
pomfret1446993pomfret
pommee122813283pommee
pommel12277453pommel
pomp106225463pomp__
pompom1436493pompom
pompon1238943pompon
pomps115316193pomp_s
ponce95222513ponce_
ponced114314813ponced
ponces104720843ponces
ponded105218773ponded
ponder94521693ponder
pone65747533po_ne_
ponent82821593ponent
pones74547043po_nes
ponged105619353ponged
pongee94920193pongee
ponied94920703ponied
ponies84833463ponies
pontes83627853pontes
pooed85226243po_oed
poohed123912523poohed
pooled94619813pooled
pooler83819843pooler
poop86532813poop__
poops94422413poop_s
poorer82613993poorer
poorest9312773poorest
poove104514303poove_
pooves113914713pooves
pop76252253po_p__
popery134511703popery
popeyed1535713popeyed
popgun1145733popgun
popish133812113popish
poplar103611113poplar
poplin10413483poplin
popover1495843popover
popping113715413popping
pops86340953po_p_s
popsie103013063popsie
popsies112816473popsies
popsy125713403po_psy
pore66451263po_re_
pored85234513po_red
pores75849033po_res
porked134717623porked
porker124917543porker
porrect1159743porrect
port66059633po__rt
ported94223243ported
portent93619643portent
porter84224413porter
pose66441733po_se_
posed85828413po_sed
poser75128773po_ser
poses74642763po_ses
posher115018163posher
poshest12312423poshest
posies84431433posies
posit75833333po_sit
posse74722273posse_
posses85128803posses
possets94212773possets
post67953363po__st
posted93722493posted
poster84129173poster
pot58078433po___t
poteen83514263poteen
potent84223353potent
pother113818853pother
potmen102713093potmen
potpie103412433potpie
potpies113116173potpies
potted94624013potted
potter83926983potter
potzer174411213potzer
poufed12449713poufed
poult76928873po_ult
poured95116743poured
pourer84516043pourer
pout65752553po__ut
pouted94021393pouted
pouter83923983pouter
powder123611903powder
power105325953po_wer
powter114116033powter
poxed154817863po_xed
poxes145325723po_xes
poxier153812113poxier
poxiest163412253poxiest
prepped11329903prepped
preset84430983preset
privet113821343privet
projet15315183projet
prompt12313013promp_t
propel103714063propel
proper104319953proper
prophets1539503prophets
propjets1935493propjets
propmen1338763propmen
prospect1447893prospect
prosper114012193prosper
pullet84026333pullet
pulped114612533pulped
pulper103513273pulper
pulpit10310933pulpit
pumped133915563pumped
pumper124415553pumper
punnet83518843punnet
pupae96515643pupae_
pupate104213123pupate
puppetry1442503puppetry
puppies103212623puppies
puppy114912413pupp_y
rapped114122683rapped
rappee103618673rappee
rappel104211953rappel
rappen103512713rappen
rapper104621573rapper
repped114616723repped
ripped114419013ripped
ripper103518653ripper
ripplet113412583ripplet
rochet115423003rochet
rocket125425283rocket
romped114513653romped
romper104213683romper
rope65542913ro_pe_
roped84630813ro_ped
roper75431913ro_per
ropes75940063ro_pes
ropey106021873ro_pey
ropier84118813ropier
ropiest93317773ropiest
roquet154415893roquet
roset55945243ro_set
rouped95717353rouped
sapped114422013sapped
sapper103822353sapper
septet8921133septet
shoppe133110323shoppe_
shopped153512213shopped
shopper143312633shopper
shoppes143411403shoppes
sipped113720633sipped
sipper103920993sipper
sippets113310183sippets
skippet15288463skippet
slopped123511443slopped
snippet113310433snippet
soaped95817973soaped
soaper84517873soaper
socket123923523socket
sonnet65923503sonnet
sopite84917713sopite
soppier112711583soppier
soppiest122511943soppiest
soppy125113523sopp_y
sorbet83924083sorbet
souped95017673souped
soviet9720153soviet
stopped124512203stopped
stopper113012603stopper
supped114415703supped
supper104115433supper
swopped15437673swopped
tapped113820053tapped
tapper104419613tapper
tappets113610013tappets
tipped114418263tipped
tipper103918413tipper
tippets11339373tippets
toilet66228093toilet
tonlet62924703tonlet
tope65946383to_pe_
toped85631313to_ped
topee76029953to_pee
topees85519703topees
toper75231023to_per
topes76941763to_pes
tophe106718973tophe_
tophes115218423tophes
toppers113914603toppers
topple104411323topple
toppled12348843toppled
topples113111653topples
toquet154414683toquet
toupee8316133toupee
trippet113714113trippet
tupped114013233tupped
upped103715163_upped
upper93714263_upper
upset73222593_upset
wapped144416473wapped
whippet17328843whippet
whopped18358003whopped
whopper17328503whopper
worset96726583worset
yapped144415143yapped
yapper133714513yapper
yipped143613283yipped
yippee132810743yippee
zapped204213523zapped
zapper193414023zapper
zipped203612983zipped
zipper193813123zipper

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 Filter1786911127160.376475242.0
2DLD Change Limit1127165285.46620621.3
3Display Results5285280.1733052.0
 (SQL Overall)1786915286.01529707.6
 
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.