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

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

115 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
meteorological195378(None) 
meteorologic1763172meteorologic__
methodological2353302methodological
metrological1748372met__rological
meteorologies1653583meteorologi_es
meteorologist1654873meteorologi_st
meteorologists1754183meteorologists
petrological1758593pet__rological
astrological1547024ast__rological
autecological1854434aute_cological
demonological1954964de_monological
dendrological1853834de_ndrological
entomological1855034_entomological
ethnological1846814_et_hnological
ethological1748194_et__hological
etiological1448414_et__iological
etymological2045874_et_ymological
futurological1952984fut_urological
horological1748284___horological
meteoritical1652954meteor__itical
meteoroidal1462784meteor__o_idal
meteorology1763344meteorolog___y
metronomical1854164met__ronomical
mineralogical1862284mine_ralogical
museological1754784muse__ological
mythological2346904myt__hological
necrological1747284__necrological
neurological1547334__neurological
numerological1854014nume_rological
osteological1546374oste__ological
selenological1654664sele_nological
serological1468774__se_rological
soteriological1763894soteriological
stereological1655674_stereological
teleological1546574__teleological
topological1647434__t_opological
tropological1746634__tropological
aerobiological1955135aerobiological
anthological1847515ant__hological
anthropological2373105anthropological
bacteriological2282865bacteriological
chronological2175955_chronological
cohomological2354085_cohomological
cytological1947455cyt___ological
deontological1755175de_ontological
dermatological2053855dermatological
ecological1548705___e_cological
embryological2353185_embryological
enological1348885___e_nological
exobiological2554725_exobiological
extralogical2294135_e_xtralogical
gemological1747025__ge_mological
genealogical1652715gene__alogical
geological1448075__ge__ological
gerontological1854175gerontological
gynecological22113785gyne_cological
hematological2155945he_matological
herpetological2253325herpetological
homological1948455___homological
hydrological2246485__hydrological
iconological1756025__iconological
ideological15106645_ide__ological
lithological1845895lit__hological
malacological2053975m_alacological
methodologies2053485methodologi_es
methodologist2054315methodologi_st
methodologists2153475methodologists
metrologies1449585met__rologi_es
metrologist14511235met__rologi_st
metrologists1588835met__rologists
microbiological2464375microbiological
morphological2353965m_orphological
musicological2053545m_usicological
mycological2147115m___ycological
myrmecological2662645myrmecological
nematological1855665ne_matological
neurobiological20123925neurobiological
nomological1648075___nomological
nosological1447375___nosological
ontological1448315ont___ological
oological1248325____o_ological
paleobiological2264735paleobiological
paleoecological2263555paleoecological
paleontological2063845paleontological
paleozoological2963265paleozoological
pathological2047985pat__hological
pedological1757615__pe_dological
penological1648875__pe_nological
petrologic1547735pet__rologic__
petrologically2256065pet__rologically
phenological2068055_phe_nological
phonological2058375__phonological
phrenological2156335phre_nological
pomological1848035___pomological
prebiological2055975_prebiological
psephological2354985_psephological
pteridological2053595pteridological
rheological17127475_rhe__ological
seismological1873965se_ismological
semasiological1983015semasiological
semiological1747785__semiological
speleological1853915_speleological
synecological21104115syne_cological
tautological1555485__tautological
technological2155145te_chnological
teratological1656115te_ratological
terminological1953645terminological
theological1798265__t_heological
tribological1745985__tribological
typological1946685__t_ypological
unecological1745825_une_cological
urological1347755____urological
vexillological2761685vexillological
virological1746305___virological
zoological2246445___zo_ological

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 Filter178691950240.376475242.0
2DLD Change Limit950241156.75014077.6
3Display Results1151150.0931236.6
 (SQL Overall)1786911157.21924752.9
 
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.