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

267 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
oca5673173(None) 
coca88030641coca
loca65527681loca
oba57531551oba
ocas66729631ocas
oda48133041oda
oka76926801oka
ora37250831ora
orca65522771orca
ova66823791ova
soca66330051soca
aa219179952_aa
aba512850952aba
ace59656832ace
act59557842act
acta69524802acta
aga410447232aga
aha611246642aha
ala312463602ala
ama510853302ama
ana39559832ana
ava610139322ava
awa611939672awa
ba49962342_ba
baa510650422baa
boa56954032boa
bock126032512bock
bola66035562bola
bora66141632bora
bota66236502bota
bra56339462bra
cab78355402_cab
caca85528082caca
cad67456362_cad
cam78058982_cam
can57760142_can
cap76758982_cap
car59165562_car
cat58282342_cat
caw86647932_caw
cay87155982_cay
ceca84820782ceca
coal66939252coal
coat67558352coat
coax136922982coax
cob710258752cob
cocas95926572cocas
cock126332902cock
coco87330602coco
cocoa98517882cocoa
cod69660122cod
coda77029342coda
cog69552902cog
col59360352col
cola66541392cola
coma87134852coma
con510268022con
coo59566362coo
cop711162372cop
cor59960942cor
cos510270392cos
cot510483222cot
cow89856712cow
cox1210346782cox
coxa136922962coxa
coy810557552coy
coz149345362coz
doc66841512doc_
dock116228742dock
docs75631152docs
dona55529632dona
dopa77220902dopa
ecu56828232ecu
era35741502era
eta35834192eta
fa510148452_fa
focal104917672focal
foci94521012foci
fora75937392fora
goa47343802goa
ha510259942_ha
hock136031302hock
hora76136562hora
hoya107418372hoya
ice56737242ice
ich86227742ich
ick97329322ick
icy86322122icy
iota45127832iota
jock176522642jock
jota116423622jota
ka69145082_ka
kea76540912kea
koa76737772koa
kola85124962kola
kora86431552kora
la219261632_la
lac510155822lac
lea37660182lea
local74820272local
loch95527132loch
loci66126282loci
lock106134362lock
loco67030742loco
lota47233502lota
ma410060662_ma
mac78053932mac
mica86428252mica
moa57249182moa
moc77845082moc_
mocha1249922mocha
mock126429442mock
mocs85834902mocs
mola66035632mola
mora66641272mora
moxa136917742moxa
na28652482_na
nock106127182nock
noma67529462noma
nona46929062nona
nota46830772nota
nova76518952nova
oaf65952882oaf
oak76238652oak
oar37057952oar
oat39888262oat
obas65730932obas
obe56638642obe
obi57127732obi
obia67923112obia
ocean71212962ocean
ocrea73311822ocrea
octad81510652octad
octal71214722octal
octan71313482octan
od39255242o_d
odah87018932odah
odas57230262odas
odd57725452odd
ode47446582ode
odea56224572odea
ods47546212ods
oe28473062o_e
oes35866192oes
of58247772o_f
ofay106416102ofay
off96331632off
oft67744062oft
ogam75120032ogam
oh57447002o_h
ohia75719362ohia
ohm86523012ohm
oho66534382oho
ohs66232312ohs
oi29061482o_i
oil37452052oil
okas85225392okas
okay115917662okay
oke75839482oke
okra86413572okra
old47033462old
ole37155212ole
olea46532722olea
olla44821172olla
om48553002o_m
oms56337512oms
on28057182o_n
once65423082once
one37050912one
ono36838032ono
ons36148512ons
ooh67637092ooh
oot311274692oot
op45850162o_p
opah96218402opah
opal66923522opal
ope56845242ope
ops56641252ops
opt57545542opt
or27354732o_r
orad56031692orad
oral47638122oral
orb55736862orb
orc57034922orc
orcas75918622orcas
orcs67025432orcs
ore36661832ore
orra46120722orra
ors35750112ors
ort39465232ort
os211359882o_s
osar46820952osar
ose38147342ose
ossa43714162ossa
ouch95724632ouch
oud47439072oud
our36042892our
out38072152out
oval77119522oval
ow58950172o_w
owe67041032owe
owl66228972owl
own66429702own
ox98242382o_x
oxo107322962oxo
oxy136320982oxy
oy58950132o_y
pa410456482_pa
pac79054082pac
paca85132242paca
pea56657242pea
pia56848032pia
pica85831492pica
pock126129292pock
poco86826152poco
pya87023752pya
qua124821972qua
ria36745502ria
roc520243252roc_
rock105735182rock
rocs65533662rocs
rota45834342rota
rya67622012rya
sac57452862sac
scab85926712scab
scad75725772scad
scag76626892scag
scam85932352scam
scan65530452scan
scar66434202scar
scat65848372scat
sea36161292sea
sha69837782sha
ska76925862ska
soba64927922soba
socas74026182socas
sock105233212sock
soda56329382soda
sofa75625602sofa
soja115619512soja
sola45541862sola
soma65635292soma
sora45746912sora
soya75724432soya
spa55730812spa
ta211662452_ta
tea37353322tea
toea46732332toea
toga57027412toga
tola45236332tola
tora47545992tora
twa67721642twa
uta37425582uta
vac86537142vac
via65636242via
vocab12409972vocab
vocal104715642vocal
wha96422072wha
ya510251502_ya
yea66445752yea
yock135924612yock
yoga87418052yoga
yuca95716722yuca
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.0632836365.1
2DLD Change Limit140842670.42033533.3
3Display Results2672670.0634238.1
 (SQL Overall)1786912670.546327272.9
 
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.