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

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
lichenologies195291(None) 
ichnologies1746362_ich_nologies
lichenologist1973912lichenologist
lichenologists2063032lichenologists
archeologies1845003arche_ologies
iconologies1447093_ic_onologies
lichenological22112833lichenological
lichenology2052383lichenolog__y
limnologies1445533li__mnologies
lithologies1546833lith__ologies
phenologies1749353__phenologies
technologies1845973tech_nologies
archaeologies1952824archaeologies
cetologies13410854__c_etologies
chronologies1846414__chronologies
enologies10312984____enologies
eschatologies1952634eschatologies
ethnologies1547984_eth_nologies
hierologies1547064hi__erologies
ichthyologies2552294_ichthyologies
ideologies1237334_i_de_ologies
immunologies1774304_immunologies
menologies13310604___menologies
oceanologies1554234_oceanologies
oenologies1139394___oenologies
oinologies1148304oi___nologies
penologies13311234___penologies
phonologies17410004__phonologies
phrenologies1846314_phrenologies
poenologies1448324__poenologies
rheologies1488434__rhe_ologies
rhinologies1546504__rhinologies
selenologies1345284_selenologies
sinologies1148894si___nologies
technologizes2853424tech_nologizes
theologies141010104__the_ologies
trichologies1845574trich__ologies
venologies1438374___venologies
victimologies2151764victimologies
acarologies1446065_ac_arologies
aerologies11312025___aerologies
amphibologies2352415amphibologies
anemologies1446925__anemologies
angelologies1453015_angelologies
anthologies151012015anth__ologies
areologies1139825__are_ologies
autecologies1554575_autecologies
bacteriologies1952825bacteriologies
balneologies1553315balne_ologies
bibliologies1753375bi_bliologies
biologies12311185bi____ologies
biotechnologies2381265biotechnologies
campanologies2052465campanologies
carpologies1646405__carpologies
climatologies1852805cli_matologies
cohomologies2054055_cohomologies
conchologies2054565conch__ologies
coprologies1646945__coprologies
cosmetologies1852925cosmetologies
cosmologies1646705__cosmologies
craniologies1545375__craniologies
criminologies1852955criminologies
cytologies1639265__c_ytologies
dactylologies2051805dactylologies
demonologies1645505_demonologies
dialectologies1892085dialectologies
dichotomies1994985dich__otomies
ecclesiologies19141995ecclesiologies
ecologies12312355____ecologies
electrologies1656255elec_trologies
epiphytologies2561415epiphytologies
epistemologies1962035epistemologies
escapologies1753225esc_apologies
ethologies14310545_eth__ologies
fetologies1439185___fetologies
gemologies1449005___gemologies
geochronologies2261995geochronologies
geologies11410645___ge_ologies
glaciologies1663685glac__iologies
gynaecologies2052165gynaecologies
gynecologies1953445_gynecologies
herbologies1746565___herbologies
herpetologies1953465herpetologies
histologies1546635hi__stologies
homologies16311525___homologies
horologies14411055___horologies
hymnologies2046105__hymnologies
hypnologies2046085__hypnologies
ichnolites1544045_ich_nol_ites
ichnology1844995_ich_nolog__y
idealogies1244195_i_de_alogies
ideologizes2244195_i_de_ologizes
ideologues1243195_i_de_ologues
iridologies1344585_i_ridologies
kinesiologies1851835kinesiologies
laryngologies18122145laryngologies
lexicologies2253635l_exicologies
lichenins1444845lichen____ins
lichenose1443365lichen__o_se_
lichenous1444315lichen__o__us
limnologic1553535li__mnologi_c
limnologist1446685li__mnologist
limnologists1545325li__mnologists
lithologic1645015lith__ologi_c
lithotomies1654205lith__otomies
liturgiologies1661215liturgiologies
methodologies2053485methodologies
microbiologies2164985microbiologies
mineralogies15102985mi_neralogies
misologies13139065mi___sologies
missiologies1553315mi_ssiologies
mixologies20136585mi___xologies
monologies13312545___monologies
museologies1444545_muse_ologies
mycologies1848865myc___ologies
myrmecologies2352435myrmecologies
mythologies2047845myth__ologies
necrologies1447985nec__rologies
neologies10411715___ne_ologies
nephologies1747355neph__ologies
nephrologies1845075neph_rologies
numerologies1563425_numerologies
oecologies1339465___oecologies
oncologies1348655onc___ologies
ophiologies1746015_oph_iologies
organologies1454085_organologies
osteologies1247055_oste_ologies
paleologies1448585_pale_ologies
palynologies1844875_palynologies
pathologies1748735path__ologies
pedologies1439345___pedologies
phenocopies2055865__phenocopies
philologies1747205__philologies
phlebologies2054655_phlebologies
phycologies2247785__phycologies
phytologies2049045__phytologies
planetologies1653255planetologies
praxeologies2293825praxe_ologies
psychologies23127855psych__ologies
reflexologies2451815reflexologies
scatologies1446865_sc_atologies
semeiologies1545305_semeiologies
serologies11311335___serologies
sexologies1837715___sexologies
sinologues1143745si___nologues
sitologies1148705si___tologies
sociologies1447805soc__iologies
speleologies1553885spele_ologies
stereologies1345915stere_ologies
synecologies1844165_synecologies
technologic1954485tech_nologi_c
technologist18137405tech_nologist
technologists19125705tech_nologists
technologize2753445tech_nologize
technologized2962625tech_nologized
teleologies1247515_tele_ologies
terminologies1653445terminologies
theologise14117745__the_ologise
theologises15106735__the_ologises
theologizes24106065__the_ologizes
theologues14124405__the_ologues
tocologies1349765toc___ologies
uranologies1246135__uranologies
urbanologies1552965_urbanologies
virologies1447215vi___rologies
volcanologies1952345volcanologies
vulcanologies1951995vulcanologies

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 Filter1786911247900.393454684.5
2DLD Change Limit1247901679.29613424.1
3Display Results1671670.1101518.2
 (SQL Overall)1786911679.79918235.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.