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

422 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
motes7594400(None) 
cotes76347841cotes
dotes65836691dotes
emotes84620281emotes
mates75251361mates
metes74736211metes
mites75141801mites
modes85537411modes
mokes114631031mokes
moles74747921moles
momes95134471momes
montes84226931montes
mopes95134981mopes
mores76249641mores
mote67048081mote_
motel76623241motel
motels83616891motels
motet75641191motet
motets84216191motets
motey105922951motey
moths106021551moths
mots66853161mot_s
mottes85523691mottes
motts76527001motts
moues75732841moues
moves106128421moves
mutes75033781mutes
notes55034581notes
rotes56143901rotes
totes55139681totes
votes84627081votes
amoles84122192amoles
antes56334322antes
ates45047922_ates
azotes154312222azotes
bates75846342bates
bites75641172bites
bodes84935102bodes
boites84322702boites
boles75448602boles
bones76446532bones
bores76448252bores
botas75328782botas
botel75121862botel
botels84815802botels
bots66453952bot_s
botts75224862botts
boxes145625072boxes
butes714535872butes
bytes105217492bytes
cates75951872cates
cetes75731102cetes
cites74435582cites
codes86247292codes
cokes115537192cokes
coles76055062coles
comes97246992comes
comtes106222812comtes
cones76457422cones
contes84432912contes
copes97747102copes
cores76361852cores
coses76949492coses
cote66648732cote_
coted85033852coted
cots68054842cot_s
coves105539172coves
coxes145430862coxes
cozes166033242cozes
cutes79438312cutes
dates65639152dates
demotes104717672demotes
dites66339152dites
does56554472do_es
doges75630162doges
doles67843752doles
domes85735562domes
dopes84935042dopes
doses65938502doses
dote55442882dote_
doted75227072doted
doter65428622doter
doters74423912doters
dots55647662dot_s
doves94728152doves
dozes155226302dozes
emote75421192emote_
emoted94614922emoted
emoter85415192emoter
emoters94712872emoters
fates85139232fates
fetes85630142fetes
foes76543442fo_es
fores85847102fores
fortes95327182fortes
foxes156321092foxes
gates65939502gates
gemotes103712142gemotes
gites65630182gites
goes55644092go_es
gores65740372gores
goths96513002goths
goxes135018262goxes
hates86742572hates
hoes75755732ho_es
hokes126231642hokes
holes84748652holes
homes106938812homes
hones88144492hones
hopes105835642hopes
hoses85443172hoses
hotel85520742hotel
hotels94515502hotels
hots78349322hot_s
howes114730262howes
iotas54821112iotas
jetes124922842jetes
joes116635892jo_es
jokes165423332jokes
joles125230832joles
jones125028182jones
jotas125717442jotas
jots116336142jot_s
jutes125125132jutes
kites95432542kites
kotos95717692kotos
kytes125012912kytes
lobes75331002lobes
lodes66436912lodes
loges66534202loges
lopes76437342lopes
lores55045402lores
loses56742012loses
lotas55926302lotas
lotos54724632lotos
lots47652092lot_s
lottes65322752lottes
lotus55718062lotus
loves85332012loves
lowes85732462lowes
loxes125227472loxes
lutes55836662lutes
mabes96331532mabes
maces97139962maces
maes66948392m_aes
mages85036022mages
makes115336852makes
males75049792males
manes76648952manes
mantes84430782mantes
mares76457632mares
mate65154212mate_
mated85537782mated
mater74438862mater
maters85032382maters
matey107022662matey
mateys115610942mateys
maths105624022maths
matres84522232matres
mats65460282mat_s
mattes85624532mattes
matts76829182matts
maxes145629532maxes
mazes165632172mazes
meets74224612meets
memes94927702memes
meres75143572meres
mete64438132mete_
meted85424432meted
meter75130322meter
meters85625832meters
meths105320232meths
metis75025902metis
metres85121562metres
mezes167719262mezes
mikes115129892mikes
miles74645072miles
mimes95732022mimes
mines75651952mines
mioses84318852mioses
mires75640882mires
mises74740562mises
mite66249402mite_
miter75734792miter
miters84328772miters
mitis75425982mitis
mitres83922072mitres
mitts75523752mitts
mixes147224402mixes
moans74624362moans
moas65545342mo_as
moated94819002moated
moats75827642moats
mobs85737362mo_bs
mocks135023822mocks
mocs85834902mo_cs
mode75840302mode_
model84521692model
models94216352models
modem103717142modem
modems114610762modems
modest93818452modest
mods77945052mo_ds
modus85417202modus
mogs75439332mo_gs
mohel104914832mohel
mohels115011322mohels
moils76125742moils
moires8915632moires
mojoes15399522mojoes
mojos145314462mojos
moke106234222moke_
molas75132092molas
molds85324832molds
mole66251832mole_
molest85022742molest
molies84429512molies
molls75129782molls
mols65948572mo_ls
molted94217472molted
molten83311812molten
molter84119422molter
molters93816972molters
molts76032092molts
mome85239352mome_
moms86539482mo_ms
momus96116112momus
monas74732152monas
mondes94322352mondes
money104826842money
moneys115513622moneys
monies83233162monies
monks116123392monks
monos75930862monos
mons68152252mo_ns
monte75829772monte_
months113812932months
moods85224622moods
mooed85123982mooed
mools76027172mools
moons75331002moons
moors74923142moors
moos66051302mo_os
moose76327192moose
mooted94120372mooted
mooter83921092mooter
mooters93818622mooters
moots75831662moots
mope86838042mope_
moped105424732moped
mopeds11499662mopeds
moper94925922moper
mopers104220372mopers
mopey124821822mopey
mops85940132mo_ps
moras76438762moras
more67154522more_
morel75729092morel
morels84820012morels
morns75527442morns
mors65950062mo_rs
morse76032702morse
morts75533562morts
mos57067122mo__s
mosey105922872mosey
moseys114711702moseys
moshes115222872moshes
mosks116117002mosks
moss67641032mo_ss
mosses85527682mosses
moste75925082moste_
mostest9314792mostest
mosts76028542mosts
mot57279422mot__
moth96731332mot_h
mother113718642mother
mothers123717622mothers
mothy136214552mothy
motif10519662motif
motifs1139672motifs
motiles93317432motiles
motives123611892motives
motley1139382motley
motleys1235682motleys
motor75317292motor
motors84616592motors
mott66648442mot_t
motte75526972motte
mottles93415802mottles
motto76119512motto
mottoes93412192mottoes
mottos84615242mottos
moue65835572moue_
mouse77133002mouse
mouses85531422mouses
mouths115214532mouths
move96630722move_
moved114218152moved
mover104220862mover
movers115117192movers
movies115118452movies
mowed113629012mowed
mower104523452mower
mowers113219402mowers
mows96340832mo_ws
moxas145014392moxas
moxies154317402moxies
mozos165516332mozos
mules75034292mules
mures75937212mures
muses75134302muses
mute65136872mute_
muted85023382muted
muter74525542muter
mutest84218052mutest
muts64839982mut_s
mutts75120252mutts
myopes13419962myopes
myoses114013842myoses
myths135911602myths
nates55238332nates
nites55736342nites
nodes64633492nodes
noes45845392no_es
nomes74933122nomes
nones55639132nones
noses55435642noses
note46239962note_
noted65123842noted
noter55025642noter
noters64020992noters
obes66036832_obes
odes57243242_odes
oes35866192_o_es
okes84936342_okes
oles46453472_oles
ones46146532_ones
oots46446442oot_s
oozes145418712oozes
opes65942612_opes
ores46056682_ores
oses46641512_oses
owes75137102_owes
oxes116530722_oxes
oyes74940132_oyes
pates76047892pates
poets76024442poets
pokes116133012pokes
poles75351002poles
pomes94833932pomes
pones74547042pones
pontes83627852pontes
popes95933812popes
pores75849032pores
poses74642762poses
pots66452362pot_s
poxes145325722poxes
quotes153312462quotes
rates55352012rates
remotes94521612remotes
rites54442552rites
robes75133302robes
rodes614039082rodes
roes45954132ro_es
roles56747982roles
ropes75940062ropes
roses56445772roses
rotas54827722rotas
rote46249022rote_
rotis56327052rotis
rotls55620162rotls
rotos56027882rotos
rots46454092rot_s
rottes64524832rottes
roues56039352roues
routes66129312routes
roves84834482roves
sates54949322sates
shotes95321892shotes
sites56045432sites
smites83921922smites
smokes124814342smokes
smote75820272smote_
sokes95031422sokes
soles55547922soles
sones55444142sones
sores55454282sores
soths86218622soths
sots45552442sot_s
tates55444982tates
toes46956442to_es
tokes95234972tokes
toles55147132toles
tomes76037382tomes
tones56048662tones
topes76941762topes
tores55352672tores
tortes64826052tortes
tote46643672tote_
toted64929482toted
totem74819362totem
totems86810762totems
toter55932132toter
toters65026362toters
tots46654122tot_s
utes45930882_utes
voces105918052voces
voes75432822vo_es
voles86234042voles
voltes94915582voltes
vote74728622vote_
voted93919142voted
voter85121052voter
voters95017442voters
wites85536962wites
woes76440662wo_es
wots76342892wot_s
wytes114113432wytes
yokes125223022yokes
yores85031322yores
yowes114926372yowes
zones145528042zones

Search took 3 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 Limit538004221.87328724.0
3Display Results4224220.1263349.2
 (SQL Overall)1786914222.09285416.3
 
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.