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 “epidemiologistsa” with Change Limit: [1] [2] [3] [4] [5] [6] [7]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

167 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
epidemiologists2162491epidemiologists_
epidemiologist2062762epidemiologist__
epidemiologies2062293epidemiologi_es_
epidemiologic2162004epidemiologi___c
epidemiological23172604epidemiologi_cal
epistemologists2072124epistem_ologists_
ecclesiologists2062355ecclesiologists_
epidemiology2161965epidemiolog____y
epistemologist1972515epistem_ologist__
ideologists1346655__ide__ologists_
semiologists1548225___semiologists_
audiologists1445616_aud__iologists_
bacteriologists2063256bacteriologists_
cardiologists1765146card__iologists_
criminologists1952976cri__minologists_
demonologists1755566___demonologists_
ecclesiologist1962606ecclesiologist__
entomologists1655666e_ntom_ologists_
enzymologists2873116e_nzym_ologists_
epistemologies1962036epistem_ologi_es_
etymologists18156496e__tym_ologists_
exobiologists2355326e__xobiologists_
gemmologists1845236___gemmologists_
gemologists1577886___gem_ologists_
ideologist1248536__ide__ologist__
iridologists1444686irid___ologists_
limnologists1545326_li__mnologists_
paleobiologists20115736_paleobiologists_
pedologists1548276_p__e_dologists_
penologists1449596_p__e_nologists_
petrologists1559146_p__etrologists_
phrenologists1956296_phre_nologists_
physiologists22156016_p_hysiologists_
pomologists1648986_p__om_ologists_
psephologists2155296_p_sephologists_
pteridologists18133726_p_teridologists_
radiobiologists19174266radiobiologists_
radiologists1497366_rad__iologists_
seismologists16124196sei_sm_ologists_
semiologist14410716___semiologist__
speleologists1654326sp__eleologists_
victimologists2262256_victimologists_
angelologists1553377_ange_lologists_
apologists1348887ap_____ologists_
astrobiologists1873767astrobiologists_
audiologist1347247_aud__iologist__
bacteriologist1963697bacteriologist__
biologists1349437_____biologists_
cardiologist1656617card__iologist__
cetologists1449167___ce_tologists_
climatologists1983287cli_matologists_
cosmetologists1953147cosme_tologists_
cosmologists1746417__cosm_ologists_
criminologist1863647cri__minologist__
cryobiologists2254107_cryobiologists_
demonologist1657057___demonologist__
dendrologists1654087___dendrologists_
deontologists1555927___deontologists_
dermatologists18134927___dermatologists_
diabetologists18122817_diabetologists_
dialectologists1992397dialectologists_
dialogists1265607___d__ialogists_
ecclesiologies19141997ecclesiologi_es_
ecologists13310927____e_cologists_
electrologists1765647e_lectrologists_
embryologists2153127e__mbryologists_
enologists11310627____e_nologists_
entomologist1556977e_ntom_ologist__
enzymologist2753837e_nzym_ologist__
epidemicities2062297epidemi_citi_es_
epidemicity2162007epidemi___ci_t_y
epiphytologies2561417epiphytologi_es_
epistemological22101947epistem_ologi_cal
epizootiologies2771257epizootiologi_es_
escapologists1853347e__scapologists_
ethnologists1647047e___thnologists_
ethologists1549027____ethologists_
etymologises18174737e__tym_ologises_
etymologist17158027e__tym_ologist__
exobiologist2256207e__xobiologist__
fetologists1547997___fe_tologists_
gemmologist1746547___gemmologist__
gemologist141010287___gem_ologist__
geologists1279167___ge__ologists_
glaciologists1753947__glaciologists_
gynecologists2053697_gyne_cologists_
hematologists19217057___hematologists_
herpetologists2083637herpe_tologists_
histologists1646297_hi__stologists_
hydrobiologists25134047hydrobiologists_
hydrologists2046097_hyd__rologists_
ideologies1237337__ide__ologi_es_
ideologizes2244197__ide__ologizes_
immunologists18124497__immunologists_
iridologist1345797irid___ologist__
kinesiologies1851837_kinesiologi_es_
kremlinologists22141397__kremlinologists_
lexicologists2374157lexi___cologists_
lichenologists2063037_lichenologists_
limnologist1446687_li__mnologist__
liturgiologists17141807liturgiologists_
malariologists1773357_malariologists_
meteorologists1754187_meteorologists_
metrologists1588837___metrologists_
microbiologists22134817microbiologists_
mineralogists1652317_mine_ralogists_
mixologists2145687_mi___xologists_
museologists1544747_muse__ologists_
myologists1648207_____myologists_
myrmecologists2452787myrme_cologists_
necrologists1547877___necrologists_
nematologists16166607___nematologists_
neologists1139777___ne__ologists_
nephrologists1954987nep___hrologists_
neurobiologists18114317neurobiologists_
neurologists1347647___neurologists_
nonbiologists1664727__nonbiologists_
numerologists1664017_nume_rologists_
oceanologists1654307__oceanologists_
osteologists1346767_oste__ologists_
paleobiologist19156347_paleobiologist__
paleoecologists20124177_paleoecologists_
paleontologists1884527_paleontologists_
paleozoologists2763857_paleozoologists_
palynologists1954997_p_alynologists_
papyrologists2154087_p_apyrologists_
parasitologists1862807_parasitologists_
pathologists1848377_p__athologists_
pedologist14410867_p__e_dologist__
penologist13412847_p__e_nologist__
petrologist14711887_p__etrologist__
pharmacologists2573647_pharmacologists_
philologists1876687_p__hilologists_
phonologists1848777_p__honologists_
photobiologists2365177photobiologists_
phraseologists2053577_phraseologists_
phrenologist1857917_phre_nologist__
phycologists2367137_p__hycologists_
physiologist21157327_p_hysiologist__
piccoloists1752777_pi__ccolo_ists_
planetologists1763627_planetologists_
pomologist15412047_p__om_ologist__
primatologists19184357_primatologists_
proctologists1856817_p_roctologists_
prologists13311177_p____rologists_
psephologist2056607_p_sephologist__
psychologists24127477_p_sychologists_
pteridologist17144607_p_teridologist__
radiobiologist18154677radiobiologist__
radiologist1399497_rad__iologist__
rheologists1547317__rhe__ologists_
sedimentologist1992117sedimentologist__
seismologist15125277sei_sm_ologist__
selenologists1455337_sele_nologists_
semiologies1448807___semiologi_es_
serologists12410127___se_rologists_
sexologists1947257___se_xologists_
sinologists1257677_si___nologists_
sociobiologists2063627sociobiologists_
sociologists1547947___sociologists_
speleologist1555747sp__eleologist__
teleologists1347227___teleologists_
tribologists1546167tri___bologists_
trichologists1955427tri__chologists_
vexillologists2591747vexi__llologists_
victimologist2162627_victimologist__
virologists1546637_vi___rologists_

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 Filter178691950240.406440125.6
2DLD Change Limit950241678.03011833.6
3Display Results1671670.1401192.9
 (SQL Overall)1786911678.57620836.2
 
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.