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 “ocular” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

314 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
ocular861013(None) 
jocular1637301jocular
locular938951locular
oculars948361oculars
oscular937931oscular
ovular946831ovular
alular6311352alular
collar83816172collar
copular113810602copular
cougar958782cougar
facular122810442facular
gular6314832_gular
lobular936662lobular
macular113011942macular
modular1087362modular
morular978222morular
nodular876702nodular
ocellar936532ocellar
ocularly1374642ocularly
oculi72010792ocul_i
oculus8178392oculus
oracular1047532oracular
oscula837292oscula_
ovulary1344912ovulary
popular11319562popular
scalar83612432scalar
secular92211532secular
uvular955562uvular
zonular1656492zonular
acicular12218663acicular
acinar8310483acinar
aculei839793aculei
acuter84412863acuter
alar46340073__alar
alula5317093alula_
alulae6312743alulae
angular838533angular
annular737693annular
anovular1144163anovular
ashlar9338193ashlar
aurar54420253_aurar
avicular13237273avicular
bacula103112683bacula_
bilocular1363683bilocular
binocular1394603binocular
biovular1343603biovular
bolar75123473_bolar
bulbar1039583_bulbar
calcar10312753_calcar
canular9310323canular
car59165563_c__ar
cedar84014323_cedar
cellar84514983cellar
char95132153_c_har
chukar1534633chukar
cigar8911803_cigar
circular1247903circular
clad76225823_c_lad
clag75924573_c_lag
clam86332293_c_lam
clan65633923_c_lan
clap86429043_c_lap
claro75018693_c_laro
clary105719613_c_lary
claw95624343_c_law
clay95927413_c_lay
clear76219053_clear
coala77521123coala_
coalas87418963coalas
coaler84121713coaler
cochlear1543593cochlear
coiler84421593coiler
cola66541393_cola_
colas75436773_colas
collard103712923collard
collars93816573collars
color76123743_color
consular1038813consular
cooler84824713cooler
copula102812043copula_
copulae112810613copulae
copulas113811563copulas
coruler9311713coruler
costar85518613costar
cottar84613813cottar
cougars1038443cougars
could86517713coul_d
coulee8323513coulee
coulis84018763coulis
couloir936153couloir
coulter94115603coulter
coupler114713013coupler
courlan9117763courlan
couter84930223couter
cuber95222533_cuber
culch124512833_culch
culet76040343_culet
culex144613933_culex
cull65929643_cul_l
cullay113910173_cullay
culler84322253_culler
culls75425813_culls
cully105520463_cully
culm85822383_cul_m
culms95314193_culms
culpa93610963_culpa
culpae10389263_culpae
cult66541153_cul_t
culti76317253_culti
cults75022553_cults
culver113010633_culver
cupular11317623cupular
cur56841983_cu__r
curara83712203_curara
curare84916953_curare
curari84414403_curari
curer75030753_curer
curler85221323_curler
curr65429653_cu_rr
cuter74728233_cuter
cutlas8313103_cutlas
cutler84718033_cutler
cymar125711263_cymar
czar156013133_c_zar
dollar74110983dollar
doula65717773doula_
doulas75114993doulas
eclair836813ec_lair
eclat7523603ec_lat
escolar946053escolar
fabular12288693fabular
facula112912233facula_
faculae123210353faculae
fecula113310053fecula_
feculae12339203feculae
feuar8310243feu_ar
fibular12267973fibular
filar84819293_filar
focuser12155783focuser
foulard11257283foulard
fouler93614903fouler
fubar1039923_fubar
fulmar1137253_fulmar
furcular1345703furcular
globular1143383globular
guar56923293_gu_ar
gulag7310823_gulag
hamular1236973hamular
hauler95015123hauler
hilar85418143_hilar
hula74923753_hula_
hulas84920883_hulas
inocula947273inocula_
insular7138703insular
jocularly2173303jocularly
jugular1534513jugular
kulak858823_kulak
lacunar9136293lacunar
lar37967533___lar
ligular8348533ligular
loculate101011403loculate
locule83412033locul_e
loculed10317653loculed
locules92812603locules
loculi8288253locul_i
loculus9296973loculus
lunar57017313_lunar
lunular736013lunular
macula103013673macula_
maculae113412863maculae
maculas113114023maculas
malar76424443_malar
mauler84416713mauler
medlar93010463medlar
modulars1165833modulars
molar75223093_molar
molecular1344013molecular
monocular1345813monocular
morula8710473morula_
morulae958963morulae
morulas959723morulas
muscular1246243muscular
mutular936643mutular
mylar105311533_mylar
nebular956483nebular
nuclear936233nuclear
oar37057953o___ar
oca56731733oc__a_
ocas66729633oc__as
occult1038433occul_t
occulter1244113occulter
occults1135123occults
occur9137323oc_cur
ocean71212963oc_ean
ocelli836843ocelli
ocelot8813383ocelot
ocher104516103oc_her
ocicat101412813ocicat
ocker113915753oc_ker
ocrea73311823ocrea_
ocreae83310273ocreae
octad81510653oc_tad
octal71214723oc_tal
octan71313483oc_tan
ocularist1177323ocularist
oculist9310883oculist
ogler65917443o_gler
oiler54628283o_iler
olla44821173o_lla_
ollas54218283o_llas
onlay84212943o_nlay
opercular1345083opercular
opuscular1343273opuscular
orbicular1344683orbicular
osar46820953o__sar
osculant1046953osculant
osculate101010613osculate
oscule838193oscul_e
oscules938123oscules
osculum1143833osculum
osmolar944483osmolar
ossicular1144083ossicular
ostler63312193ostler
ottar54313993o_ttar
our36042893o_u__r
ourari63413543o_urari
outer55633303o_uter
outlaw9279643outlaw
outlay92711793outlay
outwar91011513outwar
ovulate1039453ovulate
ovule839493ovul_e
ovules938223ovules
pabular11259473pabular
papular11299763papular
peculiar1245453peculiar
pedlar93311273pedlar
phylar14437373phylar
piacular1246573piacular
pilar75221503_pilar
pillar8314023pillar
pilular938203pilular
polar75623453_polar
poplar103611113poplar
poulard10299733poulard
pula65129373_pula_
puler74826623_puler
pulsar8329363_pulsar
radular837833radular
ranular739433ranular
regular838423regular
ruler54923343_ruler
saccular1246893saccular
scalare93311833scalare
scalars93711903scalars
scaler84321603scaler
scapular1245373scapular
scar66434203sc__ar
scholar1236953scholar
scuba94211593scuba_
scubas103710223scubas
sculch13226213sculch
sculk115112463scul_k
sculker13318323sculker
sculks123610263sculks
scull75315763scul_l
sculler99812153sculler
sculls84613883sculls
sculp95314843scul_p
sculps104611753sculps
sculpt104412693sculpt
scuta75815753scuta_
seculars10219393seculars
simular938673simular
solar55927343_solar
solunar735283solunar
soucar839323soucar
specular12217613specular
spicular12238903spicular
sporular1065223sporular
stelar64013863stelar
stylar9358113stylar
sugar6312913_sugar
tabular9279763tabular
talar56225383_talar
tegular836603tegular
titular737523titular
tolar55524113_tolar
torula6610393torula_
torulae758553torulae
torulas759853torulas
tubular9267473tubular
tumular9236543tumular
ulan46527393__ulan
ulnar56013983__ulnar
undular837123undular
ungular836773ungular
uvula845153uvula_
uvulae945323uvulae
uvulars1044413uvulars
uvulas946523uvulas
vacuolar1353483vacuolar
vascular1346293vascular
velar85817633_velar
venular1037683venular
vocabular1652163vocabular
volar86917413_volar
vulgar10426823_vulgar
vulvar12427963_vulvar
yclad11246383yc_lad
yulan8411493_yulan
zonula1537223zonula_
zonulae1645963zonulae
zonulas1637023zonulas

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127163145.44020719.9
3Display Results3143140.1102854.5
 (SQL Overall)1786913145.92330169.0
 
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.