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

145 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
optical114986(None) 
optimal1145781optimal
apical10913902ap_ical
cortical12412212cortical
epical10413392ep_ical
haptical1547342haptical
metical11315362metical
optic93715182optic__
optically1649902optically
optician1247242optician
optics102810182optic_s
optima10106532optima_
optional1047642optional
orphical1546732orphical
pical95524372_p_ical
plical10411682_plical
poetical12311532poetical
septical1259362septical
tical76021492__tical
topical1139952top_ical
vatical1239982vatical
vortical1348862vortical
actinal9312293actinal
anticar9312663anticar
apicals1159923ap_icals
apsidal1046703apsidal
apteral9311523apteral
biotical1248863biotical
comical13312223comical
conical11316203conical
cosmical1448013cosmical
cotidal1038463cotidal
critical12310263critical
cryptical1844693cryptical
cubical1338463cubical
cynical1437873cynical
datival1135583datival
domical1239373domical
dropsical1443723dropsical
erotical101911983erotical
estival1036323estival
ethical1238443ethical
fetial95716193feti_al
finical1239703finical
fornical1347793fornical
gestical1138993gestical
gnostical1246203gnostical
hectical1547943hectical
helical12311153helical
iatrical1049273iatrical
intimal9109943intimal
laical8312323_laical
lexical1637363lexical
logical1038513logical
lyrical1236493lyrical
magical1239783magical
matinal9312603matinal
medical12312513medical
meticals12310763meticals
metrical12311593metrical
mimical1339233mimical
musical1139553musical
mystical1546933mystical
mythical1845033mythical
nautical1057703nautical
nodical1049863nodical
nontidal948673nontidal
nuptial946633nupti_al
oatmeal944973oatmeal
ocicat101412813o_cicat
octal71214723oct__al
octaval1243583octaval
oedipal1045173oedipal
official1644893official
ogival1035873o_gival
ontic74418573ontic__
ontically14311843ontically
oothecal1343913oothecal
opal66923523op___al
oppidan1243463oppidan
opticians1345543opticians
opticist1248923opticist
optimally1644563optimally
optime1079353opti_me
optimes1148473optimes
optimum1343353optimum
opting94514403opti_ng
option83612713opti_on
optionals1145343optionals
options93810603options
orbital936923orbital
ordinal838643ordinal
osteal6312963ost_eal
ostia52315583osti_a_
otic66624823o_tic__
outcall9310123out_call
outrival1145323outrival
ovoidal1144023ovoidal
pascal10812373_pascal
phial10313203_phi_al
pial65636713_p_i_al
pibal95217323_p_ibal
pica85831503_p_ica_
picas94626523_p_icas
picul95015363_p_icul
pipal95118353_p_ipal
plica9613373_plica_
plicae10410953_plicae
political1349713political
pollical1247953pollical
potiche1438043potiche
primal104014623_primal
ptisan8417973_ptisan
radical103312793radical
retial64724993reti_al
retinal75318353retinal
rustical1048393rustical
sceptical1545343sceptical
skeptical1743963skeptical
spacial1138763spacial
spatial9310323spati_al
special11310303special
spica94717943sp_ica_
spicae104313703sp_icae
spicas104715823sp_icas
spinal84915313sp_inal
spiral83715343sp_iral
spital83813873sp_ital
statical1039423statical
stoical9310283stoical
styptical1643963styptical
synoptical1754383synoptical
tactical1248843tactical
thetical1349123thetical
ticals83214713__ticals
tidal64516453__tidal
tincal83913373__tincal
toxical1637643toxical
tropical1248733trop_ical
typical1436343typical
uptick1436763uptic_k
upticks1535153upticks
vertical13410433vertical
vesical12159813vesical
viatical1347063viatical

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 Filter1786911340270.423422437.4
2DLD Change Limit1340271456.75019855.9
3Display Results1451450.0602416.7
 (SQL Overall)1786911457.23324705.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.