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

143 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
ecclesiologists2062351ecclesiologists_
ecclesiologist1962602ecclesiologist__
ecclesiologies19141993ecclesiologi_es_
ecclesiological1992314ecclesiologi_cal
bacteriologists2063255bacteriologists_
ecclesiology2081805ecclesiolog____y
epidemiologists2162495epidemiologists_
bacteriologist1963706bacteriologist__
cardiologists1765146__cardiologists_
cetologists1449166__c_e_tologists_
cosmologists1746416__c_osmologists_
cryobiologists2254106_cryobiologists_
dialectologists1992396dialectologists_
ecologists13310926e_c____ologists_
electrologists1765656e__lectrologists_
epidemiologist2062766epidemiologist__
escapologists1853346esc__apologists_
exclusionists2263336exclusi__onists_
exobiologists2355326e__xobiologists_
glaciologists1753946__glaciologists_
lexicologists2374156___lexicologists_
lichenologists2063036liche_nologists_
malariologists1773356_malariologists_
microbiologists22134816microbiologists_
oceanologists1654306_oc_eanologists_
paleobiologists20115736_paleobiologists_
physiologists22156016__physiologists_
selenologists1455336_sele_nologists_
semiologists1548226___semiologists_
sociobiologists2063626sociobiologists_
sociologists1547946soc___iologists_
speleologists1654326spele__ologists_
teleologists1347226_tele__ologists_
algologists1346147__al__gologists_
angelologists1553377_ange_lologists_
archaeologists20122817arc_haeologists_
astrobiologists1873767astrobiologists_
audiologists1445617___audiologists_
bacteriologies1952837bacteriologi_es_
biologists1349437_____biologists_
campanologists2152627_campanologists_
cardiologist1656627__cardiologist__
cetologist13412257__c_e_tologist__
chronologists1966117__chronologists_
climatologists1983287_climatologists_
conchologists2154567__conchologists_
cosmetologists1953147_cosmetologists_
cosmologist1648377__c_osmologist__
criminologists1952977_criminologists_
cryobiologist2154527_cryobiologist__
cryptologists2155237__cryptologists_
cytologists1748017__c__ytologists_
diabetologists18122817diabe_tologists_
dialectologist1882687dialectologist__
ecclesiastic1561487ecclesi____astic
ecclesiasticism208917ecclesi_asticism
ecclesiastics1671027ecclesi_asti_cs_
ecologist12314147e_c____ologist__
ecophysiologies2671307ecophysiologi_es_
electrologist1657057e__lectrologist__
embryologists2153127e__mbryologists_
enologists11310627____e_nologists_
entomologists1655667e__ntomologists_
enzymologists2873117e__nzymologists_
epidemiologies2062297epidemiologi_es_
epistemologists2072127epistemologists_
escapologist1754487esc__apologist__
ethnologists1647047e___thnologists_
ethologists1549027____ethologists_
etymologists18156497e___tymologists_
exclusionist2154097exclusi__onist__
exclusivists2461737exclusi___vists_
excursionists2282727excursi__onists_
exobiologist2256207e__xobiologist__
fetologists1547997___fe_tologists_
gemmologists1845237___gemmologists_
gemologists1577887___ge_mologists_
geologists1279167___ge__ologists_
glaciologist1654897__glaciologist__
gynecologists2053697_gyne_cologists_
herpetologists2083637herpe_tologists_
histologists1646297___histologists_
hydrobiologists25134047hydrobiologists_
ichthyologists2662317_ichthyologists_
ideologists1346657__ide__ologists_
kinesiologies1851837_kinesiologi_es_
lexicologist2294917___lexicologist__
lichenologist1973917liche_nologist__
limnologists1545327___limnologists_
liturgiologists17141807liturgiologists_
malacologists1854407_mal_acologists_
malariologist1693927_malariologist__
meteorologists1754187_meteorologists_
metrologists1588837___metrologists_
microbiologist21135497microbiologist__
museologists1544747___museologists_
musicologists1853547___musicologists_
mycologists1947737myc____ologists_
myrmecologists2452787myrme_cologists_
necrologists1547877___necrologists_
neologists1139777___ne__ologists_
neurobiologists18114317neurobiologists_
neurologists1347647___neurologists_
nonbiologists1664727__nonbiologists_
numerologists1664017_nume_rologists_
oceanologist1555687_oc_eanologist__
oncologists1448077onc____ologists_
osteologists1346767_oste__ologists_
paleobiologist19156347_paleobiologist__
paleoecologists20124177_paleoecologists_
paleontologists1884527_paleontologists_
paleozoologists2763857_paleozoologists_
palynologists1954997_pal_ynologists_
parasitologists1862817_parasitologists_
pedologists1548277___pe_dologists_
penologists1449597___pe_nologists_
petrologists1559147___petrologists_
philologists1876687phil___ologists_
photobiologists2365177photobiologists_
phraseologists2053577_phraseologists_
phrenologists1956297_phre_nologists_
physiologist21157327__physiologist__
planetologists1763627plane_tologists_
psephologists2155297__psephologists_
pteridologists18133727__pteridologists_
radiobiologists19174277radiobiologists_
radiologists1497377___radiologists_
rheologists1547317__rhe__ologists_
seismologists16124197__seismologists_
selenologist1357007_sele_nologist__
semiologist14410717___semiologist__
serologists12410127___se_rologists_
sexologists1947257___se_xologists_
sinologists1257677_____sinologists_
sociobiologist1964047sociobiologist__
sociologist1449887soc___iologist__
speleologist1555747spele__ologist__
technologists19125707tec__hnologists_
teleologist1249387_tele__ologist__
vexillologists2591747vexil__lologists_
victimologists2262257vic_timologists_
volcanologists20122767_volcanologists_
vulcanologists2092307_vulcanologists_

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 Filter178691950240.360496363.9
2DLD Change Limit950241438.56311097.0
3Display Results1431430.1101300.0
 (SQL Overall)1786911439.03319782.0
 
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.