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 “mopes” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

360 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
mopes9513498(None) 
copes97747101copes
dopes84935041dopes
hopes105835641hopes
lopes76437341lopes
modes85537411modes
mokes114631031mokes
moles74747921moles
momes95134471momes
mope86838041mope_
moped105424731moped
mopeds11499661mopeds
moper94925921moper
mopers104220371mopers
mopey124821821mopey
mops85940131mop_s
mores76249641mores
motes75944001motes
moues75732841moues
moves106128421moves
myopes13419961myopes
opes65942611_opes
popes95933811popes
ropes75940061ropes
topes76941761topes
amoles84122192amoles
apes66047432_apes
bodes84935102bodes
boles75448602boles
bones76446532bones
bops86037982bop_s
bores76448252bores
boxes145625072boxes
capes95441922capes
cepes94424462cepes
codes86247292codes
cokes115537192cokes
coles76055062coles
comes97246992comes
cones76457422cones
cope86847382cope_
coped105036842coped
copen94826432copen
copens106119962copens
coper95336092coper
copers104629842copers
copies104130302copies
cops86751372cop_s
copse95623922copse
copses104922472copses
cores76361852cores
coses76949492coses
cotes76347842cotes
coupes105022522coupes
coves105539172coves
coxes145430862coxes
cozes166033242cozes
does56554472do_es
doges75630162doges
doles67843752doles
domes85735562domes
dopas85019062dopas
dope76038892dope_
doped95326712doped
doper86128392doper
dopers95522482dopers
dopey116020352dopey
doses65938502doses
dotes65836692dotes
doves94728152doves
dozes155226302dozes
dupes86425932dupes
elopes85918162elopes
emotes84620282emotes
foes76543442fo_es
fops96532682fop_s
fores85847102fores
foxes156321092foxes
gapes86030822gapes
goes55644092go_es
gores65740372gores
goxes135018262goxes
gropes95220402gropes
hoes75755732ho_es
hokes126231642hokes
holes84748652holes
homes106938812homes
hones88144492hones
hope96639672hope_
hoped115628182hoped
hoper105829142hoper
hopers114222972hopers
hops97942632hop_s
hoses85443172hoses
howes114730262howes
hypes135818672hypes
japes146322822japes
joes116635892jo_es
jokes165423332jokes
joles125230832joles
jones125028182jones
jupes145218552jupes
kopek1037812kopek
kopeks1134602kopeks
kophs145010932kophs
kopjes1935362kopjes
kops107031292kop_s
lobes75331002lobes
lodes66436912lodes
loges66534202loges
lope65941922lope_
loped85128332loped
loper75129232loper
lopers84424142lopers
lops66043352lop_s
lores55045402lores
loses56742012loses
loupes84918052loupes
loves85332012loves
lowes85732462lowes
loxes125227472loxes
mabes96331532mabes
maces97139962maces
maes66948392m_aes
mages85036022mages
makes115336852makes
males75049792males
manes76648952manes
maples104819422maples
maps86141042map_s
mares76457632mares
mates75251362mates
maxes145629532maxes
mazes165632172mazes
memes94927702memes
meres75143572meres
metes74736212metes
metopes11311362metopes
mezes167719262mezes
mikes115129892mikes
miles74645072miles
mimes95732022mimes
mines75651952mines
mioses84318852mioses
mips85534082mip_s
mires75640882mires
mises74740562mises
mites75141802mites
mixes147224402mixes
moans74624362moans
moas65545342mo_as
moats75827642moats
mobs85737372mo_bs
mocks135023822mocks
mocs85834902mo_cs
mode75840302mode_
model84521692model
models94216352models
modem103717142modem
modems114610762modems
modest93818452modest
mods77945052mo_ds
modus85417202modus
mogs75439332mo_gs
mohel104914832mohel
mohels115011322mohels
moils76125752moils
moires8915632moires
mojoes15399522mojoes
mojos145314462mojos
moke106234222moke_
molas75132092molas
molds85324832molds
mole66251832mole_
molest85022742molest
molies84429512molies
molls75129782molls
mols65948572mo_ls
molts76032092molts
mome85239352mome_
moms86539482mo_ms
momus96116112momus
monas74732152monas
mondes94322352mondes
money104826842money
moneys115513622moneys
monies83233162monies
monks116123392monks
monos75930862monos
mons68152252mo_ns
montes84226932montes
moods85224622moods
mooed85123982mooed
mools76027172mools
moons75331002moons
moors74923142moors
moos66051302mo_os
moose76327192moose
moots75831662moots
mop76950822mop__
mopery135210972mopery
mopier103914782mopier
mopiest113014292mopiest
mopish134311592mopish
mopokes1536692mopokes
mopped134114322mopped
mopper126215002mopper
moppers133412452moppers
moppet126915092moppet
moppets13307162moppets
mopy115721972mop_y
moras76438762moras
more67154522more_
morel75729092morel
morels84820012morels
morns75527442morns
morphs13149432morphs
mors65950062mo_rs
morse76032702morse
morts75533562morts
mos57067122mo__s
mosey105922872mosey
moseys114711702moseys
moshes115222872moshes
mosks116117002mosks
moss67641032mo_ss
mosses85527682mosses
mosts76028542mosts
mote67048082mote_
motel76623242motel
motels83616892motels
motet75641192motet
motets84216192motets
motey105922952motey
moths106021552moths
mots66853162mo_ts
mottes85523692mottes
motts76527002motts
moue65835572moue_
mouse77133002mouse
mouses85531422mouses
move96630722move_
moved114218152moved
mover104220862mover
movers115117192movers
movies115118452movies
mowed113629012mowed
mower104523452mower
mowers113219402mowers
mows96340832mo_ws
moxas145014392moxas
moxies154317402moxies
mozos165516332mozos
mules75034292mules
mures75937212mures
muses75134302muses
mutes75033782mutes
myope124010972myope_
myopies14309712myopies
myoses114013842myoses
napes74828462napes
nodes64633492nodes
noes45845392no_es
nomes74933122nomes
nones55639132nones
nope65934192nope_
noses55435642noses
notes55034582notes
obes66036832_obes
odes57243242_odes
oes35866192_o_es
okes84936342_okes
oles46453472_oles
ones46146532_ones
oops65232672oop_s
oozes145418712oozes
ope56845242_ope_
oped76230152_oped
open66427002_open
opens76118552_opens
ops56641252_op_s
opts68124742_opts
opus66420592_opus
ores46056682_ores
oses46641512_oses
owes75137102_owes
oxes116530722_oxes
oyes74940132_oyes
pes57259782__pes
pipes96030142pipes
pokes116133012pokes
poles75351002poles
pomes94833932pomes
pones74547042pones
pope85535612pope_
pops86340952pop_s
pores75849032pores
poses74642762poses
poxes145325722poxes
qophs19507812qophs
rapes75740722rapes
ripes75435772ripes
robes75133302robes
rodes614039082rodes
roes45954132ro_es
roles56747982roles
rope65542912rope_
roped84630802roped
roper75431912roper
ropers84325902ropers
ropey106021872ropey
roses56445772roses
rotes56143902rotes
roues56039352roues
roves84834482roves
scopes104719592scopes
sipes76036952sipes
slopes84820452slopes
smokes124814342smokes
sokes95031422sokes
soles55547922soles
sones55444142sones
sophs104916022sophs
sops65244562sop_s
sores55454282sores
stopes84525892stopes
supes75628302supes
tapes75838602tapes
toes46956442to_es
tokes95234972tokes
toles55147132toles
tomes76037382tomes
tones56048662tones
tope65946382tope_
toped85631312toped
topee76029952topee
topees85519702topees
toper75231022toper
topers85025322topers
tophes115218422tophes
tophs105220052tophs
topis76025832topis
topos75726392topos
tops66248122top_s
tores55352672tores
totes55139682totes
tropes84824352tropes
types105721062types
voces105918052voces
voes75432822vo_es
voles86234042voles
votes84627082votes
wipes104827082wipes
woes76440662wo_es
wops96634152wop_s
yipes106017842yipes
yokes125223022yokes
yores85031322yores
yowes114926372yowes
zones145528042zones

Search took 4 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 Filter178691538000.0931921408.6
2DLD Change Limit538003603.42315717.2
3Display Results3603600.1103272.7
 (SQL Overall)1786913603.62649280.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.