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
oda4813304(None) 
coda77029341coda
oba57531551oba
oca56731731oca
od39255241od_
odah87018931odah
odas57230261odas
odd57725451odd
ode47446581ode
odea56224571odea
ods47546211ods
oka76926801oka
ora37250831ora
ova66823791ova
soda56329381soda
aa219179952_aa
aba512850952aba
ad311975032ad_
add510132362add
ado49146872ado
ads49755732ads
adz1312332862adz
aga410447232aga
aha611246642aha
ala312463602ala
ama510853302ama
ana39559822ana
ava610139322ava
awa611939672awa
ba49962342_ba
baa510650422baa
bad67763152bad
boa56954032boa
bod67055542bod_
bode75838752bode
bods76244712bods
body107425672body
bola66035562bola
bora66141632bora
bota66236502bota
bra56339462bra
cad67456362cad
coca88030642coca
cod69660122cod_
codas84724242codas
code77347732code
cods76848102cods
cola66541392cola
coma87134852coma
coxa136922962coxa
dab67455562_dab
dad58456162_dad
dada66422442dada
dag57753002_dag
dah78148982_dah
dak86340692_dak
dal47554952_dal
dam67457042_dam
dan46859662_dan
dap66652452_dap
daw77148362_daw
day76254112_day
de37049542_de
do310155252_do
doat56947672doat
doc66841512doc
dodo66024912dodo
doe47361952doe
dog57449752dog
dol47150652dol
dom69752442dom
don46757652don
dona55529632dona
dopa77220902dopa
dor47253922dor
dos48062312dos
dot47573182dot
dow76749972dow
ed38645182ed_
edh76921562edh
eds46638922eds
era35741502era
eta35834192eta
fa510148452_fa
fad77452412fad
fora75937392fora
gad57556652gad
goa47343802goa
goad66830982goad
god57449792god_
gods65438042gods
ha510259942_ha
had77658762had
hod76852462hod_
hodad10311352hodad
hods87239862hods
honda9414982honda
hora76136552hora
hoya107418372hoya
id38941832id_
idea59122772idea
ids47535462ids
iota45127832iota
jota116423622jota
ka69145082_ka
kea76540912kea
koa76737772koa
kola85124962kola
kora86431552kora
la219261632_la
lad48165702lad
lea37660182lea
load56730602load
loca65527682loca
lode56240112lode
lota47233502lota
ma410060652_ma
mad68958702mad
moa57249182moa
mod69054402mod_
modal85919232modal
mode75840302mode
modi76826312modi
mods77945052mods
mola66035632mola
mora66641272mora
moxa136917742moxa
na28652482_na
nada58022902nada
nod47549562nod_
nodal64717792nodal
node513036882node
nodi56626742nodi
nods55838222nods
noma67529462noma
nona46929062nona
nota46830772nota
nova76518952nova
oaf65952882oaf
oak76238652oak
oar37057952oar
oat39888262oat
obas65730932obas
obe56638642obe
obi57127722obi
obia67923102obia
ocas66729632ocas
odahs95610082odahs
odds68919922odds
odes57243242odes
odic74920572odic
odor55718092odor
odyl84111462odyl
oe28473062o_e
oes35866192oes
of58247772o_f
ofay106416102ofay
off96331632off
oft67744062oft
ogam75120032ogam
oh57447002o_h
ohia75719362ohia
ohm86523012ohm
oho66534382oho
ohs66232312ohs
oi29061482o_i
oidia6314952oidia
oil37452052oil
okas85225392okas
okay115917662okay
oke75839482oke
okra86413572okra
old47033462old
olds55926572olds
oldy85316842oldy
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
ordo54622352ordo
ore36661832ore
orra46120722orra
ors35750112ors
ort39465232ort
os211359882o_s
osar46820952osar
ose38147342ose
ossa43714162ossa
oud47439072oud
ouds56430102ouds
our36042892our
out38072152out
oval77119522oval
ow58950172o_w
owe67041032owe
owl66228972owl
own66429702own
ox98242382o_x
oxo107322962oxo
oxy136320982oxy
oy58950132o_y
pa410456482_pa
pad68057322pad
pea56657242pea
pia56848032pia
pod66351482pod_
podia8415282podia
pods76540152pods
pya87023752pya
qua124821972qua
rad47662002rad
ria36745502ria
road56332112road
rod47953892rod_
rode55844302rode
rods56442062rods
rota45834342rota
rya67622012rya
sad47459202sad
sea36161292sea
sha69837782sha
ska76925862ska
soba64927922soba
soca66330052soca
sod46053702sod_
sodas64123542sodas
sods54940212sods
sofa75625602sofa
soja115619512soja
sola45541862sola
soma65635292soma
sora45746912sora
soya75724432soya
spa55730812spa
ta211662452_ta
tad47959822tad
tea37353322tea
toad55830182toad
tod49457072tod_
today96416952today
tods56141842tods
tody86327212tody
toea46732332toea
toga57027412toga
tola45236332tola
tora47545992tora
twa67721642twa
udo49027302udo
uta37425582uta
via65636242via
vodka1354342vodka
wad77053892wad
wha96422072wha
woad85523942woad
ya510251502_ya
yea66445752yea
yod77545502yod_
yodh119916102yodh
yods86531182yods
yoga87418052yoga
za1114939202_za
zoa128529992zoa
zoea137118422zoea
zona136321962zona

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 Filter178691140840.0463884587.0
2DLD Change Limit140842830.45331090.5
3Display Results2832830.0466152.2
 (SQL Overall)1786912830.545327873.4
 
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.