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

125 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
gerontological185417(None) 
deontological1755172de_ontological
gerontologic1653762gerontologic__
aerobiological1955133aerobiological
chronological2175953chron_ological
demonological1954963demon_ological
dermatological2053853dermatological
gerontologies1584433gerontologi_es
gerontologist1555983gerontologi_st
gerontologists1654853gerontologists
herpetological2253323herpetological
ontological1448313___ontological
proctological2055823_proctological
teratological1656113ter_atological
cryptological2354794_cryptological
enological1348884_e__n_ological
ethnological1846814_ethn_ological
exobiological2554724_exobiological
gemological1747024ge___mological
genealogical1652714ge__nealogical
geological1448074ge____ological
gerontology1653364gerontolog___y
graphological2253524g_raphological
hematological2155944he_matological
iconological1756024_icon_ological
narratological1763094narratological
nematological1855664ne_matological
neurobiological20123924neurobiological
oncological1647254___oncological
paleontological2063844paleontological
penological1648874pe__n_ological
phonological2058374_phon_ological
phrenological2156334phren_ological
selenological1654664selen_ological
serological1468774ser___ological
technological2155144techn_ological
terminological1953644terminological
tropological1746634_tro_pological
aeronomical1555335aeron___omical
anthological1847515___anthological
antilogical1447275___antilogical
bryological1945375_br__yological
cardiological1954975car_diological
chronologic1955785chron_ologic__
chronologically2663545chron_ologically
climatological2162615climatological
cohomological2354085coho_mological
cosmological1946085__cosmological
cryobiological2463925cryobiological
cytological1947455___cytological
dendrological1853835de_ndrological
deontologies1445415de_ontologi_es
deontologist1457415de_ontologi_st
deontologists1555925de_ontologists
dermatologic1854495dermatologic__
ecological1548705_e___cological
embryological2353185_embryological
entomological1855035_entomological
eschatological2262465eschatological
ethological1748195_e__thological
etiological1448415_e__tiological
etymological2045875_e_tymological
geopolitical1752505ge_o_political
glaciological1963915g_laciological
gynecological22113785g_ynecological
histological1846085__histological
homological1948445__ho_mological
horological1748285__ho_rological
hydrobiological2763585hydrobiological
immunological2054015immun_ological
karyological2274735kar__yological
limnological1745075_limn_ological
meteorological1953785meteorological
methodological2353305methodological
metrological1748375me__trological
microbiological2464375microbiological
morphological2353965mor_phological
myrmecological2662645myrmecological
necrological1747285ne__crological
neurological1547335ne__urological
nomological1648075__no_mological
nonbiological1855265__nonbiological
nonlogical1347065__non__logical
nontheological2063215__nontheological
nosological1447375__no_sological
ontologic1247785___ontologic__
ontologically1956125___ontologically
oological1248325___o__ological
orismological1853625_orismological
ornithological2082455_ornithological
osteological1546375___osteological
palynological2154675palyn_ological
parasitological2062775parasitological
pedological1757615pe___dological
petrological1758595pe__trological
phenological2068055_phen_ological
phraseological2283695phraseological
planetological1953175planetological
pomological1848035__po_mological
praxeological2554435_praxeological
prebiological2055975_prebiological
primatological2183215primatological
proctologic1855305_proctologic__
pteridological2053595pter_idological
radiological1646985__radiological
rheological17127475__r_heological
scatological1745545__scatological
seismological1873965se_ismological
semasiological1983015semasiological
semiological1747785se__miological
sinological1447135__sin_ological
sociological1747505__sociological
somatological1854885_somatological
stereological1655675ster__eological
tautological1555485__tautological
teleological1546575te__leological
teratologic1455655ter_atologic__
thanatological2062505thanatological
topological1647435__to_pological
tribological1745985_tr_ibological
unchronological2362325unchron_ological
urological1347755_ur___ological
vexillological2761685vexillological
virological1746305vir___ological
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.360496363.9
2DLD Change Limit950241256.67314240.1
3Display Results1251250.0761644.7
 (SQL Overall)1786911257.10925135.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.