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

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

141 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
ecclesiologists206235(None) 
ecclesiologist1962601ecclesiologist_
ecclesiologies19141992ecclesiologi_es
ecclesiological1992313ecclesiological
bacteriologists2063254bacteriologists
ecclesiology2081804ecclesiolog___y
epidemiologists2162494epidemiologists
bacteriologist1963705bacteriologist_
cardiologists1765145__cardiologists
cetologists1449165__c_e_tologists
cosmologists1746415__c_osmologists
cryobiologists2254105_cryobiologists
dialectologists1992395dialectologists
ecologists13310925e_c____ologists
electrologists1765655e__lectrologists
epidemiologist2062765epidemiologist_
escapologists1853345esc__apologists
exclusionists2263335exclusi__onists
exobiologists2355325e__xobiologists
glaciologists1753945__glaciologists
lexicologists2374155___lexicologists
lichenologists2063035liche_nologists
malariologists1773355_malariologists
microbiologists22134815microbiologists
oceanologists1654305_oc_eanologists
paleobiologists20115735_paleobiologists
physiologists22156015__physiologists
selenologists1455335_sele_nologists
semiologists1548225___semiologists
sociobiologists2063625sociobiologists
sociologists1547945soc___iologists
speleologists1654325spele__ologists
teleologists1347225_tele__ologists
algologists1346146__al__gologists
angelologists1553376_ange_lologists
archaeologists20122816arc_haeologists
astrobiologists1873766astrobiologists
audiologists1445616___audiologists
bacteriologies1952836bacteriologi_es
biologists1349436_____biologists
campanologists2152626_campanologists
cardiologist1656626__cardiologist_
cetologist13412256__c_e_tologist_
chronologists1966116__chronologists
climatologists1983286_climatologists
conchologists2154566__conchologists
cosmetologists1953146_cosmetologists
cosmologist1648376__c_osmologist_
criminologists1952976_criminologists
cryobiologist2154526_cryobiologist_
cryptologists2155236__cryptologists
cytologists1748016__c__ytologists
diabetologists18122816diabe_tologists
dialectologist1882686dialectologist_
ecclesiastics1671026ecclesi_asti_cs
ecologist12314146e_c____ologist_
ecophysiologies2671306ecophysiologi_es
electrologist1657056e__lectrologist_
embryologists2153126e__mbryologists
enologists11310626____e_nologists
entomologists1655666e__ntomologists
enzymologists2873116e__nzymologists
epidemiologies2062296epidemiologi_es
epistemologists2072126epistemologists
escapologist1754486esc__apologist_
ethnologists1647046e___thnologists
ethologists1549026____ethologists
etymologists18156496e___tymologists
exclusionist2154096exclusi__onist_
exclusivists2461736exclusi___vists
excursionists2282726excursi__onists
exobiologist2256206e__xobiologist_
fetologists1547996___fe_tologists
gemmologists1845236___gemmologists
gemologists1577886___ge_mologists
geologists1279166___ge__ologists
glaciologist1654896__glaciologist_
gynecologists2053696_gyne_cologists
herpetologists2083636herpe_tologists
histologists1646296___histologists
hydrobiologists25134046hydrobiologists
ichthyologists2662316_ichthyologists
ideologists1346656__ide__ologists
kinesiologies1851836_kinesiologi_es
lexicologist2294916___lexicologist_
lichenologist1973916liche_nologist_
limnologists1545326___limnologists
liturgiologists17141806liturgiologists
malacologists1854406_mal_acologists
malariologist1693926_malariologist_
meteorologists1754186_meteorologists
metrologists1588836___metrologists
microbiologist21135496microbiologist_
museologists1544746___museologists
musicologists1853546___musicologists
mycologists1947736myc____ologists
myrmecologists2452786myrme_cologists
necrologists1547876___necrologists
neologists1139776___ne__ologists
neurobiologists18114316neurobiologists
neurologists1347646___neurologists
nonbiologists1664726__nonbiologists
numerologists1664016_nume_rologists
oceanologist1555686_oc_eanologist_
oncologists1448076onc____ologists
osteologists1346766_oste__ologists
paleobiologist19156346_paleobiologist_
paleoecologists20124176_paleoecologists
paleontologists1884526_paleontologists
paleozoologists2763856_paleozoologists
palynologists1954996_pal_ynologists
parasitologists1862816_parasitologists
pedologists1548276___pe_dologists
penologists1449596___pe_nologists
petrologists1559146___petrologists
philologists1876686phil___ologists
photobiologists2365176photobiologists
phraseologists2053576_phraseologists
phrenologists1956296_phre_nologists
physiologist21157326__physiologist_
planetologists1763626plane_tologists
psephologists2155296__psephologists
pteridologists18133726__pteridologists
radiobiologists19174276radiobiologists
radiologists1497376___radiologists
rheologists1547316__rhe__ologists
seismologists16124196__seismologists
selenologist1357006_sele_nologist_
semiologist14410716___semiologist_
serologists12410126___se_rologists
sexologists1947256___se_xologists
sinologists1257676_____sinologists
sociobiologist1964046sociobiologist_
sociologist1449886soc___iologist_
speleologist1555746spele__ologist_
technologists19125706tec__hnologists
teleologist1249386_tele__ologist_
vexillologists2591746vexil__lologists
victimologists2262256vic_timologists
volcanologists20122766_volcanologists
vulcanologists2092306_vulcanologists

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.376475242.0
2DLD Change Limit950241418.36011366.5
3Display Results1411410.1101281.8
 (SQL Overall)1786911418.84620200.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.