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

337 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
moves10612842(None) 
coves105539171coves
doves94728151doves
loves85332011loves
modes85537411modes
mokes114631031mokes
moles74747921moles
momes95134471momes
mopes95134981mopes
mores76249641mores
motes75944001motes
moues75732841moues
move96630721move_
moved114218151moved
mover104220861mover
movers115117191movers
movies115118451movies
roves84834481roves
aboves114512842aboves
amoles84122192amoles
aves76142602_aves
bodes84935102bodes
boles75448602boles
bones76446532bones
bores76448252bores
boxes145625072boxes
caves105639702caves
cloves114918822cloves
codes86247292codes
cokes115537192cokes
coles76055062coles
comes97246992comes
cones76457422cones
copes97747102copes
cores76361852cores
corves115122522corves
coses76949492coses
cotes76347842cotes
cove95837072cove_
coved115027372coved
coven106925042coven
covens114919262covens
cover105430772cover
covers114627962covers
covet105638942covet
covets114819642covets
covey136121782covey
coveys145413502coveys
coxes145430862coxes
cozes166033242cozes
dives95832402dives
does56554472do_es
doges75630162doges
doles67843752doles
domes85735562domes
dopes84935042dopes
doses65938502doses
dotes65836692dotes
dove85131562dove_
doven94718552doven
dovens104413902dovens
dozes155226302dozes
droves105116672droves
eaves85231992eaves
elves85118742elves
emotes84620282emotes
eves76230462_eves
faves115331422faves
fives116027362fives
foes76543442fo_es
fores85847102fores
fovea11310482fovea
foveas1238622foveas
foxes156321092foxes
gives95324872gives
gloves104115182gloves
goes55644092go_es
gores65740372gores
goxes135018262goxes
groves104318102groves
gyves125711552gyves
haves116034872haves
hives116925512hives
hoes75755732ho_es
hokes126231642hokes
holes84748652holes
homes106938812homes
hones88144492hones
hooves124815482hooves
hopes105835642hopes
hoses85443172hoses
hove107132222hove_
hovel115017682hovel
hovels125413332hovels
hover115524132hover
hovers124320252hovers
howes114730262howes
jives154820812jives
joes116635892jo_es
jokes165423332jokes
joles125230832joles
jones125028182jones
laves86039152laves
lives86133192lives
loaves94813852loaves
lobes75331002lobes
lodes66436912lodes
loges66534202loges
lopes76437342lopes
lores55045402lores
loses56742012loses
love75234762love_
loved95021362loved
lover85526452lover
lovers94223432lovers
lowes85732462lowes
loxes125227472loxes
mabes96331532mabes
maces97139962maces
maes66948392m_aes
mages85036022mages
makes115336852makes
males75049792males
manes76648952manes
mares76457632mares
mates75251362mates
mauves113811552mauves
maven104816892maven
mavens114312972mavens
mavies114923192mavies
mavis105622722mavis
maxes145629532maxes
mazes165632172mazes
memes94927702memes
meres75143572meres
metes74736212metes
mezes167719262mezes
mikes115129892mikes
miles74645072miles
mimes95732022mimes
mines75651952mines
mioses84318852mioses
mires75640882mires
mises74740562mises
mites75141802mites
mixes147224402mixes
moans74624362moans
moas65545342mo_as
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
molts76032092molts
mome85239352mome_
moms86539482mo_ms
momus96116112momus
monas74732152monas
mondes94322352mondes
money104826842money
moneys115513622moneys
monies83233162monies
monks116123392monks
monos75930862monos
mons68152252mo_ns
montes84226932montes
moods85224622moods
mooed85123982mooed
mools76027172mools
moons75331002moons
moors74923142moors
moos66051302mo_os
moose76327192moose
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
mosts76028542mosts
mote67048082mote_
motel76623242motel
motels83616892motels
motet75641192motet
motets84216192motets
motey105922952motey
moths106021552moths
motives123611892motives
mots66853162mo_ts
mottes85523692mottes
motts76527002motts
moue65835572moue_
mouse77133002mouse
mouses85531422mouses
movie105319132movie
mowed113629012mowed
mower104523452mower
mowers113219402mowers
mows96340832mo_ws
moxas145014392moxas
moxies154317402moxies
mozos165516332mozos
mules75034292mules
mures75937212mures
muses75134302muses
mutes75033782mutes
myopes13419962myopes
myoses114013842myoses
naves87030382naves
neves87021872neves
nodes64633492nodes
noes45845392no_es
nomes74933122nomes
nones55639132nones
noses55435642noses
notes55034582notes
novas85215362novas
novel85615992novel
novels95512502novels
oaves84925612oaves
obes66036832_obes
odes57243242_odes
oes35866192_o_es
okes84936342_okes
oles46453472_oles
ones46146532_ones
oozes145418712oozes
opes65942612_opes
ores46056682_ores
oses46641512_oses
oven76624142_oven
ovens86217452_ovens
over77227342_over
overs85224792_overs
owes75137102_owes
oxes116530722_oxes
oyes74940132_oyes
paves104833922paves
pokes116133012pokes
poles75351002poles
pomes94833932pomes
pones74547042pones
pooves113914712pooves
popes95933812popes
pores75849032pores
poses74642762poses
poxes145325722poxes
proves114322252proves
raves85441972raves
removes124514712removes
rives85336002rives
robes75133302robes
rodes614039082rodes
roes45954132ro_es
roles56747982roles
ropes75940062ropes
roses56445772roses
rotes56143902rotes
roues56039352roues
rove75136982rove_
roved95323552roved
roven85521972roven
rover85527372rover
rovers95423522rovers
saves85838632saves
shoves124919412shoves
smokes124814342smokes
soaves94218672soaves
sokes95031422sokes
soles55547922soles
solves95018222solves
sones55444142sones
sores55454282sores
stoves93818922stoves
toes46956442to_es
tokes95234972tokes
toles55147132toles
tomes76037382tomes
tones56048662tones
topes76941762topes
tores55352672tores
totes55139682totes
troves94719112troves
voces105918052voces
voes75432822vo_es
voles86234042voles
votes84627082votes
waves115633922waves
wives115328922wives
woes76440662wo_es
wolves124510852wolves
wove105624312wove_
woven115215172woven
wovens12449832wovens
yokes125223022yokes
yores85031322yores
yowes114926372yowes
zones145528042zones

Search took 2 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 Limit538003371.58034050.6
3Display Results3373370.0933623.7
 (SQL Overall)1786913371.766101184.0
 
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.