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 “metrological” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

136 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
metrological174834(None) 
petrological1758551petrological
astrological1546982astrological
ethological1748172_ethological
etiological1448382_etiological
meteorological1953762meteorological
metronomical1854132metronomical
mythological2346882mythological
necrological1747282necrological
neurological1547332neurological
serological1468772se_rological
anthological1847483anthological
cytological1947433cyt_ological
dendrological1853833dendrological
ecological1548703_e_cological
embryological2353183embryological
enological1348883_e_nological
ethnological1846783_ethnological
etymological2045843_etymological
extralogical2294133extralogical
futurological1952963futurological
gemological1747013ge_mological
geological1448053ge__ological
horological1748243_horological
hydrological2246463hydrological
lithological1845873lithological
methodological2353283methodological
metrologies1449563metrologi_es
metrologist14511223metrologi_st
metrologists1588823metrologists
museological1754773museological
mycological2147103m_ycological
numerological1854013nume_rological
ontological1448283ont_ological
osteological1546333osteological
pathological2047923pathological
pedological1757593pe_dological
penological1648853pe_nological
petrologic1547733petrologic__
petrologically2256013petrologically
semiological1747773semiological
stereological1655643stereological
teleological1546543teleological
urological1347753__urological
virological1746303_virological
abiological1647814_abiological
aerologic1249604ae_rologic__
aeronomical1555314ae_ronomical
algological1545954_algological
antilogical1447244ant_ilogical
astrologically2055374astrologically
astronomical1654084astronomical
audiological1665654audiological
autecological1854414autecological
axiological2146864_axiological
biological15128864__biological
bryological1945374_bryological
cosmological1946064cosmological
demonological1954944demonological
deontological1755154deontological
entomological1854994entomological
etiologic1246784_etiologic__
etiologically1955964_etiologically
genealogical1652714genealogical
hagiological1955774hagiological
hematological2155924hematological
histological1846064histological
homological1948404_homological
iconological1756004iconological
ideological15106634_ideological
immunological2054014immunological
karyological2274734karyological
limnological1745074limnological
malacological2053974malacological
metalloidal1452764metallo_idal
metallurgical1871524metallurgical
metaphorical2163504metaphorical
meteoritical1652924meteoritical
meteoroidal1462764meteoro_idal
meteorologic1763174meteorologic__
methodical1845134met__hodical
metonymical2062884met_onymical
metralgia1253974metral_gi_a_
metralgias1353604metral_gi_as
metrical12311584metr____ical
metrology1546784metrolog___y
metronomic1655834metronomic__
metronomically2354494metronomically
metropolitan1692484metropolitan
mineralogical1862284mineralogical
morphological2353944morphological
musicological2053544musicological
mythologic2146034mythologic__
mythologically28154934mythologically
nematological1855664nematological
neurologic1346804neurologic__
neurologically2074944neurologically
nomological1648054_nomological
nosological1447344_nosological
oncological1647234_oncological
oological1248304___oological
petrologies1449874petrologi_es
petrologist14711884petrologi_st
petrologists1559134petrologists
phenological2068014phenological
philological2046324philological
phonological2058324phonological
phycological2546904phycological
pomological1847994_pomological
prebiological2055934prebiological
prelogical1546684__prelogical
psephological2354964psephological
pteridological2053564pteridological
radiological1646974radiological
rheological17127444_rheological
scatological1745524scatological
seismological1873964seismological
selenological1654664selenological
serologic1248674se_rologic__
serologically1957094se_rologically
sinological1447134_sinological
sociological1747474sociological
somatological1854854somat_ological
soteriological1763844soteriological
speleological1853904speleological
tautological1555464tautological
technological2155144technological
teratological1656114teratological
theological1798234_theological
topological1647394_topological
tribological1745954tribological
tropological1746614tropological
typological1946664_typological
ufological1644904__ufological
unecological1745824unecological
zoological2246424__zoological

Search took 9 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 Filter1786911247900.1431249587.4
2DLD Change Limit1247901368.67014393.3
3Display Results1361360.0801700.0
 (SQL Overall)1786911368.89320093.4
 
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.