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 “myologies” 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
myologies153975(None) 
mycologies1848851mycologies
apologies12311192apologies
biologies12311182biologies
bryologies1646042bryologies
cytologies1639262cytologies
ecologies12312352ecologies
enologies10312972enologies
geologies11410642geologies
menologies13310602menologies
misologies13139062misologies
mixologies20136582mixologies
monologies13312542monologies
myologic1647702myologi_c
myologist15411092myologist
myologists1648202myologists
mythologies2047842mythologies
neologies10411712neologies
ologies8615022__ologies
oologies9312992_oologies
orologies10311622orologies
otologies10311402otologies
pyrologies16310012pyrologies
typologies1647642typologies
ufologies1345982ufologies
urologies1039532urologies
zoologies1939012zoologies
zymologies2546412zymologies
aerologies11312013aerologies
agrologies1237693agrologies
algologies1246793algologies
analogies101910643analogies
apiologies1339063apiologies
apologias1247503apologias
apologise1248303apologise
apologises1347303apologises
apologizes2246203apologizes
apologues1245023apologues
areologies1139823areologies
axiologies1837483axiologies
biologics1446863biologics
boogies103719013_bo_ogies
cetologies13410843cetologies
colognes11310603_colognes
colonies103620013_colonies
doxologies1946323doxologies
duologues1143393duologues
embryologies2053163embryologies
ethologies14310523ethologies
etiologies1139393etiologies
etymologies17176783etymologies
eulogies938523_eulogies
fetologies1439173fetologies
gemmologies1745243gemmologies
gemologies1449003gemologies
geologizes2146793geologizes
homologies16311513homologies
horologies14411053horologies
hydrologies1948173hydrologies
hymnologies2046103hymnologies
hypnologies2046083hypnologies
ideologies1237333ideologies
isologues1044563isologues
karyologies1944443karyologies
limnologies1445533limnologies
melodies11310123m_elodies
metrologies1449563metrologies
moggies113111723m_o_ggies
molies84429513m_ol__ies
mollies93420233m_ol_lies
monodies11312493m_onodies
monologues1346273monologues
museologies1444543museologies
myalgias14123873myal_gias
mycologic1946933mycologi_c
mycologist18410353mycologist
mycologists1947723mycologists
mylonites1446433my_lonites
myoglobins1851973myoglobins
myology1636153myolog__y
myopies14309713my__opies
myosotes1344653myoso_tes
myosotis1344523myosoti_s
myosotises1543653myosotises
myotomes1546233myoto_mes
myotonias1445943myotonias
mythologizes3054613mythologizes
neologizes2047233neologizes
nomologies1339473nomologies
noogies82814583_no_ogies
nosologies1148103nosologies
oecologies1339463oecologies
oenologies1139393oenologies
oinologies1148303oinologies
oncologies1348653oncologies
ontologies1139883ontologies
pedologies1439343pedologies
penologies13311223penologies
phycologies2247773phycologies
phytologies2049033phytologies
pomologies15310033pomologies
posologies1349543posologies
prologizes2248113prologizes
prologues1246903prologues
rheologies1488433rheologies
semiologies1448803semiologies
serologies11311323serologies
sexologies1837713sexologies
sinologies1148893sinologies
sitologies1148703sitologies
syllogizes2343803syllogizes
symbologies1945173symbologies
theologies141010093theologies
tocologies1349763tocologies
tokologies1547143tokologies
topologies1348973topologies
trilogies1048163trilogies
venologies1438373venologies
virologies1447213virologies

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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411197.25020502.2
3Display Results1191190.0631888.9
 (SQL Overall)1786911197.48623870.0
 
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.