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

316 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
moppets1330716(None) 
moppers133412461moppers
moppet126915091moppet_
poppets10338851poppets
boppers133911922boppers
coppers133519752coppers
hoppers143115142hoppers
lappets11329122lappets
loppers113014102loppers
mappers133313782mappers
mopeds11499662mo_peds
mopers104220372mo_pers
mopes95134982mo_pe_s
mopiest113014292mopiest
mopped134114322moppe_d
mopper126215002moppe_r
motets84216192mo_tets
poppers103414862poppers
poppet92717322poppet_
puppets10317012puppets
sippets113310182sippets
tappets113610012tappets
tippets11339372tippets
toppers113914602toppers
appels104312793_appels
applets115710063applets
bonnets94812803bonnets
bopeeps1333103bopeeps
bopped134413403boppe_d
bopper123813833boppe_r
boskets13409473boskets
bowpots1446023bowpots
caplets114914523caplets
cappers134419403cappers
carpets113915333carpets
choppers174110463choppers
coapts104614013coap_ts
collets93517903collets
comets105823583co_mets
compels133210883compels
compete134716553compete
competes144117243competes
compts125216653comp_ts
coopers114019483coopers
coopts105814583coop_ts
copens106119963co_pens
copers104629843co_pers
copes97747103co_pe_s
copiers114215963copiers
copies104130303copie_s
coplots11511593coplots
copouts11311083copouts
copped135221253coppe_d
copper124321893coppe_r
copperas14308573copperas
coppery16409393coppery
coppras13327833coppras
copses104922473copse_s
copters113621283copters
coquets18399893coquets
cornets94820573cornets
corsets94819803corsets
corvets124715023corvets
cosets85824403co_sets
cossets95014283cossets
coupes105022523coupe_s
couplets12389873couplets
covets114819643co_vets
cowpats1437713cowpats
cowpeas1437273cowpeas
croppers143311483croppers
cuppers133712213cuppers
dipnets10109033dipnets
dippers123615183dippers
dockets144412243dockets
dopants1038433dopants
dopers95522483do_pers
dopes84935043do_pe_s
dopiest103315993dopiest
dorpers104113173dorpers
droplets1136063droplets
droppers13318603droppers
epopees1137233epopees
floppers15337463floppers
fopped144012673foppe_d
foppery17385623foppery
forgets113813793forgets
gippers123212083gippers
gobbets12327643gobbets
goblets103210183goblets
godets8410933go_dets
goglets9379783goglets
gophers1338983gophers
gorgets94711783gorgets
gospels1035593gospels
gyppers15235503gyppers
happens14359173happens
heppest14228143heppest
hippest14219753hippest
hoggets12498323hoggets
hoopers123616483hoopers
hopers114222973ho_pers
hopes105835643ho_pe_s
hopped144318113hoppe_d
hopper134218483hoppe_r
hoppiest152610723hoppiest
hopples142810713hopples
hornets104113553hornets
howlets13329223howlets
kippers153211433kippers
kopeks1134603ko_peks
kopjes1935363kopje_s
koppas14407603kopp_as
koppies153210013koppies
lappers113717463lappers
lappet103817723lappet_
limpets11329783limpets
lippens11328533lippens
lippers113416443lippers
lockets134612203lockets
loggets9378913loggets
loopers93914033loopers
lopers84424143lo_pers
lopes76437343lo_pe_s
lopped114218623loppe_d
lopper103717203loppe_r
loppiest122410103loppiest
loupes84918053loupe_s
magnets10311143magnets
mallets93318493mallets
mammets103911113mammets
maples104819423maple_s
mapped134015883mappe_d
mapper124516093mappe_r
markets133314033markets
maumets11369693maumets
meets74224613m__eets
midgets113910253midgets
millets94216843millets
minuets9259853minuets
mispens11311073mispens
missets94516573missets
moaners92813553moaners
moats75827643mo__ats
mobbers133610923mobbers
mockers153812943mockers
models94216353mo_dels
modems114610763mo_dems
modes85537413mo_de_s
modest93818453mo_dest
mohels115011323mo_hels
moiety1148223mo_iety
moilers93615203moilers
moires8915633moire_s
mojoes15399523mojoe_s
mokes114631033mo_ke_s
molders103315553molders
moles74747923mo_le_s
molest85022743mo_lest
molests93311563molests
molies84429513molie_s
molters93816973molters
molts76032093mo__lts
moments113113123moments
momes95134473mo_me_s
momsers113810843momsers
momzers20367133momzers
mondes94322353monde_s
moneys115513623mo_neys
mongers104217273mongers
monies83233163monie_s
monists93614783monists
monkeys16407423monkeys
montes84226933monte_s
mooleys1236863mooleys
mooners94015343mooners
moonlets10247473moonlets
moonsets10216413moonsets
mooters93818623mooters
moots75831663mo__ots
mope86838043mo_pe__
moped105424733mo_pe_d
moper94925923mo_pe_r
mopery135210973mo_pery
mopey124821823mo_pe_y
mopier103914783mopie_r
mopiness12259063mopiness
mopokes1536693mopokes
mopping143411473mopping
mops85940133mo_p__s
mordents1138813mordents
moreens939963moreens
morels84820013mo_rels
mores76249643mo_re_s
morgens10310463morgens
morphos14159083morphos
morphs13149433morp_hs
morsels94112653morsels
morts75533563mo__rts
moseys114711703mo_seys
moshers124017843moshers
moshes115222873moshe_s
mossers94116193mossers
mosses85527683mosse_s
mostest9314793mostest
mostests1036833mostests
mosts76028543mo__sts
motels83616893mo_tels
motes75944003mo_te_s
motet75641193mo_tet_
mothers123717623mothers
motleys1235683motleys
motmots1166133motmots
mots66853163mo___ts
mottes85523693motte_s
motts76527003mo__tts
moues75732843mo_ue_s
moults84713703mo_ults
mounts84115073mo_unts
mousers95216443mousers
mouses85531423mouse_s
movers115117193mo_vers
moves106128423mo_ve_s
movies115118453movie_s
mowers113219403mo_wers
moxies154317403moxie_s
mullets93614783mullets
mumpers133311373mumpers
muskets13258643muskets
myopes13419963myope_s
myopies14309723myopie_s
nappers114214863nappers
nappes104515623nappe_s
nippers113012623nippers
nonets64118703no_nets
objets15125323_objets
octets839403_octets
omelets938333omelets
onsets64013543_onsets
opens76118553_o_pens
opes65942613_o_pe_s
oppress1135993_oppress
opts68124743_o_p_ts
owlets93110393_owlets
peppers103311443peppers
pets66248333___pets
pipets105714773_pipets
pockets154612253pockets
poets76024443__poets
popes95933813po_pe_s
poppas93710713popp_as
popped104117813poppe_d
popper93615963poppe_r
poppies102816193poppies
popples103011873popples
possets94212773possets
prophets1539503prophets
propjets1935493propjets
puppet93514593puppet_
rappees113611453rappees
rappels11448803rappels
rappers113618443rappers
rippers114115033rippers
ripplets12316733ripplets
rochets124213473rochets
rockets134615363rockets
rompers113412243rompers
ropers84325903ro_pers
ropes75940063ro_pe_s
ropiest93317773ropiest
roquets16398943roquets
rosets65819953ro_sets
roupet84218343roupet_
sappers113518903sappers
septets998953septets
shoppers153010763shoppers
shoppes143411393shoppe_s
sippers113117753sippers
sippet103519393sippet_
skippets16284563skippets
snippets12225623snippets
soapers93715923soapers
sockets134012983sockets
sonnets74211993sonnets
sopites93817173sopites
sopped114819903soppe_d
soppiest122511933soppiest
sorbets93012513sorbets
soviets1087293soviets
stoppers123910593stoppers
suppers113314703suppers
tappers113416543tappers
tappet103820113tappet_
tippers113414353tippers
tippet103917873tippet_
toilets74112913toilets
tonlets73212503tonlets
topees85519703to_pees
topers85025323to_pers
topes76941763to_pe_s
tophes115218423tophe_s
topless92511123topless
topped114617723toppe_d
topper103817603toppe_r
topples113111653topples
toquets16367863toquets
toupees938513toupees
trippets12357423trippets
uppers102912293_uppers
upsets8409683_upsets
whippets18255253whippets
whoppers18297533whoppers
worsets105512843worsets
yappers144012253yappers
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 Limit1340273166.06022116.7
3Display Results3163160.1102872.7
 (SQL Overall)1786913166.57627173.2
 
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.