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

119 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
myopias1430815(None) 
myopia13318441myopia_
myopies14309721myopies
anopias92412482anopias
meropias1249962meropias
myomas1338302myo_mas
myopes13419962myop_es
myopic15308462myopi_c
myosins12278962myosins
myosis114012562myosi_s
myotics14257602myotics
utopias9117722utopias
amblyopias1951623amblyopias
ammonias1247953ammonias
anopia83412393anopia_
anopsias10337983anopsias
anoxias14259113anoxias
aporias9315153aporias
atonias73315993atonias
atopies92816433atopies
biopics13318543biopics
capias10318353_capias
chopins142312243chopins
cobias104014993_cobias
copies104130303_copies
copras103517153_copras
dopas85019063_dop_as
dystopias1544883dystopias
ectopias1248273ectopias
glorias81610323glorias
gyozas1933613gyo_zas
hooplas1239203hooplas
hyoids1377673hyo_ids
hypoxias2346143hypoxias
koppas14407603_koppas
maffias15327283maffias
mafias113913573m_afias
magpies12310363magpies
mahonias1348063mahonias
manias84029033m_anias
medias93620783m_edias
melodias1148703melodias
meropia1149613meropia_
milpas101710273milp_as
miosis83615163miosi_s
miotics112710653miotics
misbias1139083misbias
moas65545343m_o__as
mochas13310663m_ochas
moils76125753m_o_ils
molas75132093m_o_las
molies84429513m_olies
mommas94110653m_ommas
monas74732153m_o_nas
monies83233163m_onies
moolas83615593m_oolas
mopeds11499663m_opeds
mopers104220373m_opers
mopes95134983m_op_es
mopier103914783m_opier
mopiest113014293m_opiest
moping114017103m_oping
mopish134311593m_opish
mops85940133m_op__s
moras76438783m_o_ras
morphias1546843morphias
motifs1139673m_otifs
movies115118453m_ovies
moxas145014393m_o_xas
moxies154317403m_oxies
myalgias14123893myalgias
myasis114010473myasi_s
mycosis1437763mycosi_s
myelins1237353myelins
mynas105815233my__nas
myoblast1545243myoblast
myoid11512993myo_i_d
myoma1239273myo_ma_
myope124010973myop__e
myopy15457353myop__y
myoses114013843myo_ses
myosin113410763myosi_n
myositis1345633myositis
myotic133112313myoti_c
myotonias1445953myotonias
myriad1235913my_riad
myriads1334353my_riads
myricas1436753myricas
mysids1246563my_sids
mystics14279103mystics
myxomas2153913myxomas
norias65518203_norias
obias76116863__obias
ohias84415573__ohias
phobias14228183phobias
pias66542553___pias
poppas93710713_poppas
pyemias1436803pyemias
pyosis114012123pyosi_s
pyurias1236713pyurias
scotias939753scotias
senopias1048823senopias
sepias83616103_sepias
sinopias1047873sinopias
synovias1445303synovias
thorias102312053thorias
topics104714583_topics
topis76025833_topi_s
tropics113610653tropics
tropins93116313tropins
utopia8107883utopia_
utopian9126273utopian
utopians1094903utopians
yogas96615603_yo_gas
yogins105114103_yogins
yogis95617743_yogi_s
yonis85020823_yoni_s
yowies123913733_yowies
zoysias1943843zoysias

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271196.37621020.5
3Display Results1191190.0462587.0
 (SQL Overall)1786911196.82826170.3
 
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.