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

213 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
myopic1530846(None) 
myopia13318441myopia
myotic133112311myotic
atopic103514142atopic
biopic123710672biopic
meropic13310262meropic
metopic1339762metopic
miotic103715752miotic
muonic10410182muonic
mycotic1647712mycotic
myoid11512992myo_id
myope124010972myop_e
myopes13419962myopes
myopias14308152myopias
myopies14309722myopies
myopy15457352myop_y
myosin113410762myosin
myosis114012562myosis
myotics14257602myotics
mystic132711642mystic
mythic1637272mythic
topic95721502_topic
tropic103014192tropic
typic124511962ty_pic
yogic116114932_yogic
yonic105920842_yonic
adipic1137263adipic
aeonic83517043aeonic
agonic93515143agonic
amblyopic2051493amblyopic
ammonic1349163ammonic
amylic13108713amy_lic
anodic92813133anodic
anomic102516303anomic
anopia83412393anopia
anoxic152610673anoxic
aspic95114733_aspic
atomic104115603atomic
atonic83420473atonic
atypic13337653atypic
axonic154312723axonic
azoic162912063azo_ic
azonic175513153azonic
azotic172711633azotic
bionic103614573bionic
biopics13318543biopics
biopsic1345523biopsic
bioptic1337563bioptic
biotic103816613biotic
boric98024223_boric
bromic122412693bromic
canopic1338803canopic
chopin132712193chopin
choric133515903choric
clonic104914673clonic
colic95726173_colic
comic114721813_comic
conic95329793_conic
cryonic1437833cryonic
cyanic133110773cyanic
cyclic1238033cyclic
cynic124712423cy_nic
cystic132710653cystic
domic104317243_domic
dyadic1336093dyadic
ectopic1338153ectopic
embolic1347423embolic
enolic8413353enolic
entopic1149953entopic
epic86921303__epic
erotic82620273erotic
exonic153211413exonic
exotic153112653exotic
folic105319323_folic
frolic1149203frolic
geodic1048003geodic
gnomic11248593gnomic
gopik1257533_gopik
hydric15227953hydric
hydropic1947273hydropic
hyenic1438723hyenic
hyoid12612443hyo_id
hypnic1637263hypnic
hypoxic2466283hypoxic
iconic10411593iconic
iodic84816753_iodic
ionic74622663_ionic
ironic8313773ironic
kaonic1238763kaonic
logic88217833_logic
lotic76420673_lotic
lyric104512723ly_ric
lytic104513033ly_tic
mafic125615463m_afic
magic105818663m_agic
magpie1139093magpie
malic94525663m_alic
manic94629443m_anic
mantic104120903mantic
masonic1139913masonic
mastic103119173mastic
medic104619653m_edic
meiotic11410933meiotic
melic94722333m_elic
melodic1238543melodic
meropia1149613meropia
mesic93617863m_esic
mesonic11310093mesonic
metric10314683metric
mic77647643m___ic
mimic111414323m_imic
miosis83615163miosis
miotics112710653miotics
mitotic1139713mitotic
moc77845083m_o__c
modi76826313m_odi_
modica11310063m_odica
moil65534093m_o_il
momi87524483m_omi_
monie75631653m_onie
monodic1269783monodic
mop76950823m_op__
mope86838043m_op_e
moped105424733m_oped
moper94925923m_oper
mopes95134983m_opes
mopey124821823m_opey
mopier103914783m_opier
moping114017103m_oping
mopish134311593m_opish
mops85940133m_op_s
mopy115721973m_op_y
moronic11311863moronic
morphic1648693morphic
mosaic10311143mosaic
motif10519683m_otif
motoric11312233motoric
movie105319133m_ovie
moxie144018123m_oxie
music94316403m_usic
myalgic15134223myalgic
myasis114010473myasis
myc106519503my___c
mycosis1437763mycosis
myelin1138973myelin
myogenic1647093myogenic
myologic1647713myologic
myoma1239273myo_ma
myomas1338303myomas
myopathic2154413myopathic
myoses114013843myoses
myosins12278963myosins
myotonic1547753myotonic
myrica1336833my_rica
myrrhic1743763myrrhic
mysid11610693my_sid
mystics14279103mystics
mythopeic2163503mythopeic
myxoid1936883myxoid
niobic1037243niobic
odic74920573__odic
optic93715183__optic
otic66624823__otic
ovonic11288183ovonic
ozonic17308943ozonic
phobic153010073phobic
phonic133315213phonic
photic133316443photic
pic76046823___pic
pionic103515953pionic
ptotic102713373ptotic
pyemic1537893pyemic
pyic116915823py__ic
pyknic1734893pyknic
pyloric1438063pyloric
pyoid11513763pyo_id
pyosis114012123pyosis
pyric123815073py_ric
rhodic12227233rhodic
rhotic112711233rhotic
sepic94617053_sepic
sodic84917493_sodic
sonic75225293_sonic
spic85227433__spic
stoic7317253sto_ic
sylphic1745883sylphic
syncopic1745633syncopic
syndic1237303syndic
synodic1347363synodic
synoptic1546923synoptic
thoric114314043thoric
tonic74727653_tonic
topi67830393_topi_
topics104714583_topics
topis76025833_topis
toric76529313_toric
toxic145315623_toxic
trophic14311033trophic
tropics113610653tropics
tropin83316753tropin
tyronic1239313tyronic
umbonic1365463umbonic
utopia8107883utopia
yogi86120423_yogi_
yogin98317743_yogin
yogis95617743_yogis
yomim12510083_yomim
yoni77524393_yoni_
yonis85020823_yonis
yowie114616453_yowie
zoic152316073_zo_ic
zygotic2254663zygotic
zymotic2345713zymotic

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 Limit1127162135.18621734.7
3Display Results2132130.0802662.5
 (SQL Overall)1786912135.63931688.4
 
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.