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

155 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
opal6692352(None) 
copal95621781copal
nopal75517101nopal
opah96218401opah
opals75718351opals
oral47638121oral
oval77119521oval
pal56761671_pal
aal39058672_aal
al210674042__al
anal48037522anal
appal95315222appal
axal116520492axal
baal67033112baal
bal56662722_bal
boral75831702boral
coal66939252coal
comal95125132comal
copalm125010812copalm
copals105018942copals
copay126516312copay
coral76033452coral
coxal146116672coxal
dal47554952_dal
deal56347412deal
dhal86719282dhal
dial55935062dial
domal85619202domal
dopa77220902dopa_
dopas85019062dopas
dotal64919622dotal
dual55928172dual
egal55119432egal
feal713940422feal
foal76630922foal
focal104917672focal
gal46055512_gal
goal55829302goal
goral65125752goral
heal75645692heal
horal86328682horal
joual12311652joual
leal46043272leal
local74820272local
loral55927822loral
loyal84513482loyal
meal65643172meal
modal85919242modal
molal75120342molal
moral75533432moral
nodal64717792nodal
nopals84914022nopals
notal55221352notal
oaf65952882o_af
oak76238652o_ak
oar37057952o_ar
oat39888262o_at
oba57531552oba_
obas65730932obas
obol65220612obol
oca56731732oca_
ocas66729632ocas
octal71214722octal
oda48133042oda_
odah87018932odah
odas57230262odas
odyl84111462odyl
ofay106416102ofay
offal1136242offal
ogam75120032ogam
oil37452052o_il
oka76926802oka_
okas85225392okas
okay115917662okay
olla44821172olla
op45850162op__
opahs105411982opahs
ope56845242op_e
oped76230152oped
open66427002open
opes65942612opes
ops56641252op_s
opt57545542op_t
opts68124742opts
opus66420592opus
ora37250832ora_
orad56031692orad
orals55826482orals
osar46820952osar
ova66823792ova_
ovals85413392ovals
owl66228972o_wl
pa410456482_pa_
pac79054082_pac
pad68057322_pad
pah88853592_pah
pail66141832_pail
pale66055012_pale
pall65039342_pall
palm85331362_palm
palp85828572_palp
pals66951352_pals
paly95835532_paly
pam77858392_pam
pan58466452_pan
pap76758402_pap
papal95820672papal
par57467022_par
pas58775742_pas
pat58089462_pat
paw87651172_paw
pawl95123262_pawl
pax127346852_pax
pay88461182_pay
peal68648102peal
pial65636702pial
pipal95118352pipal
pol56449382_pol
poll66332132poll
pool65835952pool
pul56138062_pul
pupal97616872pupal
real45750292real
rial45938092rial
royal85014702royal
sal36462882_sal
seal45654372seal
sepal77723002sepal
sial45938832sial
spa55730812spa_
spae65034322spae
spail74921552spail
spale74929212spale
spall74919302spall
spam85930042spam
span65234662span
spar65433302spar
spas67036722spas
spat66548522spat
spay96631662spay
spaz155626162spaz
teal45546502teal
tepal76319582tepal
tonal53724302tonal
topaz16315322topaz
total55321822total
typal105311152typal
upas68322382upas
veal76936812veal
vial76731092vial
vocal104715642vocal
weal75838682weal
zeal135530332zeal
zoeal144813782zoeal
zonal145116852zonal

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.266671770.7
2DLD Change Limit298721550.89033564.0
3Display Results1551550.0463369.6
 (SQL Overall)1786911551.202148661.4
 
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.