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

117 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
thanatologists185286(None) 
thanatologist1753611thanatologist_
thanatologies1752822thanatologi_es
hematologists19217043_hematologists
neonatologists1584183neonatologists
planetologists1763623planetologists
teratologists1496583t_eratologists
thanatological2062483thanatological
analogists1147314__ana__logists
anthologists1648024__anthologists
climatologists1983274climatologists
deontologists1555924deon_tologists
dermatologists18134914dermatologists
diabetologists18122814diabetologists
ethnologists1647034eth_n__ologists
hematologist18219204_hematologist_
histologists1646294_h_istologists
malacologists1854404_malacologists
narratologists1553204narratologists
nematologists16166594_nematologists
neonatologist14135354neonatologist_
onomatologists1753324onomatologists
ontologists1248904__on_tologists
pharmacologists2573644pharmacologists
phonologists1848774phon__ologists
planetologist1664504planetologist_
primatologists19184344primatologists
rheumatologists2162254rheumatologists
teratologist13108574t_eratologist_
thanatology1852284thanatolog___y
algologists1346145__a_lgologists
analogisms1345215__ana__logisms
analogist10410235__ana__logist_
anatomists12116745__anat__omists
angelologists1553375__angelologists
anthologist15410465__anthologist_
apologists1348885____apologists
archaeologists20122805archaeologists
audiologists1445615__audiologists
campanologists2152625campanologists
cardiologists1765145_cardiologists
cetologists1449165___cetologists
chronologists1966115ch_ronologists
climatologist1873945climatologist_
conchologists2154565_conchologists
cosmetologists1953145cosmetologists
cryptologists2155235_cryptologists
cytologists1748015___cytologists
dendrologists1654085_dendrologists
deontologist1457415deon_tologist_
dermatologist1786465dermatologist_
diabetologist17133145diabetologist_
dialectologists1992395dialectologists
enologists11310625__en__ologists
escapologists1853345_escapologists
ethnologist1549255eth_n__ologist_
ethologists1549015eth____ologists
fetologists1547995___fetologists
gerontologists1654855gerontologists
glaciologists1753945gla_ciologists
graphologists20123825gra_phologists
gynecologists2053695_gynecologists
hematologies1847545_hematologi_es
herpetologists2083635herpetologists
histologist1547985_h_istologist_
horologists1548965_h__orologists
hydrologists2046095_h_ydrologists
limnologists1545325limn__ologists
malacologist1755635_malacologist_
malariologists1773355_malariologists
monologists14410075_mon__ologists
narratologist1453835narratologist_
nematologist15208475_nematologist_
neologists1139775___n_eologists
neonatologies1453825neonatologi_es
nonbiologists1664715_nonbiologists
oceanologists1654305_oceanologists
oncologists1448075__on_cologists
onomatologist1654395onomatologist_
ontologist11411365__on_tologist_
ornithologists1852585_ornithologists
otologists1149635____otologists
palynologists1954995_palynologists
papyrologists2154085_papyrologists
parasitologists1862805parasitologists
pathologists1848365_pa_thologists
penologists1449595_pen__ologists
pharmacologist2464175pharmacologist_
philologists1876675ph__ilologists
phonologist17411555phon__ologist_
phraseologists2053575phraseologists
phrenologists1956295ph_renologists
phycologists2367135ph__ycologists
physiologists22156015ph_ysiologists
planetologies1653255planetologi_es
primatologist18175305primatologist_
proctologists1856805_proctologists
radiologists1497355_ra_diologists
rheologists1547315rh___eologists
rheumatologist2062855rheumatologist_
sinologists1257675_sin__ologists
tattooists1092745t_a_tto_o_ists
tautologies1245915t_a_utologi_es
technologists19125705t_echnologists
teleologists1347225t__eleologists
teratologies1346835t_eratologi_es
thanatoses1343525thanat__o__ses
thaumaturgists20141025thaumat_urgists
theologises15106725th___eologises
topologists1447865t___opologists
toxicologists2353985t_oxicologists
tribologists1546165t__ribologists
trichologists1955425t_richologists
typologists1746815t___ypologists
urbanologists1653255_urbanologists
volcanologists20122765volcanologists
vulcanologists2092305vulcanologists

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.1261418182.5
2DLD Change Limit950241176.09315595.6
3Display Results1171170.0761539.5
 (SQL Overall)1786911176.29528386.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.