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

131 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
oval7711952(None) 
opal66923521opal
oral47638121oral
ova66823791ova_
ovals85413391ovals
aal39058672_aal
al210674042__al
anal48037522anal
arval86017012arval
ava610139322ava_
avail8313882avail
axal116520492axal
baal67033112baal
bal56662722_bal
boral75831702boral
coal66939252coal
coeval1138892coeval
comal95125132comal
copal95621782copal
coral76033452coral
coxal146116672coxal
dal47554952_dal
deal56347412deal
dhal86719282dhal
dial55935062dial
domal85619202domal
dotal64919622dotal
dual55928172dual
egal55119432egal
evil75318072evil
feal713940422feal
foal76630922foal
focal104917672focal
foveal1237702foveal
gal46055512_gal
goal55829302goal
goral65125752goral
heal75645692heal
horal86328682horal
hovel115017682hovel
joual12311652joual
jovial1636542jovial
kvas117015942kvas
leal46043272leal
local74820272local
loral55927822loral
lovat8321042lovat
loyal84513482loyal
meal65643172meal
modal85919242modal
molal75120342molal
moral75533432moral
naval85315832naval
nival84915772nival
nodal64717792nodal
nopal75517102nopal
notal55221352notal
nova76518952nova_
novae85913122novae
novas85215362novas
novel85615992novel
oaf65952882o_af
oak76238652o_ak
oar37057952o_ar
oat39888262o_at
oba57531552oba_
obas65730932obas
obol65220612obol
oca56731732oca_
ocas66729632ocas
octal71214722octal
oda48133042oda_
odah87018932odah
odas57230262odas
odyl84111462odyl
ofay106416102ofay
offal1136242offal
ogam75120032ogam
ogival1035872ogival
oil37452052o_il
oka76926802oka_
okas85225392okas
okay115917662okay
olla44821172olla
opah96218402opah
opals75718352opals
ora37250832ora_
orad56031692orad
orals55826482orals
osar46820952osar
ovally12278442ovally
ovary1149112ovary
ovate84214392ovate
oven76624142oven
over77227342over
ovoli8358282ovoli
ovolo8339172ovolo
ovule839492ovule
ovum92310172ovum
owl66228972o_wl
pal56761672_pal
peal68648102peal
pial65636702pial
real45750292real
rial45938092rial
rival85216502rival
royal85014702royal
sal36462882_sal
seal45654372seal
sial45938832sial
teal45546502teal
tonal53724302tonal
total55321822total
uveal84411072uveal
vac86537142_vac
vail75432552_vail
vale74937342_vale
van66246332_van
var66148332_var
vas67755772_vas
vat67863452_vat
vau66840872_vau
vav95829432_vav
vaw95937462_vaw
veal76936812veal
vial76731092vial
vocal104715642vocal
weal75838682weal
zeal135530332zeal
zoeal144813782zoeal
zonal145116852zonal

Search took 1 second 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.0762351197.4
2DLD Change Limit298721310.75039829.3
3Display Results1311310.0304366.7
 (SQL Overall)1786911310.856208751.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.