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

82 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
musicologies175338(None) 
museologies1444542mus_eologies
musicologist1754282musicologist
musicologists1853542musicologists
audiologies1345623audi_ologies
autecologies1554573autecologies
codicologies1853673codicologies
lexicologies2253633lexicologies
malacologies1754383malacologies
misologies13139063m__isologies
missiologies1553313missiologies
mixologies20136583m__ixologies
musicalities1655823musicalities
musicological2053543musicological
musicology1853253musicolog__y
mycologies1848863m__ycologies
sinologies1148893__sinologies
sitologies1148703__sitologies
toxicologies2263753toxicologies
aetiologies1248984aeti_ologies
amphibologies2352414amphibologies
angiologies1346134angi_ologies
apiologies1339064_api_ologies
astrologies1247934_astrologies
axiologies1837484_axi_ologies
biologies12311184__bi_ologies
cosmologies1646704cos_mologies
ecologies12312354___ecologies
etiologies1139414_eti_ologies
futurologies1652424futurologies
glaciologies1663694glaciologies
gynecologies1953444gynecologies
hagiologies1645344hagi_ologies
histologies1546634his_tologies
iridologies1344594_iridologies
menologies13310604m__enologies
metrologies1449584m_etrologies
monologies13312544m__onologies
morphologies2044524morphologies
museologist1445804mus_eologist
museologists1544744mus_eologists
musicales1346704musical___es
musicalise1454614musical__ise
musicalises1554014musical_ises
musicalizes2454034musical_izes
myologies1539754m___yologies
myrmecologies2352434myrmecologies
mythologies2047844m_ythologies
nosologies1148104nos__ologies
nostologies1246584nos_tologies
numerologies1563424numerologies
oecologies1339464__oecologies
oinologies1148304__oinologies
oncologies1348654__oncologies
ophiologies1746014ophi_ologies
orismologies1553294orismologies
osteologies1247054_osteologies
philologies1747204_philologies
phycologies2247784_phycologies
physiologies2155364physi_ologies
posologies1349544pos__ologies
psychologies23127854_psychologies
radiologies1347814radi_ologies
rhinologies1546504_rhinologies
sarcologies1446434_sarcologies
seismologies1543904seismologies
semasiologies1652994semasi_ologies
semicolonies1653564semicolonies
semiologies1448804semi_ologies
serologies11311334__serologies
sexologies1837714__sexologies
sinologues1143744__sinologues
sociologies1447804__sociologies
subcolonies1553764su_bcolonies
synecologies1844164synecologies
tocologies1349764__tocologies
tribologies1446124_tribologies
trichologies1845574_trichologies
ufologies1345984_u__fologies
uranologies1246134_uranologies
urologies1039534_u__rologies
virologies1447214__virologies

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.750238254.7
2DLD Change Limit124790828.01615567.6
3Display Results82820.0461782.6
 (SQL Overall)178691828.81220278.1
 
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.