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

149 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
myopia1331844(None) 
myopias14308151myopias
myopic15308461myopic
anopia83412392anopia
meropia1149622meropia
myoid11512992myo_id
myoma1239272myo_ma
myope124010972myop_e
myopes13419962myopes
myopies14309722myopies
myopy15457352myop_y
myosin113410762myosin
myosis114012562myosis
myotic133112312myotic
utopia8107882utopia
alodia71112453alodia
amblyopia1851513amblyopia
ammonia1148693ammonia
anopias92412483anopias
anopsia9258443anopsia
anoxia133510023anoxia
aporia8315863aporia
atonia63816513atonia
atopic103514143atopic
biopic123710673biopic
chopin132712193chopin
cobia94117513_cobia
copra98115463_copra
coria75828323_coria
dopa77220903_dop_a
dystopia1444833dystopia
ectopia1147703ectopia
emporia1148753emporia
folia83618933_folia
gloria71910553gloria
gonia64117533_gonia
gopik1257533_gopik
gyoza1836113gyo_za
hoopla1147633hoopla
hydria13227903hydria
hyoid12612443hyo_id
hypha1637383hy_pha
hypoxia2246373hypoxia
koppa13397293_koppa
logia68116603_logia
maffia14327203maffia
mafia104418033m_afia
magpie1139093magpie
mahonia1238443mahonia
mania75634153m_ania
maria75032883m_aria
media84721713m_edia
melodia1038883melodia
meropias1249973meropias
meropic13310273meropic
metopic1339763metopic
milia72719573m_ilia
milpa92111403milp_a
miosis83615163miosis
miotic103715753miotic
moa57249183m_o__a
mocha1249923m_ocha
modi76826323m_odi_
modica11310063m_odica
moil65534093m_o_il
moira71012023m_oira
mola66035633m_o_la
momi87524483m_omi_
momma85111053m_omma
monie75631653m_onie
moola75117033m_oola
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
mora66641273m_o_ra
morphia1447483morphia
motif10519683m_otif
movie105319133m_ovie
moxa136917743m_o_xa
moxie144018123m_oxie
muonic10410183muonic
myalgia13124293myalgia
myasis114010473myasis
mycelia1444843mycelia
mycosis1437763mycosis
mycotic1647713mycotic
myelin1138973myelin
myna95815303my__na
myomas1338303myomas
myomata1445923myomata
myoses114013843myoses
myosins12278963myosins
myotics14257603myotics
myotonia1346273myotonia
myriad1235913my_riad
myrica1336833myrica
mysid11610693my_sid
mystic132711643mystic
mythic1637273mythic
myxoid1936883myxoid
myxoma2043943myxoma
noria55722183_noria
nympha1643573nympha
obia67923113__obia
ohia75719363__ohia
phobia13278603phobia
pia56848043___pia
podia8415283_podia
poppa8409893_poppa
propria1149933propria
pyemia1337553pyemia
pyoid11513763pyo_id
pyosis114012123pyosis
pyuria1136953pyuria
scoria8513503scoria
scotia8310803scotia
senopia949233senopia
sepia75318673_sepia
sinopia947743sinopia
syconia1248313syconia
synovia1345533synovia
thoria93012893thoria
topi67830393_topi_
topic95721503_topic
topis76025833_topis
tropic103014193tropic
tropin83316753tropin
typic124511963ty_pic
utopian9126273utopian
utopias9117723utopias
yoga87418053_yo_ga
yogi86120423_yogi_
yogic116114933_yogic
yogin98317743_yogin
yogis95617743_yogis
yomim12510083_yomim
yoni77524393_yoni_
yonic105920843_yonic
yonis85020823_yonis
yowie114616453_yowie
zoysia1844163zoysia

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.406440125.6
2DLD Change Limit1127161495.51620434.4
3Display Results1491490.0463239.1
 (SQL Overall)1786911495.96829941.5
 
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.