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
myopia1331843(None) 
myopias14308141myopias
myopic15308461myopic
anopia83412392anopia
meropia1149612meropia
myoid11512982myo_id
myoma1239272myo_ma
myope124010972myop_e
myopes13419962myopes
myopies14309712myopies
myopy15457352myop_y
myosin113410762myosin
myosis114012552myosis
myotic133112302myotic
utopia8107882utopia
alodia71112453alodia
amblyopia1851513amblyopia
ammonia1148693ammonia
anopias92412473anopias
anopsia9258443anopsia
anoxia133510023anoxia
aporia8315863aporia
atonia63816513atonia
atopic103514143atopic
biopic123710673biopic
chopin132712183chopin
cobia94117503_cobia
copra98115463_copra
coria75828303_coria
dopa77220903_dop_a
dystopia1444833dystopia
ectopia1147693ectopia
emporia1148753emporia
folia83618933_folia
gloria71910543gloria
gonia64117533_gonia
gopik1257533_gopik
gyoza1836113gyo_za
hoopla1147633hoopla
hydria13227903hydria
hyoid12612423hyo_id
hypha1637383hy_pha
hypoxia2246373hypoxia
koppa13397293_koppa
logia68116603_logia
maffia14327203maffia
mafia104418033m_afia
magpie1139093magpie
mahonia1238443mahonia
mania75634143m_ania
maria75032883m_aria
media84721713m_edia
melodia1038883melodia
meropias1249953meropias
meropic13310263meropic
metopic1339763metopic
milia72719563m_ilia
milpa92111403milp_a
miosis83615163miosis
miotic103715743miotic
moa57249183m_o__a
mocha1249923m_ocha
modi76826313m_odi_
modica11310063m_odica
moil65534083m_o_il
moira71012013m_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
morphia1447473morphia
motif10519663m_otif
movie105319133m_ovie
moxa136917743m_o_xa
moxie144018123m_oxie
muonic10410183muonic
myalgia13124283myalgia
myasis114010463myasis
mycelia1444823mycelia
mycosis1437753mycosis
mycotic1647693mycotic
myelin1138963myelin
myna95815293my__na
myomas1338293myomas
myomata1445923myomata
myoses114013843myoses
myosins12278953myosins
myotics14257593myotics
myotonia1346273myotonia
myriad1235893my_riad
myrica1336823myrica
mysid11610683my_sid
mystic132711643mystic
mythic1637273mythic
myxoid1936873myxoid
myxoma2043943myxoma
noria55722183_noria
nympha1643573nympha
obia67923103__obia
ohia75719363__ohia
phobia13278593phobia
pia56848033___pia
podia8415283_podia
poppa8409893_poppa
propria1149933propria
pyemia1337553pyemia
pyoid11513753pyo_id
pyosis114012123pyosis
pyuria1136953pyuria
scoria8513483scoria
scotia8310783scotia
senopia949223senopia
sepia75318673_sepia
sinopia947733sinopia
syconia1248293syconia
synovia1345523synovia
thoria93012883thoria
topi67830393_topi_
topic95721503_topic
topis76025833_topis
tropic103014193tropic
tropin83316753tropin
typic124511963ty_pic
utopian9126273utopian
utopias9117723utopias
yoga87418053_yo_ga
yogi86120423_yogi_
yogic116114933_yogic
yogin98317743_yogin
yogis95617743_yogis
yomim12510073_yomim
yoni77524393_yoni_
yonic105920843_yonic
yonis85020823_yonis
yowie114616453_yowie
zoysia1844163zoysia

Search took 7 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.1431249587.4
2DLD Change Limit1127161495.95318934.3
3Display Results1491490.0463239.1
 (SQL Overall)1786911496.14229093.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.