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

118 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
ecclesiological199231(None) 
ecclesiologies19141993ecclesiologi_es
ecclesiologist1962603ecclesiologi_st
ecclesiologists2062353ecclesiologists
bacteriological2282864bacteriological
ecclesiastical177974ecclesi_astical
ecclesiology2081804ecclesiolog___y
epidemiological23172604epidemiological
cardiological1954975__cardiological
cosmological1946085__c_osmological
cryobiological2463925_cryobiological
dialectological2162095dialectological
ecological1548705e_c____ological
eschatological2262465esc_hatological
etiological1448415____etiological
exobiological2554725e__xobiological
glaciological1963915__glaciological
lichenological22112835liche_nological
microbiological2464375microbiological
paleobiological2264735_paleobiological
physiological2455575__physiological
prebiological2055975__prebiological
selenological1654665_sele_nological
semasiological1983015_semasiological
semiological1747785___semiological
sociobiological2273515sociobiological
sociological1747505soc___iological
soteriological1763895_soteriological
speleological1853915spele__ological
teleological1546575_tele__ological
abiological1647836____abiological
aerobiological1955136_aerobiological
algological1545976__al__gological
archaeological22152936arc_haeological
audiological1665666___audiological
autecological1854436_aute_cological
axiological2146876____axiological
bacteriologic2062346bacteriologic__
biological15128886_____biological
chronological2175956__chronological
climatological2162616_climatological
codicological1853896__codicological
cohomological2354086__cohomological
criminological21102776_criminological
cryptological2354796__cryptological
cytological1947456__c__ytological
ecclesial1353586eccles_____i_al
ecclesiastic1561486ecclesi_astic__
ecclesiastics1671026ecclesi_astic_s
embryological2353186e__mbryological
enological1348886____e_nological
entomological1855036e__ntomological
epidemiologic2162006epidemiologic__
epistemological22101946epistemological
ethnological1846816e___thnological
ethological1748196____ethological
etymological2045876e___tymological
gemological1747026___ge_mological
geological1448076___ge__ological
gynecological22113786_gyne_cological
hagiological1955816___hagiological
herpetological2253326herpe_tological
histological1846086___histological
hydrobiological2763586hydrobiological
ichthyological2882456_ichthyological
iconological1756026_ic__onological
ideological15106646__ide__ological
limnological1745076___limnological
lithological1845896___lithological
malacological2053976_mal_acological
meteorological1953786_meteorological
metrological1748376___metrological
museological1754786___museological
musicological2053546___musicological
mycological2147116myc____ological
myrmecological2662646myrme_cological
necrological1747286___necrological
neurobiological20123926neurobiological
neurological1547336___neurological
nonbiological1855266__nonbiological
nosological1447376___nos_ological
numerological1854016_nume_rological
oncological1647256onc____ological
orismological1853626__orismological
osteological1546376_oste__ological
paleoecological2263556_paleoecological
paleontological2063846_paleontological
paleozoological2963266_paleozoological
palynological2154676_pal_ynological
parasitological2062776_parasitological
pedological1757616___pe_dological
penological1648876___pe_nological
petrological1758596___petrological
phenological2068056__phe_nological
philological2046376phil___ological
photobiological2564456photobiological
phraseological2283696_phraseological
phrenological2156336_phre_nological
planetological1953176plane_tological
praxeological2554436praxe__ological
psephological2354986__psephological
pteridological2053596__pteridological
radiobiological2163346radiobiological
radiological1646986___radiological
rheological17127476__rhe__ological
scatological1745546_sc__atological
seismological1873966__seismological
serological1468776___se_rological
sinological1447136_____sinological
stereological1655676__stereological
synecological21104116_syne_cological
technological2155146tec__hnological
theological1798266__the__ological
unchronological2362326unchronological
unecological1745826__une_cological
unideological1763336unide__ological
vexillological2761686vexil__lological
volcanological2262226_volcanological

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.356501941.0
2DLD Change Limit950241187.90612019.2
3Display Results1181180.0961229.2
 (SQL Overall)1786911188.35821379.6
 
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.