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

198 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
glaciologists175394(None) 
glaciologist1654891glaciologist_
glaciologies1663692glaciologi_es
glaciological1963913glaciological
graphologists20123833graphologists
malacologists1854403malac_ologists
malariologists1773353malariologists
radiologists1497363_radiologists
sociologists1547943_sociologists
algologists1346144__algologists
apologists1348884__a_pologists
audiologists1445614_audiologists
biologists1349434___biologists
cardiologists1765144cardiologists
conchologists2154564conchologists
ecologists13310924__ec_ologists
electrologists1765654electrologists
escapologists1853344escapologists
exobiologists2355324exobiologists
gemmologists1845234g_emmologists
gemologists1577884g__emologists
geologists1279164g___eologists
glaciology1753044glaciolog___y
graphologist19114864graphologist_
gynecologists2053694gynecologists
lexicologists2374154_lexicologists
limnologists1545324_limnologists
malacologist1755634malac_ologist_
malariologist1693924malariologist_
musicologists1853544musicologists
mycologists1947734_myc_ologists
necrologists1547874_necrologists
nonbiologists1664724nonbiologists
oncologists1448074_onc_ologists
palynologists1954994palynologists
pathologists1848374_pathologists
phycologists2367134phyc_ologists
physiologists22156014physiologists
planetologists1763624planetologists
proctologists1856814proctologists
psychologists24127474psychologists
radiologist1399494_radiologist_
semiologists1548224_semiologists
sociologist1449884_sociologist_
toxicologists2353984toxicologists
trichologists1955424trichologists
volcanologists20122764volcanologists
vulcanologists2092304vulcanologists
algologist1248245__algologist_
analogists1147315__a_nalogists
angelologists1553375angelologists
anthologists1648035_anthologists
apiologies1339065__apiologi_es
apologises1347305__a_pologises
apologist12412405__a_pologist_
audiologist1347245_audiologist_
axiologies1837485__axiologi_es
bacteriologists2063255_bacteriologists
biologisms1545345___biologisms
biologist12412345___biologist_
blacklists1844185blac_kl__ists
bryologists1745705__bryologists
cardiologist1656625cardiologist_
cetologists1449165__cetologists
chronologists1966115chronologists
climatologists1983285climatologists
colonists112512505___c_olonists
colorists112313595___c_olorists
conchologist2055815conchologist_
cosmologists1746415_cosmologists
craniologies1545375craniologi_es
criminologists1952975criminologists
cryobiologists2254105cryobiologists
cryptologists2155235cryptologists
cytologists1748015__cytologists
demonologists1755565demonologists
dendrologists1654085dendrologists
deontologists1555925deontologists
diabetologists18122815diabetologists
dialectologists1992395dialectologists
dialogists1265605___dialogists
ecclesiologists2062355ecclesiologists
ecologist12314145__ec_ologist_
electrologist1657055electrologist_
embryologists2153125embryologists
enologists11310625___enologists
entomologists1655665entomologists
enzymologists2873115enzymologists
escapologist1754485escapologist_
ethnologists1647045_ethnologists
ethologists1549025__ethologists
etymologists18156495_etymologists
exobiologist2256205exobiologist_
fetologists1547995__fetologists
futurologists1773075futurologists
garbologies1544885g_arbologi_es
gemmologist1746545g_emmologist_
gemologist141010285g__emologist_
genealogists1452785g_enealogists
geologist11611785g___eologist_
gerontologists1654855gerontologists
gladioluses1351635gladiol__uses
glossolalists1461095glossolalists
graphologies1963735graphologi_es
gynecologist1954575gynecologist_
hagiologies1645345_hagiologi_es
hematologists19217055hematologists
histologists1646295_histologists
horologists1548965__horologists
hydrologists2046095_hydrologists
ideologists1346655__ideologists
immunologists18124495immunologists
iridologists1444685_iridologists
lexicologist2294915_lexicologist_
lichenologists2063035_lichenologists
limnologist1446685_limnologist_
malacologies1754385malac_ologi_es
malariologies1652745malariologi_es
mammalogists1652165_mammalogists
metrologists1588835_metrologists
mixologists2145685__mixologists
monologists14410075__monologists
morphologists2154265morphologists
museologists1544745_museologists
musicologist1754285musicologist_
mycologist18410355_myc_ologist_
myologists1648205___myologists
mythologists2146895_mythologists
necrologist14410125_necrologist_
nematologists16166605nematologists
neologists1139775___neologists
nephrologists1954985nephrologists
neurologists1347645_neurologists
nonbiologist1555915nonbiologist_
numerologists1664015numerologists
oceanologists1654305oceanologists
ologists939445_____ologists
oncologist13410415_onc_ologist_
ontologists1248905__ontologists
oologists1039855____oologists
orologists1149825___orologists
osteologists1346765_osteologists
otologists1149635___otologists
paleobiologists20115735paleobiologists
palynologist1856305palynologist_
papyrologists2154085papyrologists
parasitologists1862805parasitologists
pathologist17410665_pathologist_
pedologists1548275__pedologists
penologists1449595__penologists
petrologists1559145_petrologists
philologists1876685_philologists
phonologists1848775_phonologists
phraseologists2053575phraseologists
phrenologists1956295phrenologists
phycologist2259185phyc_ologist_
physiologist21157325physiologist_
piccoloists1752775_piccolo_ists
planetologist1664505planetologist_
pomologists1648985__pomologists
proctologist1758965proctologist_
prologists13311175___prologists
psephologists2155295psephologists
psychologises24136165psychologises
psychologisms26124775psychologisms
psychologist23109115psychologist_
pteridologists18133725pteridologists
racialists1247705_racial__ists
radiologies1347805_radiologi_es
rheologists1547315__rheologists
sciolists1147215__sciol__ists
seismologists16124195seismologists
selenologists1455335selenologists
semiologist14410715_semiologist_
serologists12410125__serologists
sexologists1947255__sexologists
sinologists1257675__sinologists
slalomists1283315sla___lomists
sociologeses1552065_sociologeses
sociologies1447805_sociologi_es
speleologists1654325speleologists
technologists19125705technologists
teleologists1347225_teleologists
teratologists1496595teratologists
thanatologists1852865thanatologists
topologists1447865__topologists
toxicologist2254835toxicologist_
tribologists1546165_tribologists
trichologist1856745trichologist_
typologists1746815__typologists
ufologists1445425___ufologists
urbanologists1653255urbanologists
urologists1148415___urologists
victimologists2262255victimologists
virologists1546635__virologists
volcanologist1993165volcanologist_
vulcanologist1982705vulcanologist_
zoologists2047175___zoologists

Search took 10 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 Filter1786911247900.390458182.1
2DLD Change Limit1247901989.33013375.1
3Display Results1981980.1401414.3
 (SQL Overall)1786911989.86018122.8
 
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.