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

139 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
ethological174819(None) 
ethnological1846811ethnological
etiological1448411etiological
anthological1847512anthological
ecological1548702e_cological
enological1348882e_nological
etymological2045872etymological
lithological1845892lithological
metrological1748372metrological
mythological2346902mythological
pathological2047982pathological
petrological1758592petrological
theological1798262_theological
abiological1647833abiological
algological1545973algological
astrological1547023astrological
axiological2146873axiological
biological15128883_biological
bryological1945373bryological
cytological1947453cytological
entomological1855033entomological
ethnologic1645723ethnologic__
ethologies14310543ethologi_es
ethologist14411893ethologi_st
ethologists1549023ethologists
etiologic1246783etiologic__
etiologically1955993etiologically
extralogical2294133extralogical
gemological1747023gemological
geological1448073_geological
homological1948443homological
horological1748283horological
ideological15106643ideological
methodological2353303methodological
mycological2147113mycological
necrological1747283necrological
neurological1547333neurological
nomological1648073nomological
nosological1447373nosological
oncological1647253oncological
ontological1448313ontological
oological1248323__oological
osteological1546373osteological
pedological1757613pedological
penological1648873penological
pomological1848033pomological
psephological2354983psephological
rheological17127473rheological
semiological1747783semiological
serological1468773serological
sinological1447133sinological
technological2155143technological
teleological1546573teleological
topological1647433topological
typological1946683typological
ufological1644903_ufological
urological1347753_urological
virological1746303virological
zoological2246443_zoological
alogical1147764___alogical
analogical1356364_analogical
antilogical1447274antilogical
audiological1665664audiological
autecological1854434autecological
biologicals16105024_biologicals
cohomological2354084cohomological
cosmological1946084cosmological
demonological1954964demonological
dendrological1853834dendrological
deontological1755174deontological
dialogical1445514_dialogical
ecologic1349564e_cologic__
ecologically2067724e_cologically
economical1645964e_conomical
embryological2353184embryological
eschatological2262464eschatological
ethical1238444eth____ical
ethmoidal1552764eth_mo_idal
ethnical1346364eth___nical
ethnologies1547984ethnologi_es
ethnologist1549264ethnologi_st
ethnologists1647044ethnologists
ethology1547254etholog___y
etiologies1139414etiologi_es
etymologically2564124etymologically
exobiological2554724exobiological
futurological1952984futurological
genealogical1652714genealogical
graphological2253524graphological
hagiological1955814hagiological
hematological2155944hematological
histological1846084histological
hydrological2246484hydrological
ichthyological2882454ichthyological
iconological1756024iconological
illogical1245414__illogical
karyological2274734karyological
limnological1745074limnological
lithologic1645014lithologic__
lithologically2364064lithologically
logical1038514____logical
meteorological1953784meteorological
methodical1845144meth__odical
metronomical1854164metronomical
morphological2353964morphological
museological1754784museological
mythologic2146044mythologic__
mythologically28154954mythologically
nematological1855664nematological
nonlogical1347064_nonlogical
nontheological2063214nontheological
ornithological2082454ornithological
pathologic1847434pathologic__
pathologically2585554pathologically
petrologic1547734petrologic__
petrologically2256064petrologically
phenological2068054phenological
philological2046374philological
phonological2058374phonological
phycological2546944phycological
prebiological2055974prebiological
prelogical1546694_prelogical
psychological2656594psychological
radiological1646984radiological
scatological1745544scatological
seismological1873964seismological
selenological1654664selenological
sociological1747504sociological
speleological1853914speleological
stereological1655674stereological
tautological1555484tautological
teratological1656114teratological
theologian1464814_theologi_an
theologic1547504_theologic__
theologically2256144_theologically
theurgical1652354_theurgical
tribological1745984tribological
tropological1746634tropological
unecological1745824unecological

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 Filter1786911488190.423422437.4
2DLD Change Limit1488191398.36017801.3
3Display Results1391390.0761828.9
 (SQL Overall)1786911398.85920170.6
 
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.