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

480 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
moppet12691509(None) 
mopped134114321mopped
mopper126215001mopper
moppets13307161moppets
poppet92717321poppet
bopped134413402bopped
bopper123813832bopper
copped135221252copped
copper124321892copper
fopped144012672fopped
hopped144318112hopped
hopper134218482hopper
lappet103817722lappet
lopped114218622lopped
lopper103717202lopper
mapped134015882mapped
mapper124516092mapper
mope86838042mo_pe_
moped105424732mo_ped
moper94925922mo_per
mopes95134982mo_pes
mopey124821822mo_pey
mopier103914782mopier
mopiest113014292mopiest
moppers133412462moppers
motet75641192mo_tet
popped104117812popped
popper93615962popper
poppets10338852poppets
puppet93514592puppet
roupet84218342roupet
sippet103519392sippet
sopped114819902sopped
tappet103820112tappet
tippet103917872tippet
topped114617722topped
topper103817602topper
appel94615893_appel
applet105917433applet
bonnet85524633bonnet
bopeep1236763bopeep
boppers133911923boppers
bosket124919223bosket
bowpot13410073bowpot
caplet104226813caplet
capped134721853capped
capper124421983capper
carpet104530093carpet
chopped174511003chopped
chopper163611893chopper
clopped143611523clopped
coapt96131533coap_t
collet84030363collet
comet95946073co_met
comped135919873comped
compel124412893compel
compete134716553compete
compt116328223comp_t
cooped114821603cooped
cooper104221123cooper
coopt95929853coop_t
cope86847383co_pe_
coped105036843co_ped
copen94826433co_pen
coper95336093co_per
copes97747103co_pes
copied114618563copied
copier103722893copier
copies104130303copies
coplot10518273coplot
copout10418783copout
coppers133519753coppers
coppery16409393coppery
coppra12306833coppra
copse95623923copse_
copses104922473copses
copter109822013copter
coquet174318013coquet
cornet84436733cornet
corset85636223corset
corvet114626933corvet
coset75748843co_set
cosset84125863cosset
coupe96023483coupe_
couped115019313couped
coupes105022523coupes
couplet114717943couplet
covet105638943co_vet
cowpat13312033cowpat
cowpea1337643cowpea
cropped143812063cropped
cropper133312963cropper
cupped134413983cupped
cupper124313863cupper
dapped124516763dapped
dapper114016633dapper
dipnet91317473dipnet
dipped123517493dipped
dipper114017793dipper
docket134721173docket
dopant9316133dopant
dope76038893do_pe_
doped95326713do_ped
doper86128393do_per
dopes84935043do_pes
dopey116020353do_pey
dopier93515923dopier
dopiest103315993dopiest
dorper94314573dorper
droplet10312113droplet
dropped13329283dropped
dropper12329873dropper
dupped124411643dupped
epopee10312503epopee
flopped15338763flopped
flopper14328473flopper
foppery17385623foppery
forget106326393forget
gapped124217123gapped
gipped124815903gipped
gipper114215303gipper
glopped13347613glopped
gobbet114214443gobbet
goblet93219483goblet
godet7530043go_det
goglet84618583goglet
gopher1239183gopher
gorget87123863gorget
gospel936533gospel
gypped15377113gypped
gypper14347293gypper
happed144820103happed
happen134812193happen
hepper133412663hepper
heppest14228143heppest
hipped144317693hipped
hipper133818023hipper
hippest14219753hippest
hogget114715763hogget
holpen11299413holpen
hooped125518183hooped
hooper114518313hooper
hope96639673ho_pe_
hoped115628183ho_ped
hoper105829143ho_per
hopes105835643ho_pes
hoppers143115143hoppers
hoppier143110703hoppier
hoppiest152610723hoppiest
hopple132910483hopple
hoppled15338083hoppled
hopples142810713hopples
hoppy154912353hopp_y
hornet94926433hornet
howlet123518343howlet
kepped15309543kepped
keppen14346573keppen
kipped153114573kipped
kippen14299013kippen
kipper143414213kipper
knopped16355453knopped
kopek1037813ko_pek
kopje1835273kopje_
kopjes1935363kopjes
koppa13397293kopp_a
koppas14407603koppas
koppie14277883koppie
koppies153210013koppies
lapped114320033lapped
lapper104319953lapper
lappets11329123lappets
limpet103518633limpet
lipped114419543lipped
lippen103911403lippen
lipper104219633lipper
locket123922473locket
looped95217173looped
looper83817113looper
lope65941923lo_pe_
loped85128333lo_ped
loper75129233lo_per
lopes76437343lo_pes
loppers113014103loppers
loppier11369723loppier
loppiest122410103loppiest
loppy125911663lopp_y
loupe75319513loupe_
louped95316383louped
loupen84510293loupen
loupes84918053loupes
magnet9320663magnet
mallet84433053mallet
mammet94319253mammet
maple95521143maple_
maples104819423maples
mappers133313783mappers
market123226043market
maumet103518883maumet
meet65350553m__eet
met56072433m___et
midget103718453midget
millet84030743millet
minuet82621033minuet
mismet103722373mismet
mispen10312173mispen
misset85028153misset
moaned94514173moaned
moaner84415113moaner
moat66352033mo__at
moated94819003moated
mobbed137112243mobbed
mobber123613463mobber
mobled113213183mobled
mocked154716613mocked
mocker143315443mocker
mode75840303mo_de_
model84521693mo_del
modem103717143mo_dem
modes85537413mo_des
modest93818453modest
mogged115215393mogged
mohel104914833mo_hel
moiety1148223mo_iety
moiled94318863moiled
moiler84017263moiler
moire71017323moire_
moires8915633moires
moist76033583mo_ist
mojoes15399523mojoes
moke106234223mo_ke_
mokes114631033mo_kes
molded104414083molded
molder93819273molder
mole66251833mo_le_
moles74747923mo_les
molest85022743molest
molies84429513molies
molt66356163mo__lt
molted94217473molted
molten83311813molten
molter84119423molter
mome85239353mo_me_
moment103319683moment
momes95134473mo_mes
momser104011413momser
momzer19327553momzer
monde85723143monde_
mondes94322353mondes
money104826843mo_ney
monger94418333monger
mongst93512603mongst
monie75631653monie_
monied94319463monied
monies83233163monies
monist84324983monist
monkey153710593monkey
monte75829773monte_
montes84226933montes
mooed85123983mo_oed
mooley11311633mooley
mooned94216643mooned
mooner85317833mooner
moonlet92413273moonlet
moonset92413043moonset
moored93814173moored
moose76327193moose_
moot67653623mo__ot
mooted94120373mooted
mooter83921093mooter
mop76950823mo_p__
mopeds11499663mopeds
mopers104220373mopers
mopery135210973mopery
moping114017103moping
mopish134311593mopish
mopoke1436633mopoke
mopokes1536693mopokes
mopping143411473mopping
mops85940133mo_p_s
mopy115721973mo_p_y
morae75831193morae_
mordent10313993mordent
more67154523mo_re_
moreen8313343moreen
morel75729093mo_rel
mores76249643mo_res
morgen9312203morgen
morph121712513morp_h
morphed1537133morphed
morpho13158443morpho
morphs13149433morphs
morse76032703morse_
morsel85815893morsel
mort66758833mo__rt
mosey105922873mo_sey
moshed124517493moshed
mosher114719793mosher
moshes115222873moshes
mossed94818893mossed
mosser84618273mosser
mosses85527683mosses
most66554203mo__st
moste75925083moste_
mostest9314793mostest
mot57279423mo___t
mote67048083mo_te_
motel76623243mo_tel
motes75944003mo_tes
motets84216193mo_tets
motey105922953mo_tey
mother113718643mother
motley1139383motley
motmot10311073motmot
mott66648443mo__tt
motte75526973motte_
mottes85523693mottes
moue65835573mo_ue_
moues75732843mo_ues
moult74728723mo_ult
mount74128063mo_unt
mouse77133003mouse_
moused94423303moused
mouser85822443mouser
mouses85531423mouses
mousey115216193mousey
move96630723mo_ve_
moved114218153mo_ved
mover104220863mo_ver
moves106128423mo_ves
movie105319133movie_
movies115118453movies
mowed113629013mo_wed
mower104523453mo_wer
moxie144018123moxie_
moxies154317403moxies
mullet84126823mullet
mumped133813163mumped
mumper123513523mumper
musket122818203musket
myope124010973myope_
myopes13419963myopes
myopies14309723myopies
nappe96114993nappe_
napped114218163napped
napper103718283napper
nappes104515623nappes
nipped113615853nipped
nipper103715713nipper
nonet54540843no_net
nope65934193no_pe_
objet141213143_objet
octet7324063_octet
omelet8317073omelet
oncet74626543_oncet
onset54730173_onset
ope56845243_o_pe_
oped76230153_o_ped
open66427003_o_pen
opes65942613_o_pes
opt57545543_o_p_t
opted84914273_opted
owlet83324463_owlet
pepped103113403pepped
pepper93512943pepper
pet56477303___pet
pipet95533323_pipet
pipped104516543pipped
plopped11288773plopped
pocket144622623pocket
poet65552903__poet
pooped113915943pooped
pope85535613po_pe_
popes95933813po_pes
poppa8409893popp_a
poppas93710713poppas
poppers103414863poppers
poppied11388983poppied
poppies102816193poppies
popple92710983popple
poppled11339243poppled
popples103011873popples
poppy114813193popp_y
posset84923253posset
prophet14316033prophet
propjet1839913propjet
propped113311953propped
pupped105013273pupped
puppets10317013puppets
rapped114122683rapped
rappee103618673rappee
rappel104211953rappel
rappen103512713rappen
rapper104621573rapper
repped114616723repped
ripped114419013ripped
ripper103518653ripper
ripplet113412583ripplet
rochet115423003rochet
rocket125425283rocket
romped114513653romped
romper104213683romper
rope65542913ro_pe_
roped84630803ro_ped
roper75431913ro_per
ropes75940063ro_pes
ropey106021873ro_pey
ropier84118803ropier
ropiest93317773ropiest
roquet154415893roquet
roset55945243ro_set
rouped95717353rouped
sapped114422013sapped
sapper103822353sapper
septet8921133septet
shoppe133110323shoppe_
shopped153512213shopped
shopper143312633shopper
shoppes143411393shoppes
sipped113720633sipped
sipper103920993sipper
sippets113310183sippets
skippet15288463skippet
slopped123511443slopped
snippet113310433snippet
soaped95817973soaped
soaper84517873soaper
socket123923523socket
sonnet65923503sonnet
sopite84917713sopite
soppier112711583soppier
soppiest122511933soppiest
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 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.406440125.6
2DLD Change Limit1127164804.90622975.1
3Display Results4804800.1563076.9
 (SQL Overall)1786914805.46832679.4
 
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.