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

103 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
lithologically236406(None) 
lithological1845892lithologica_l_
mythologically28154952mythologically
pathologically2585552pathologically
astrologically2055433astrologically
biologically2067053bi__ologically
cytologically2455923cyt_ologically
etiologically1955993_etiologically
histologically2364313histologically
ideologically2055033_ideologically
ontologically1956123ont_ologically
petrologically2256063petrologically
theologically2256143__theologically
virologically2255163vi_rologically
anthological1847504anthologica_l_
axiologically2655274_axiologically
catholically2256004cathol__ically
cosmologically2454074cosmologically
dialogically1975834di__alogically
ecologically2067724__ecologically
entomologically2363204entomologically
ethological1748194_ethologica_l_
etymologically2564124etymologically
geologically1947364__geologically
homologically2456134_homologically
hydrologically27104504hydrologically
illogically1746384_i__llogically
lethargically2272464leth_argically
limnological1745074limnologica_l_
lithologic1645014lithologic____
liturgically1852514lit__urgically
morphologically2862904morphologically
mycologically2655434_mycologically
mythological2346904mythologica_l_
neurologically2074964neurologically
nosologically1955134_nosologically
pathological2047974pathologica_l_
phenologically2555364phenologically
philologically2564304philologically
phonologically2555554phonologically
psychologically3194234psychologically
radiologically2174544radiologically
rheologically2255274_rheologically
semiologically2254994semiologically
serologically1957124_serologically
sociologically2254754sociologically
tautologically2094174tautologically
technologically2683264technologically
teleologically2054704teleologically
topologically2165394_topologically
tropologically2264184tropologically
typologically2465164_typologically
zoologically2755644__zoologically
alcoholically2353455alcohol__ically
alogically1648795____alogically
analogically18126285__analogically
astrological1547025astrologica_l_
astronomically2163905astronomically
athletically2047235_ath_letically
autonomically2054895aut_onomically
biological15128885bi__ologica_l_
biologicals16105025bi__ologica_ls
cathodically2355415cath__odically
cholerically2256155__cholerically
chronologically2663545chronologically
cytological1947455cyt_ologica_l_
diabolically2053755diabol__ically
dichotically2356225dich__otically
embryologically2892355embryologically
ethnological1846815_ethnologica_l_
etiological1448415_etiologica_l_
genealogically2163125genealogically
histological1846085histologica_l_
ideological15106645_ideologica_l_
immunologically2562925immunologically
impolitically2254615_impolitically
isotonically1756055_i_sotonically
isotopically1955375_i_sotopically
lichenological22112835lichenologica_l_
lithologies1546835lithologi___es
lithology1645445litholog_____y
logically1548975_____logically
methodically2356155meth__odically
metrological1748375metrologica_l_
metronomically2354555metronomically
mineralogically2372375mineralogically
mitotically1849125mit___otically
nonbiologically2383065nonbiologically
ontological1448315ont_ologica_l_
ornithological2082455ornithologica_l_
orthodontically2471855orthodontically
orthoepically2353085ortho_epically
orthopedically2562045orthopedically
osteological1546375osteologica_l_
palynologically26123195palynologically
petrological1758595petrologica_l_
physiologically2993605physiologically
sinological1447135si_nologica_l_
stereologically2163515stereologically
theological1798265__theologica_l_
thoracically2285445__thoracically
toxicologically3062555toxicologically
virological1746305vi_rologica_l_

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.360496363.9
2DLD Change Limit950241037.09313396.9
3Display Results1031030.0761355.3
 (SQL Overall)1786911037.52923733.7
 
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.