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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

88 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
malacologies175438(None) 
malacologist1755632malacologist
malacologists1854402malacologists
malariologies1652742malariologies
acarologies1446063_acarologies
algologies1246793_al_gologies
balneologies1553313balneologies
glaciologies1663693_glaciologies
malacological2053973malacological
malacology1853893malacolog__y
musicologies1753383musicologies
mycologies1848863m__ycologies
paleologies1448583pal_eologies
palynologies1844873palynologies
sarcologies1446433sa_rcologies
aerologies11312024_a_erologies
aetiologies1248984_aetiologies
agrologies1237694_a_grologies
analogies101910644_ana__logies
andrologies1346114_andrologies
anemologies1446924_anemologies
angiologies1346134_angiologies
anthologies151012014_anthologies
apiologies1339064_a_piologies
apologies12311194___apologies
areologies1139824_a_reologies
astrologies1247924_astrologies
audiologies1345624_audiologies
autecologies1554574autecologies
axiologies1837484_a_xiologies
campanologies2052464campanologies
cardiologies1644964cardiologies
carpologies1646404ca_rpologies
codicologies1853664codicologies
dialectologies1892084dialectologies
ecologies12312354___ecologies
escapologies1753224escapologies
garbologies1544884ga_rbologies
gynaecologies2052164gynaecologies
gynecologies1953444gynecologies
hagiologies1645344ha_giologies
haplologies1744764ha_plologies
hematologies1847564hematologies
karyologies1944444ka_ryologies
lexicologies2253634lexicologies
magalogues1452814maga__logues
malariologist1693924malariologist
malariologists1773354malariologists
mammalogies1552464ma_mmalogies
martyrologies1952334martyrologies
menologies13310604m__enologies
metrologies1449584m_etrologies
misologies13139064m__isologies
missiologies1553314missiologies
mixologies20136584m__ixologies
monologies13312544m__onologies
morphologies2044524morphologies
museologies1444544m_useologies
myologies1539754m___yologies
myrmecologies2352434myrmecologies
mythologies2047844m_ythologies
narratologies1452754narratologies
nematologies1546694nematologies
oceanologies1554234oceanologies
oecologies1339464__oecologies
oncologies1348654__oncologies
organologies1454084organologies
paleoecologies1963554paleoecologies
papyrologies2073604papyrologies
pathologies1748734pa_thologies
pharmacologies2463274pharmacologies
phlebologies2054654phlebologies
phycologies2247784_phycologies
radiologies1347804ra_diologies
scatologies1446864_scatologies
selenologies1345284selenologies
somatologies1546234somatologies
synecologies1844164synecologies
tautologies1245914ta_utologies
teleologies1247514tel_eologies
teratologies1346874teratologies
thanatologies1752834thanatologies
tocologies1349764__tocologies
toxicologies2263754toxicologies
uranologies1246134_uranologies
urbanologies1552964urbanologies
volcanologies1952344volcanologies
vulcanologies1951994vulcanologies

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 Filter1786911247900.423422437.4
2DLD Change Limit124790888.15615300.4
3Display Results88880.0461913.0
 (SQL Overall)178691888.62520717.8
 
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.