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

166 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
gerontologists165485(None) 
gerontologist1555981gerontologist_
deontologists1555922de_ontologists
gerontologies1584432gerontologi_es
chronologists1966113chron_ologists
demonologists1755563demon_ologists
deontologist1457413de_ontologist_
dermatologists18134923dermatologists
gerontologic1653763gerontologi__c
gerontological1854173gerontological
herpetologists2083633herpetologists
neonatologists1584193ne_onatologists
ontologists1248903___ontologists
proctologists1856813_proctologists
teratologists1496593ter_atologists
cetologists1449164ce___tologists
chronologist1857624chron_ologist_
cryptologists2155234_cryptologists
demonologist1657054demon_ologist_
deontologies1445414de_ontologi_es
dermatologist1786464dermatologist_
enologists11310624_e__n_ologists
ethnologists1647044_ethn_ologists
exobiologists2355324_exobiologists
fetologists1547994fe___tologists
gemmologists1845234ge__mmologists
gemologists1577884ge___mologists
genealogists1452784ge__nealogists
geologists1279164ge____ologists
gerontology1653364gerontolog___y
graphologists20123834g_raphologists
hematologists19217054he_matologists
herpetologist1984794herpetologist_
monologists14410074__mon_ologists
narratologists1553214narratologists
nematologists16166604ne_matologists
neonatologist14135354ne_onatologist_
neurobiologists18114314neurobiologists
oncologists1448074___oncologists
ontologist11411364___ontologist_
otologists1149634___o_tologists
paleontologists1884524paleontologists
penologists1449594pe__n_ologists
phonologists1848774_phon_ologists
phrenologists1956294phren_ologists
proctologist1758964_proctologist_
selenologists1455334selen_ologists
serologists12410124ser___ologists
technologists19125704techn_ologists
teratologist13108574ter_atologist_
aerobiologies1655055aerobiologi_es
aeronomists1355635aeron___omists
anthologists1648035___anthologists
astrobiologists1873765astrobiologists
bryologists1745705_br__yologists
cardiologists1765145car_diologists
cetologist13412255ce___tologist_
chronologies1846415chron_ologi_es
climatologists1983285climatologists
conchologists2154565__conchologists
cosmetologists1953145cosmetologists
cosmologists1746415__cosmologists
cryobiologists2254105cryobiologists
cryptologist2056435_cryptologist_
cytologists1748015___cytologists
demonologies1645505demon_ologi_es
dendrologists1654085de_ndrologists
deontological1755175de_ontological
dermatologies1755255dermatologi_es
diabetologists18122815diabetologists
ecologists13310925_e___cologists
electrologists1765655_electrologists
embryologists2153125_embryologists
enologist10314125_e__n_ologist_
entomologists1655665_entomologists
enzymologists2873115_enzymologists
escapologists1853345_escapologists
ethnologist1549265_ethn_ologist_
ethologists1549025_e__thologists
etymologists18156495_e_tymologists
exobiologist2256205_exobiologist_
fetologist14410405fe___tologist_
frontlists1344525_front_l__ists
gemmologist1746545ge__mmologist_
gemologist141010285ge___mologist_
genealogist1354145ge__nealogist_
geochronologist2272305geochron_ologist_
geohydrologists2461525geohydrologists
geologist11611785ge____ologist_
gerontocrats15131775geront__ocrats
glaciologists1753945g_laciologists
graphologist19114865g_raphologist_
gynecologists2053695g_ynecologists
hematologist18219205he_matologist_
herpetologies1953465herpetologi_es
histologists1646295__histologists
horologists1548965__ho_rologists
hydrobiologists25134045hydrobiologists
immunologists18124495immun_ologists
iridologists1444685_ir_idologists
lexicologists2374155le_xicologists
limnologists1545325_limn_ologists
martyrologists2062895martyrologists
meteorologists1754185meteorologists
methodologists2153475methodologists
metrologists1588835me__trologists
microbiologists22134815microbiologists
monologist13413615__mon_ologist_
monologuists1553955__mon_ologuists
morphologists2154265mor_phologists
myrmecologists2452785myrmecologists
narratologist1453835narratologist_
necrologists1547875ne__crologists
nematologist15208475ne_matologist_
neologists1139775____neologists
neonatologies1453825ne_onatologi_es
nephrologists1954985ne_phrologists
neurobiologist17124925neurobiologist_
neurologists1347645ne__urologists
nonbiologists1664725__nonbiologists
oceanologists1654305ocean_ologists
oncologist13410415___oncologist_
onomatologists1753335onomatologists
ontologies1139885___ontologi_es
oologists1039855___o__ologists
ornithologists1852595_ornithologists
orologists1149825___o_rologists
osteologists1346765___osteologists
otologist10412815___o_tologist_
paleontologist1765145paleontologist_
palynologists1954995palyn_ologists
parasitologists1862805parasitologists
pedologists1548275pe___dologists
penologist13412845pe__n_ologist_
petrologists1559145pe__trologists
phonologist17411565_phon_ologist_
phraseologists2053575phraseologists
phrenologist1857915phren_ologist_
planetologists1763625planetologists
pomologists1648985__po_mologists
primatologists19184355primatologists
proctologies1746315_proctologi_es
prologists13311175_pr___ologists
pteridologists18133725pter_idologists
radiologists1497365__radiologists
rheologists1547315__r_heologists
rheumatologists2162255rheumatologists
seismologists16124195se_ismologists
selenologist1357005selen_ologist_
semiologists1548225se__miologists
serologist11413155ser___ologist_
sexologists1947255se___xologists
sinologists1257675__sin_ologists
sociologists1547945__sociologists
technologist18137405techn_ologist_
teleologists1347225te__leologists
teratologies1346875ter_atologi_es
thanatologists1852865thanatologists
topologists1447865__to_pologists
tribologists1546165_tr_ibologists
trichologists1955425_trichologists
urbanologists1653255_urbanologists
urologists1148415_ur___ologists
vexillologists2591745vexillologists
virologists1546635vir___ologists
zoologists2047175__zo__ologists

Search took 7 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.343520965.0
2DLD Change Limit950241665.94015997.3
3Display Results1661660.1231349.6
 (SQL Overall)1786911666.40627894.3
 
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.