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

475 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
mores7624964(None) 
bores76448251bores
cores76361851cores
fores85847101fores
gores65740371gores
lores55045401lores
mares76457631mares
meres75143571meres
mires75640881mires
modes85537411modes
moires8915631moires
mokes114631031mokes
moles74747921moles
momes95134471momes
mopes95134981mopes
moras76438761moras
more67154521more_
morel75729091morel
morels84820011morels
morns75527441morns
mors65950061mor_s
morse76032701morse
morts75533561morts
motes75944001motes
moues75732841moues
moves106128421moves
mures75937211mures
ores46056681_ores
pores75849031pores
sores55454281sores
tores55352671tores
yores85031321yores
acres76327762acres
adores74420712adores
amoles84122192amoles
apres75426402apres
ares45871022_ares
aures55137092aures
bares75457132bares
bodes84935102bodes
boles75448602boles
bones76446532bones
boras75938302boras
bore66051332bore_
boreas85421732boreas
bored85034302bored
borer75131272borer
borers85122682borers
borks115727702borks
borts76735452borts
boxes145625072boxes
byres104421382byres
cares77369182cares
ceres75540012ceres
chores114828022chores
cires74932912cires
codes86247292codes
cokes115537192cokes
coles76055062coles
comes97246992comes
cones76457422cones
copes97747102copes
cords86030622cords
core67263112core_
cored85044222cored
corer75538872corer
corers85231072corers
corks116028272corks
corms95626222corms
corns76034762corns
corps95927042corps
cors66656442cor_s
corse75036182corse
corses84433462corses
corves115122522corves
coses76949492coses
cotes76347842cotes
coves105539172coves
coxes145430862coxes
cozes166033242cozes
crores86121162crores
cures75645432cures
dares66146702dares
doers65225712doers
does56554472do_es
doges75630162doges
doles67843752doles
domes85735562domes
dopes84935042dopes
dore56353302dore_
dories75232362dories
dorks105724442dorks
dorms85723832dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602dor_s
doses65938502doses
dotes65836692dotes
doves94728152doves
dozes155226302dozes
dures65635922dures
emotes84620282emotes
eyres84921772eyres
fares85852872fares
feres86038182feres
fires85740752fires
foes76543442fo_es
forbs105720802forbs
forces114422132forces
fords95328182fords
fore78351472fore_
forest94926742forest
forges105024262forges
forks125324682forks
formes114623712formes
forms105327052forms
fortes95327182fortes
forts86034452forts
foxes156321092foxes
froes86126692froes
goers65520252goers
goes55644092go_es
gore55744962gore_
gored75227082gored
gorges85321892gorges
gorms85619592gorms
gorps85316992gorps
gorse65926812gorse
gorses74723292gorses
goxes135018262goxes
gyres94820322gyres
hares86255542hares
heres86245902heres
hires86134342hires
hoers85724922hoers
hoes75755732ho_es
hokes126231642hokes
holes84748652holes
homes106938812homes
hones88144492hones
hopes105835642hopes
horas86333092horas
hordes104921632hordes
horns86125332horns
horse86132652horse
horses94729342horses
hoses85443172hoses
howes114730262howes
ires45639282_ires
joes116635892jo_es
jokes165423332jokes
joles125230832joles
jones125028182jones
koras95927112koras
kore85834162kore_
kors85933012kor_s
lares54852632lares
lobes75331002lobes
lodes66436912lodes
loges66534202loges
lopes76437342lopes
lords64923502lords
lore45850352lore_
lories64933042lories
loris55329152loris
loses56742012loses
loves85332012loves
lowes85732462lowes
loxes125227472loxes
lures56138532lures
lyres85019962lyres
mabes96331532mabes
maces97139962maces
madres93718182madres
maes66948392m_aes
mages85036022mages
makes115336852makes
males75049792males
manes76648952manes
maras75443282maras
marcs95726622marcs
mare64759322mare_
marges94525712marges
marks115933482marks
marls75535162marls
mars66261862mar_s
marse76231152marse
marses84827112marses
marts77442232marts
mates75251362mates
matres84522232matres
maxes145629532maxes
mazes165632172mazes
memes94927702memes
merces105720742merces
mercs96020452mercs
merdes94518602merdes
mere67244442mere_
merer75126232merer
merest84725112merest
merges94122482merges
merks114722402merks
merles85322762merles
merls77423902merls
metes74736212metes
metres85121562metres
mezes167719262mezes
mikes115129892mikes
miles74645072miles
mimes95732022mimes
mines75651952mines
mioses84318852mioses
mire66748222mire_
mired85729222mired
mirex146816622mirex
mirks115122142mirks
mirs66940562mir_s
mises74740562mises
mites75141802mites
mitres83922072mitres
mixes147224402mixes
moans74624362moans
moas65545342mo_as
moats75827642moats
mobs85737362mo_bs
mocks135023822mocks
mocs85834902mo_cs
mode75840302mode_
model84521692model
models94216352models
modem103717142modem
modems114610762modems
modest93818452modest
mods77945052mo_ds
modus85417202modus
mogs75439332mo_gs
mohel104914832mohel
mohels115011322mohels
moils76125742moils
moire71017312moire_
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
moored93814172moored
moors74923142moors
moos66051302mo_os
moose76327192moose
moots75831662moots
mope86838042mope_
moped105424732moped
mopeds11499662mopeds
moper94925922moper
mopers104220372mopers
mopey124821822mopey
mops85940132mo_ps
mor56855002mor__
mora66641272mor_a
morae75831192morae
moral75533432moral
morales93619402morales
morals85324632morals
morass84614492morass
moray105423792moray
morays114613882morays
moreen8313342moreen
moreens939962moreens
morgen9312202morgen
morgens10310462morgens
morgues1038272morgues
morn66237562mor_n
moron76925422moron
morons84919542morons
morose85116242morose
morph121712512morph
morphs13149432morphs
morris83814722morris
morro73216952morro
morros83714672morros
morsel85815892morsel
morsels94112652morsels
mort66758832mor_t
mos57067122mo__s
mosey105922872mosey
moseys114711702moseys
moshes115222872moshes
mosks116117002mosks
moss67641032mo_ss
mosses85527682mosses
mosts76028542mosts
mote67048082mote_
motel76623242motel
motels83616892motels
motet75641192motet
motets84216192motets
motey105922952motey
moths106021552moths
mots66853162mo_ts
mottes85523692mottes
motts76527002motts
moue65835572moue_
mourns84111012mourns
mouse77133002mouse
mouses85531422mouses
move96630722move_
moved114218152moved
mover104220862mover
movers115117192movers
movies115118452movies
mowed113629012mowed
mower104523452mower
mowers113219402mowers
mows96340832mo_ws
moxas145014392moxas
moxies154317402moxies
mozos165516332mozos
mules75034292mules
muras75329562muras
mure65941332mure_
mured85726702mured
murex145517172murex
murks114821722murks
murres85019042murres
murrs75521292murrs
muses75134302muses
mutes75033782mutes
myopes13419962myopes
myoses114013842myoses
nares55544152nares
nodes64633492nodes
noes45845392no_es
nomes74933122nomes
nones55639132nones
noris54928272noris
norms76019302norms
noses55435642noses
notes55034582notes
obes66036832_obes
odes57243242_odes
oes35866192_o_es
ogres65818632ogres
okes84936342_okes
oles46453472_oles
ombres103911132ombres
omers76923192omers
ones46146532_ones
oozes145418712oozes
opes65942612_opes
orbs66626252_orbs
orcs67025432_orcs
ore36661832_ore_
orles55326212_orles
ors35750112_or_s
orts46538332_orts
oses46641512_oses
owes75137102_owes
oxes116530722_oxes
oyes74940132_oyes
pares77164482pares
peres76246642peres
pokes116133012pokes
poles75351002poles
pomes94833932pomes
pones74547042pones
popes95933812popes
pore66451262pore_
pored85234512pored
porks115124142porks
porns75527342porns
ports75934592ports
poses74642762poses
poxes145325722poxes
pyres105523882pyres
rares55247442rares
res35565042__res
robes75133302robes
rodes614039082rodes
roes45954132ro_es
roles56747982roles
ropes75940062ropes
roses56445772roses
rotes56143902rotes
roues56039352roues
roves84834482roves
scores84725922scores
seres55448892seres
shores94830402shores
sires55945372sires
smokes124814342smokes
snores64324312snores
sokes95031422sokes
soles55547922soles
sones55444142sones
soras55041012soras
sorbs75022102sorbs
sords64527802sords
sore47059532sore_
sored66141782sored
sorel56231442sorel
sorels63921162sorels
sorer56236572sorer
sorest65027992sorest
sorns55028412sorns
sorts54536662sorts
sorus54527582sorus
spores84726612spores
stores65533642stores
tares57456562tares
tires55437492tires
toes46956442to_es
tokes95234972tokes
toles55147132toles
tomes76037382tomes
tones56048662tones
topes76941762topes
toras55540372toras
torcs75123762torcs
tore47359322tore_
tories65435882tories
toros54336192toros
torrs53923562torrs
tors46157382tor_s
torse55833332torse
torses64727952torses
tortes64826052tortes
torts56138122torts
torus54329762torus
totes55139682totes
tres46542902_tres
tsores65113662tsores
tyres84725232tyres
vires84529682vires
voces105918052voces
voes75432822vo_es
voles86234042voles
votes84627082votes
wares88250582wares
whores125617102whores
wires86034912wires
woes76440662wo_es
words95425072words
wore77144672wore_
works125621902works
worms105320752worms
worse86525262worse
worses95522952worses
worts88631182worts
yokes125223022yokes
yore76335942yore_
yowes114926372yowes
zones145528042zones
zoris145320012zoris

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 Limit538004751.75030742.9
3Display Results4754750.1403392.9
 (SQL Overall)1786914751.98390111.4
 
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.