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

410 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
optics10281018(None) 
optic93715181optic_
antics84621452antics
attics84413282attics
epics95014282ep_ics
ontic74418572ontic_
ootids71110352ootids
opsins8411712opsins
optical1149862optical
opticist1248922opticist
optima10106532optima
optime1079352optime
optimes1148472optimes
opting94514402opting
option83612712option
options93810602options
opts68124742opt__s
osmics1036462osmics
otic66624822o_tic_
peptics132610242peptics
pics85633912_p_ics
poetics11312072poetics
septics112810432septics
spics94123242sp_ics
tics65729632__tics
topics104714582top_ics
uptick1436762uptick
upticks1535152upticks
actins86321103actins
antic75728863antic_
antick124814583antick
anticks134612253anticks
antis55033313anti_s
aortic8316613aortic_
aphids125110843aphids
aphis105917133aphi_s
apices104916263ap_ices
apsis75718293apsi_s
arctics1138953arctics
asdics9439863asdics
aspics104211563aspics
attic75618353attic_
basics104915123basics
batiks1239373batiks
biopics13318543biop_ics
bioptic1337563bioptic_
biotics113812173biotics
booties94124613booties
bustics11810883bustics
chics123920943_chics
cities84524853cities
civics13397823civics
clitics11279973clitics
coatis85122603coati_s
colics104219903colics
comics124015563comics
conics103920593conics
cooties93725733cooties
copies104130303cop_ies
coppice1537483coppice
coppices1638243coppices
copters113621283copters
cortices12615013cortices
cortins92421333cortins
cretics112911653cretics
critics112811093critics
cubics123810163cubics
cuties84927363cuties
cutins83919983cutins
cutis77723763cuti_s
cynics13377363cynics
darics94314113darics
detick1339383detick
deticks1437353deticks
dioptrics1444093dioptrics
duties74921903duties
emetics11610723emetics
empties11712243empties
emptins1179403emptins
entice81316863entice
entices91616333entices
epic86921303ep_ic_
erotics91914153erotics
ethics11169283ethics
etic66123953_etic_
exotics16229193exotics
fetich1479693fetich
flics105418363_flics
footies103721543footies
forties104323863forties
fortis95418613forti_s
fustics1279593fustics
glyptics1643103glyptics
gnostics1146323gnostics
gothics1336123gothics
haptic13511893haptic_
hepatics15198933hepatics
hogties112813993hogties
hotties103016963hotties
ictic9311803ictic_
intis55121643inti_s
ionics84214483ionics
koppies153210013koppies
laics76419253_laics
latices9313763latices
leptins92412693leptins
logics95711123logics
lopstick1654183lopstick
lopsticks1783603lopsticks
lotic76420673lotic_
luetics937323luetics
lyrics11357943lyrics
lytic104513033lytic_
magics115311613magics
manics103919933manics
mastics112614783mastics
matins84527783matins
medics114115353medics
metis75025903meti_s
metrics11312363metrics
mics87435153__mics
mimics1289363mimics
miotics112710653miotics
mitis75425993miti_s
mortice11711493mortice
mortices12711563mortices
mosaics1138073mosaics
motifs1139673motifs
musics103911783musics
myotics14257603myotics
mystics14279103mystics
noetic8514043noetic_
nostocs947553nostocs
notice8313443notice
notices9312283notices
oasis56422553oasi_s
oaters65029793oaters
oaths86117313oat_hs
oats46554213oat__s
obias76116863o_bias
obis66226843o_bi_s
obits74617553o_bits
obtains939163obtains
obtect10129633obtect
octads987333octads
octans81411143octans
octets839403octets
octyls11135323octyls
odic74920573o_dic_
office1435693office
offices1536243offices
ohias84415573o_hias
ohmic1237833ohmic_
oils46337973o__ils
oldies7314423oldies
oleic7313333oleic_
oleins6313523oleins
olios54520853o_lios
omits75018263o_mits
oomiacs1135683oomiacs
ootid61416703ooti_d
oots46446443oot__s
opahs105411983op_ahs
opals75718353op_als
opens76118553op_ens
operas8312453operas
operatics1346953operatics
opes65942613op__es
ophite11410563ophite
ophites12310103ophites
ophitic1439213ophitic_
opine77422463op_ine
opines84820703opines
oping86322413op_ing
opioids1036523opioids
opium92812093op_ium
opiums10307073opiums
ops56641253op___s
opsin7613473opsi_n
opt57545543opt___
opted84914273opt_ed
optician1247243optician
opticians1345543opticians
opticists1346423opticists
optimal1145783optimal
optimise1255583optimise
optimism1445213optimism
optimist1256873optimist
optimum1343353optimum
optimums1442563optimums
opuntias10103233opuntias
opus66420593op__us
opuses84012243opuses
orbits84211443orbits
orcins83313433orcins
orcs67025433o__rcs
orgic8311823orgic_
orgies72316093orgies
ornis54616773orni_s
orphic1368323orphic_
orpins83614163orpins
orrice81410163orrice
orrices9129363orrices
orris54516553orri_s
orts46538333ort__s
osmic939913osmic_
ostia52315583osti_a
ostium8310133ostium
ostrich1238663ostrich
otiose639403o_tiose
otitic83112683otitic_
otitis63612343o_titis
ottars64112223ottars
otters64021513otters
ottos54714323o_ttos
outact8317203outact
outacts9310213outacts
outbids1098913outbids
outers64230173outers
outfits102210833outfits
outgas7313203outgas
outhits102213503outhits
outing74128153outing
outings84014753outings
outkick1235573outkick
outkicks1344603outkicks
outkiss1137783outkiss
outlies72421993outlies
outrigs82811263outrigs
outs45746963out__s
outsins73417863outsins
outsits73215253outsits
outvies102214243outvies
outwits103110863outwits
ovoids10456923ovoids
ovonics12245553ovonics
oxids13128963o_xids
oxims14107643o_xims
oxlips1544433oxlips
oxtails1436383oxtails
oxters134813273oxters
pacs85842183_p_acs
paiks114719853_paiks
pails75833063_pails
pains75138283_pains
pairs75325833_pairs
panics103815363panics
patins87528783patins
patios85221783patios
pecs84634103_p_ecs
peins76128063_peins
peptic122113153peptic_
peptids12239323peptids
phis95724903_phi_s
photics142810483photics
pias66542553_p_ias
pic76046823_p_ic_
pica85831493_p_ica
picas94626523_p_icas
pice84641093_p_ice
pick125933813_p_ick
picks135226143_p_icks
pies66949603_p_ies
pigs76634223_p_igs
pins65558453_p_ins
pips85837133_p_ips
pis56362033_p_i_s
piss65033333_p_iss
pitas77427673_pitas
pitch125018413_pitch
piths105817543_piths
pities83828083pities
pits66348743_p_its
plica9613373_plica
plies74526513_plies
poetic10416843poetic_
pogies94123543pogies
pois66539043_poi_s
pokies125921333pokies
police102918563police
polices113118053polices
policy133211513policy
polies84034583polies
polios84019723polios
polis74731163poli_s
politics122513813politics
ponies84833463ponies
pontils9312213pontils
poplins11313153poplins
poppies102816193poppies
popsies112816463popsies
portico11310143portico
porticos1238373porticos
posies84431433posies
posits85718713posits
posties93128813posties
postins93721203postins
pothos114214693pothos
potiche1438043potiche
potiches1539203potiches
potion84519573potion
potions93417423potions
potpies113116173potpies
pots66452363pot__s
potsies93019483potsies
potties93723543potties
pottos84615873pottos
price93725413_price
prices104524543_prices
prick134317503_prick
pricks144414263_pricks
pricy124814563_pricy
pries74339533_pries
prigs85219703_prigs
prims95425933_prims
priss74623893_priss
psis68120343_psi_s
pyic116915823_pyic_
pyins105815863_pyins
ratios64922673ratios
relics84517903relics
reties65436193reties
robotics1245483robotics
rotis56327063roti_s
rustics9810733rustics
rutins63818393rutins
satins64930483satins
satis55633683sati_s
sceptics1455663sceptics
septic102713193septic_
shtick15308023shtick
shticks16356963shticks
shtiks13297833shtiks
sics65234093__sics
skeptics1653863skeptics
softies103414613softies
sonics84315633sonics
sophies12314613sophies
sopites93817173sopites
sorties74126403sorties
spails84817823spails
spaits85017473spaits
spastics1237503spastics
specs96916673sp_ecs
speils84116223speils
speirs85013233speirs
speiss84311643speiss
spic85227433sp_ic_
spica94717943sp_ica
spicas104715823sp_icas
spice95528813sp_ice
spices104326033sp_ices
spick134519073sp_ick
spicks144814993sp_icks
spicy125417713sp_icy
spies76037623sp_ies
spiks114117473sp_iks
spins75327983sp_ins
spites84127333spites
spits74429553sp_its
spivs105114243sp_ivs
splice104915103splice
splices113914383splices
splits85416413splits
spoils84614533spoils
sprigs94814773sprigs
sprits85122533sprits
statics93314533statics
stich104117923_stich
stichs114511653_stichs
stick115121563_stick
sticks125118613_sticks
sties55132983_sties
stirs55921623_stirs
stoics8311113stoics
styptics1543813styptics
tactics1149323tactics
tic56343463__tic_
tick106231223__tick
ticks115823293__ticks
ties45248313__ties
tils45739613__tils
tins45251303__tins
tips66436763__tips
tis37056643__ti_s
titis56023813titi_s
tits46145043__tits
tomtits937243tomtits
tonetics1048943tonetics
tonics83617863tonics
topic95721503top_ic_
topis76025833top_i_s
topkick1443143topkick
topkicks1542633topkicks
torics85118353torics
toxics153910203toxics
tropics113610653trop_ics
tunics83811263tunics
unties64326923unties
upstirs935293upstirs
uptilt8410803uptilt
uptilts934733uptilts
uptime1067673uptime
uptimes1177553uptimes
uptoss836093uptoss
vatic10316423vatic_
vitrics12198553vitrics
vortices1369123vortices
yetis85418393yeti_s
zitis145815583ziti_s

Search took 8 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.1401276364.3
2DLD Change Limit1127164107.31315413.1
3Display Results4104100.1233333.3
 (SQL Overall)1786914107.57623586.5
 
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.