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

283 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
oda4813305(None) 
coda77029351coda
oba57531551oba
oca56731731oca
od39255251od_
odah87018931odah
odas57230261odas
odd57725461odd
ode47446591ode
odea56224571odea
ods47546221ods
oka76926801oka
ora37250831ora
ova66823791ova
soda56329391soda
aa219179952_aa
aba512850952aba
ad311975042ad_
add510132372add
ado49146882ado
ads49755742ads
adz1312332872adz
aga410447232aga
aha611246642aha
ala312463602ala
ama510853312ama
ana39559832ana
ava610139322ava
awa611939672awa
ba49962342_ba
baa510650422baa
bad67763162bad
boa56954032boa
bod67055552bod_
bode75838762bode
bods76244722bods
body107425682body
bola66035562bola
bora66141632bora
bota66236502bota
bra56339462bra
cad67456372cad
coca88030642coca
cod69660132cod_
codas84724242codas
code77347742code
cods76848112cods
cola66541392cola
coma87134852coma
coxa136922962coxa
dab67455562_dab
dad58456172_dad
dada66422452dada
dag57753012_dag
dah78148982_dah
dak86340692_dak
dal47554952_dal
dam67457042_dam
dan46859672_dan
dap66652452_dap
daw77148362_daw
day76254112_day
de37049552_de
do310155262_do
doat56947672doat
doc66841512doc
dodo66024922dodo
doe47361952doe
dog57449752dog
dol47150652dol
dom69752442dom
don46757652don
dona55529632dona
dopa77220902dopa
dor47253922dor
dos48062312dos
dot47573182dot
dow76749972dow
ed38645192ed_
edh76921572edh
eds46638932eds
era35741502era
eta35834192eta
fa510148452_fa
fad77452422fad
fora75937392fora
gad57556662gad
goa47343802goa
goad66830982goad
god57449802god_
gods65438052gods
ha510259942_ha
had77658772had
hod76852472hod_
hodad10311352hodad
hods87239872hods
honda9414982honda
hora76136562hora
hoya107418372hoya
id38941852id_
idea59122782idea
ids47535482ids
iota45127832iota
jota116423622jota
ka69145092_ka
kea76540922kea
koa76737782koa
kola85124972kola
kora86431572kora
la219261632_la
lad48165712lad
lea37660182lea
load56730602load
loca65527682loca
lode56240122lode
lota47233502lota
ma410060662_ma
mad68958722mad
moa57249182moa
mod69054412mod_
modal85919242modal
mode75840312mode
modi76826322modi
mods77945062mods
mola66035632mola
mora66641272mora
moxa136917742moxa
na28652482_na
nada58022912nada
nod47549572nod_
nodal64717792nodal
node513036892node
nodi56626752nodi
nods55838232nods
noma67529462noma
nona46929062nona
nota46830772nota
nova76518952nova
oaf65952882oaf
oak76238652oak
oar37057952oar
oat39888262oat
obas65730932obas
obe56638642obe
obi57127732obi
obia67923112obia
ocas66729632ocas
odahs95610082odahs
odds68919932odds
odes57243242odes
odic74920582odic
odor55718092odor
odyl84111462odyl
oe28473062o_e
oes35866192oes
of58247772o_f
ofay106416102ofay
off96331632off
oft67744062oft
ogam75120032ogam
oh57447002o_h
ohia75719362ohia
ohm86523012ohm
oho66534382oho
ohs66232312ohs
oi29061492o_i
oidia6314962oidia
oil37452062oil
okas85225392okas
okay115917662okay
oke75839482oke
okra86413572okra
old47033472old
olds55926582olds
oldy85316852oldy
ole37155212ole
olea46532722olea
olla44821172olla
om48553002o_m
oms56337512oms
on28057182o_n
one37050912one
ono36838032ono
ons36148512ons
ooh67637092ooh
oot311274692oot
op45850162o_p
opah96218402opah
opal66923522opal
ope56845242ope
ops56641252ops
opt57545542opt
or27354732o_r
orad56031692orad
oral47638122oral
orb55736862orb
orc57034922orc
orca65522772orca
ordo54622362ordo
ore36661832ore
orra46120722orra
ors35750112ors
ort39465232ort
os211359882o_s
osar46820952osar
ose38147342ose
ossa43714162ossa
oud47439082oud
ouds56430112ouds
our36042892our
out38072152out
oval77119522oval
ow58950172o_w
owe67041032owe
owl66228972owl
own66429702own
ox98242382o_x
oxo107322962oxo
oxy136320982oxy
oy58950132o_y
pa410456482_pa
pad68057332pad
pea56657242pea
pia56848042pia
pod66351492pod_
podia8415282podia
pods76540162pods
pya87023752pya
qua124821972qua
rad47662012rad
ria36745512ria
road56332112road
rod47953902rod_
rode55844312rode
rods56442072rods
rota45834342rota
rya67622012rya
sad47459212sad
sea36161292sea
sha69837782sha
ska76925862ska
soba64927922soba
soca66330052soca
sod46053712sod_
sodas64123542sodas
sods54940222sods
sofa75625602sofa
soja115619512soja
sola45541862sola
soma65635292soma
sora45746912sora
soya75724432soya
spa55730812spa
ta211662452_ta
tad47959832tad
tea37353322tea
toad55830182toad
tod49457082tod_
today96416952today
tods56141852tods
tody86327222tody
toea46732332toea
toga57027412toga
tola45236332tola
tora47545992tora
twa67721642twa
udo49027312udo
uta37425582uta
via65636252via
vodka1354342vodka
wad77053902wad
wha96422072wha
woad85523942woad
ya510251502_ya
yea66445752yea
yod77545512yod_
yodh119916112yodh
yods86531192yods
yoga87418052yoga
za1114939202_za
zoa128529992zoa
zoea137118422zoea
zona136321962zona

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 Filter178691140840.720248181.9
2DLD Change Limit140842831.21611582.2
3Display Results2832830.1102572.7
 (SQL Overall)1786912832.04687336.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.