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

258 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
over7722734(None) 
aver75931881aver
cover105430771cover
ever77027691ever
hover115524131hover
lover85526451lover
mover104220861mover
omer67028391omer
oven76624141oven
overs85224791overs
overt85630721overt
oyer75927651oyer
rover85527371rover
ager55935842ager
aiver85725162aiver
aper66336232aper
ave67748702ave_
avers85127312avers
avert86029492avert
aves76142602aves
beer65635992beer
bier65531822bier
boner75133082boner
borer75131272borer
bower107328182bower
boxer145016522boxer
caver105629062caver
clover114617122clover
coder86134212coder
comer95832692comer
cooer74831012cooer
coper95336092coper
corer75538872corer
cove95837072cove_
coved115027372coved
coven106925042coven
covers114627962covers
covert114925502covert
coves105539172coves
covet105638942covet
covey136121782covey
cower104531772cower
coyer105222842coyer
deer56739022deer
diver94827802diver
doer57734702doer
doper86128392doper
doser66228562doser
doter65428622doter
dove85131562dove_
doven94718552doven
doves94728152doves
dower95027702dower
dozer158419272dozer
drover104614592drover
dyer85522112dyer
eger55923562eger
elver85216242elver
er28345142__er
eve66331162eve_
even75222272even
evert84929512evert
every115215452every
eves76230462eves
ewer77523982ewer
eyer76127282eyer
fer66646122_fer
fever115617952fever
fiver116024942fiver
fovea11310482fovea
foyer116416552foyer
giver94921202giver
glover104513532glover
goer56827102goer
gofer94814282gofer
gomer85220652gomer
goner66025152goner
govern1036822govern
haver115124462haver
her66547812_her
hoer76533982hoer
homer105828452homer
honer85332092honer
hoover124314432hoover
hoper105829142hoper
hoser811529762hoser
hove107132222hove_
hovel115017682hovel
hovers124320252hovers
jeer115426462jeer
jiver155119052jiver
joker165715892joker
kier86526802kier
laver85031792laver
leer46239352leer
lever85125162lever
lier45942462lier
liver85132962liver
loner55431032loner
loper75129232loper
loser54728672loser
louver94110392louver
love75234762love_
loved95021362loved
lovers94223432lovers
loves85332012loves
lower85830412lower
moper94925922moper
move96630722move_
moved114218152moved
movers115117192movers
moves106128422moves
mower104523452mower
never86218642never
noter55025642noter
novel85615992novel
oar37057952o_ar
oater55433732oater
oaves84925612oaves
obe56638642obe_
obes66036832obes
obey96521302obey
obvert11412992obvert
ocher104516102ocher
ocker113915752ocker
odder74515392odder
ode47446582ode_
odea56224572odea
odes57243242odes
odor55718092odor
oe28473062o_e_
oes35866192o_es
offer114311382offer
ofter84116872ofter
ogee57629882ogee
ogler65917442ogler
ogre56320742ogre
ohed87825182ohed
oiler54628282oiler
oke75839482oke_
okeh114615322okeh
okes84936342okes
older65121172older
ole37155212ole_
olea46532722olea
oleo46630482oleo
oles46453472oles
omber95316432omber
omen66828182omen
omers76923192omers
one37050912one_
onery8414112onery
ones46146532ones
ope56845242ope_
oped76230152oped
open66427002open
opera7313572opera
opes65942612opes
or27354732o__r
order65019362order
ore36661832ore_
ores46056682ores
ormer75218372ormer
osar46820952osar
ose38147342ose_
oses46641512oses
osier53518012osier
other84219102other
otter54423972otter
our36042892o_ur
outer55633302outer
ova66823792ov_a
oval77119522oval
ovary1149112ovary
ovens86217452ovens
overdo10128362overdo
overed102216622overed
overly122411362overly
ovum92310172ovum
owe67041032owe_
owed86833872owed
owes75137102owes
owner84613312owner
oxen116218592oxen
oxes116530722oxes
oxter123414092oxter
oyers87620882oyers
oyes74940132oyes
oyez166020352oyez
paver104225832paver
peer66238352peer
per56353092_per
pier66035292pier
plover115312612plover
poker115122882poker
poler74431792poler
poser75128772poser
power105325952power
prover113819722prover
raver85631492raver
river85731692river
roger64521412roger
roper75431912roper
rove75136982rove_
roved95323552roved
roven85521972roven
rovers95423522rovers
roves84834482roves
rower85430492rower
ruer46127562ruer
saver84831252saver
seer45547042seer
ser36752402_ser
sever85426052sever
shover124515982shover
siver85728612siver
sober74822402sober
soever94412092soever
solver94016702solver
sorer56236572sorer
sower85229312sower
stover94115642stover
suer45334032suer
tier44936142tier
toker95924912toker
toner55336242toner
toper75231022toper
toter55932132toter
tower85729202tower
toyer84521552toyer
trover95014662trover
tyer75323392tyer
user45023002user
uvea74712652uvea
var66148332_var
vee65750182_vee
veer76229572veer
veg76931062_veg
vera76828842_vera
verb96224872_verb
vert77249372_vert
very108025642_very
vet65958522_vet
vex136429172_vex
vier75428152vier
voe67739052voe_
voes75432822voes
vomer105517382vomer
voter85121052voter
vower115220792vower
waver115025702waver
weer75535092weer
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 Filter178691298720.0802233637.5
2DLD Change Limit298722581.06028181.1
3Display Results2582580.0634095.2
 (SQL Overall)1786912581.203148537.8
 
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.