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

234 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
hover11552413(None) 
cover105430771cover
haver115124461haver
hoer76533981ho_er
homer105828451homer
honer85332091honer
hoover124314431hoover
hoper105829141hoper
hoser811529761hoser
hove107132221hove_
hovel115017681hovel
hovers124320251hovers
lover85526451lover
mover104220861mover
over77227341_over
rover85527371rover
shover124515981shover
aiver85725162aiver
aver75931882_aver
boner75133082boner
borer75131272borer
bower107328182bower
boxer145016522boxer
caver105629062caver
choker154314372choker
choler113717152choler
clover114617122clover
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
elver85216242elver
ever77027692_ever
fever115617952fever
fiver116024942fiver
fovea11310482fovea
foyer116416552foyer
giver94921202giver
glover104513532glover
goer56827102go_er
gofer94814282gofer
gomer85220652gomer
goner66025152goner
govern1036822govern
haler85033522haler
hater85034752hater
have106137072have_
haven114718532haven
havers124721482havers
haves116034872haves
hayer114620242hayer
hazer174820232hazer
heaver124819672heaver
heder95623632heder
her66547812h__er
hewer115719932hewer
hexer155116682hexer
hider95024082hider
hiker125119392hiker
hirer85423122hirer
hive106029672hive_
hived125217912hived
hives116925512hives
hoar76729162ho_ar
hoaxer16348562hoaxer
hobber134114632hobber
hocker155118562hocker
hoe67562722ho_e_
hoed87837982ho_ed
hoers85724922ho_ers
hoes75755732ho_es
hogger114615082hogger
hoke115935932hoke_
hoked135326992hoked
hokes126231642hokes
hokey155422182hokey
hokier134214032hokier
holder104619652holder
hole77553392hole_
holed95634132holed
holes84748652holes
holey115626902holey
holier94921622holier
holler93520612holler
home98042442home_
homed115425422homed
homers114821972homers
homes106938812homes
homey135924842homey
homier116416992homier
hone77549322hone_
honed95332262honed
honers94324972honers
hones88144492hones
honey115629912honey
honker134117462honker
honor85718622honor
hooey114926602hooey
hoofer124014952hoofer
hooker134820172hooker
hooper114518312hooper
hooter94123922hooter
hooved134713122hooved
hoovers134312702hoovers
hooves124815482hooves
hope96639672hope_
hoped115628182hoped
hopers114222972hopers
hopes105835642hopes
hopper134218482hopper
hose76547242hose_
hosed95830982hosed
hosel86024812hosel
hosen85623882hosen
hosers95223952hosers
hoses85443172hoses
hosey116127022hosey
hosier94219612hosier
hotel85520742hotel
hotter94720072hotter
hour75827312ho_ur
houser95322282houser
hovels125413332hovels
hovered143411572hovered
hoverer13319822hoverer
howe106734102howe_
howes114730262howes
however1634512however
howler123514312howler
huger94914872huger
hyper135213902hyper
jiver155119052jiver
joker165715892joker
laver85031792laver
lever85125162lever
liver85132962liver
loner55431032loner
loper75129232loper
loser54728672loser
louver94110392louver
love75234762love_
loved95021362loved
lovers94223432lovers
loves85332012loves
lower85830412lower
moper94925922moper
move96630722move_
moved114218152moved
movers115117192movers
moves106128422moves
mower104523452mower
never86218642never
noter55025642noter
novel85615992novel
omer67028392_omer
oven76624142_oven
overs85224792_overs
overt85630722_overt
oyer75927652_oyer
paver104225832paver
plover115312612plover
poker115122882poker
poler74431792poler
poser75128772poser
power105325952power
prover113819722prover
raver85631492raver
river85731692river
roger64521412roger
roper75431912roper
rove75136982rove_
roved95323552roved
roven85521972roven
rovers95423522rovers
roves84834482roves
rower85430492rower
saver84831252saver
sever85426052sever
shaver123718912shaver
shiver124517372shiver
shoer84722152sho_er
shove114421032shove_
shoved134214272shoved
shovel124611312shovel
shovers134612992shovers
shoves124919412shoves
shower124315102shower
siver85728612siver
sober74822402sober
soever94412092soever
solver94016702solver
sorer56236572sorer
sower85229312sower
stover94115642stover
toker95924912toker
toner55336242toner
toper75231022toper
toter55932132toter
tower85729202tower
toyer84521552toyer
trover95014662trover
vomer105517382vomer
voter85121052voter
vower115220792vower
waver115025702waver
whoever1634102whoever
wiver115924512wiver
wolver12419712wolver
wooer84316692wooer
wove105624312wove_
woven115215172woven
zoner144520342zoner

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 Limit538002341.70331591.3
3Display Results2342340.0633714.3
 (SQL Overall)1786912341.85996122.1
 
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.