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

260 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
lover8552645(None) 
clover114617121clover
cover105430771cover
glover104513531glover
hover115524131hover
laver85031791laver
lever85125161lever
liver85132961liver
loner55431031loner
loper75129231loper
loser54728671loser
louver94110391louver
love75234761love_
loved95021361loved
lovers94223431lovers
loves85332011loves
lower85830411lower
mover104220861mover
over77227341_over
plover115312611plover
rover85527371rover
aiver85725162aiver
allover1038582allover
aver75931882_aver
blower115316572blower
boner75133082boner
borer75131272borer
bower107328182bower
boxer145016522boxer
caver105629062caver
claver113816972claver
clever114611532clever
cloner84418092cloner
closer84918202closer
clove105619442clove_
cloven114211512cloven
clovers125114662clovers
clovery15407402clovery
cloves114918822cloves
coder86134212coder
comer95832692comer
cooer74831012cooer
coper95336092coper
corer75538872corer
cove95837072cove_
coved115027372coved
coven106925042coven
covers114627962covers
covert114925502covert
coves105539172coves
covet105638942covet
covey136121782covey
cower104531772cower
coyer105222842coyer
diver94827802diver
doer57734702do_er
doper86128392doper
doser66228562doser
doter65428622doter
dove85131562dove_
doven94718552doven
doves94728152doves
dower95027702dower
dozer158419272dozer
drover104614592drover
eloper85414152eloper
elver85216242elver
ever77027692_ever
fever115617952fever
fiver116024942fiver
flower124815502flower
flyover1633512flyover
fovea11310482fovea
foyer116416552foyer
giver94921202giver
glove94516292glove_
gloved114811872gloved
glovers114310882glovers
gloves104115182gloves
glower105114932glower
goer56827102go_er
gofer94814282gofer
gomer85220652gomer
goner66025152goner
govern1036822govern
haver115124462haver
hoer76533982ho_er
homer105828452homer
honer85332092honer
hoover124314432hoover
hoper105829142hoper
hoser811529762hoser
hove107132222hove_
hovel115017682hovel
hovers124320252hovers
jiver155119052jiver
joker165715892joker
lacer75833752lacer
lader65633722lader
lager65132862lager
laker95432872laker
lamer75233702lamer
laser54633322laser
later54843922later
lave75642142lave_
laved95028592laved
laveer94110422laveer
lavers94526362lavers
laves86039152laves
laxer125420332laxer
layer84626472layer
layover1334432layover
leaver94321512leaver
leer46239352l_eer
leger65721502leger
leper74820742leper
levee84023812levee
level84116552level
levers94621322levers
levier94013872levier
liber74723612liber
lier45942462l_ier
liever94611862liever
lifer85822152lifer
liger65024462liger
liker95627062liker
liner55938912liner
liter54736342liter
live76540992live_
lived95523722lived
liven85021732liven
livers94927822livers
livery124910892livery
lives86133192lives
livier97514592livier
livre85613252livre
livyer12426292livyer
loader74316302loader
loafer93610942loafer
loaner64416502loaner
loaves94813852loaves
lobar7313012lobar
lobber104016592lobber
lobe65535362lobe_
lobed86022132lobed
lobes75331002lobes
locker124019422locker
lode56240112lode_
loden66621142loden
lodes66436912lodes
lodger86517682lodger
lofter94614722lofter
loge56837192loge_
loges66534202loges
logger86420002logger
logier75015732logier
loiter64619172loiter
loller63315282loller
lone45849132lone_
loners64225802loners
longer75823192longer
looed64626132looed
looey84822912looey
looker104816952looker
looper83817112looper
looser65219942looser
looter64222322looter
lope65941922lope_
loped85128332loped
lopers84424142lopers
lopes76437342lopes
lopper103717202lopper
lore45850352lore_
lores55045402lores
lose45144582lose_
losel54419422losel
losers65123582losers
loses56742012loses
lotter64025602lotter
louder74414602louder
lour45430682lo_ur
louvers10359102louvers
louvre9425682louvre
lovat8321042lovat
lovely12339712lovely
loverly1346962loverly
lowe75435312lowe_
lowed95233902lowed
lowers94624922lowers
lowery124112702lowery
lowes85732462lowes
loxed135017052loxed
loxes125227472loxes
luger65322082luger
lurer54625312lurer
moper94925922moper
move96630722move_
moved114218152moved
movers115117192movers
moves106128422moves
mower104523452mower
never86218642never
noter55025642noter
novel85615992novel
older65121172older
omer67028392_omer
oven76624142_oven
overs85224792_overs
overt85630722_overt
oyer75927652_oyer
paver104225832paver
plovers123611832plovers
plower114315062plower
poker115122882poker
poler74431792poler
poser75128772poser
power105325952power
prover113819722prover
raver85631492raver
river85731692river
roger64521412roger
roper75431912roper
rove75136982rove_
roved95323552roved
roven85521972roven
rovers95423522rovers
roves84834482roves
rower85430492rower
saver84831252saver
sever85426052sever
shover124515982shover
siver85728612siver
slaver94419612slaver
sliver94116592sliver
sloper84615912sloper
sloven9389632sloven
slower94016152slower
sober74822402sober
soever94412092soever
solver94016702solver
sorer56236572sorer
sower85229312sower
stover94115642stover
toker95924912toker
toner55336242toner
toper75231022toper
toter55932132toter
tower85729202tower
toyer84521552toyer
trover95014662trover
vomer105517382vomer
voter85121052voter
vower115220792vower
waver115025702waver
wiver115924512wiver
wolver12419712wolver
wooer84316692wooer
wove105624312wove_
woven115215172woven
zoner144520342zoner

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 Limit538002601.84329191.5
3Display Results2602600.0803250.0
 (SQL Overall)1786912602.01688636.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.