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

98 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
numerologies156342(None) 
numerologist1574912numerologist
numerologists1664012numerologists
aerologies11312023__aerologies
autecologies1554573autecologies
futurologies1652423futurologies
hierologies1547063_hierologies
menologies13310603__menologies
metrologies1449583__metrologies
museologies1444543muse_ologies
necrologies1447993n_ecrologies
nematologies1546693nematologies
neologies10411723n__e_ologies
nephrologies1845073nephrologies
neurologies1248243n_eurologies
nomologies1339473nom__ologies
numerological1854013numerological
numerology1643143numerolog__y
semeiologies1545303semeiologies
serologies11311333__serologies
urologies1039533_u__rologies
acarologies1446064_acarologies
agrologies1237694__agrologies
andrologies1346114_andrologies
anemologies1446924_anemologies
angelologies1453014angelologies
areologies1139824_are_ologies
astrologies1247934_astrologies
audiologies1345624au_diologies
cetologies13410854__cetologies
coprologies1646944_coprologies
cosmetologies1852924cosmetologies
demonologies1645504demonologies
dendrologies1553794dendrologies
ecologies12312354___ecologies
embryologies2053164_embryologies
enologies10312984___enologies
fetologies1439184__fetologies
gemmologies1745244gem_mologies
gemologies1449004__gemologies
geologies11410644__ge_ologies
gynecologies1953444gynecologies
hematologies1847564hematologies
herbologies1746564__herbologies
homologies16311534hom__ologies
horologies14411054__horologies
hydrologies1948184_hydrologies
hymnologies2046104hym_nologies
ideologies1237334_ide_ologies
immunologies1774304immunologies
limnologies1445534lim_nologies
meteorologies1653584meteorologies
mineralogies15102984mineralogies
misologies13139064__misologies
mixologies20136584__mixologies
monologies13312544__monologies
musicologies1753384musicologies
mycologies1848864__mycologies
myologies1539754__m_yologies
myrmecologies2352434myrmecologies
neologizes2047244n__e_ologizes
nephologies1747354n_ephologies
nosologies1148104n__osologies
nostologies1246584n_ostologies
numeracies1444904numer__acies
oecologies1339464__oecologies
oenologies1139394__oenologies
onomatologies1653384onomatologies
orologies10311624___orologies
osteologies1247054oste_ologies
paleologies1448584pale_ologies
papyrologies2073604papyrologies
pedologies1439344__pedologies
penologies13311234__penologies
petrologies1449894_petrologies
phenologies1749354_phenologies
phlebologies2054654phlebologies
phrenologies1846314phrenologies
pneumatologies1962814pneumatologies
poenologies1448324_poenologies
pomologies15310044pom__ologies
pyrologies16310014__pyrologies
rheologies1488434_rhe_ologies
selenologies1345284selenologies
semiologies1448804sem_iologies
sexologies1837714__sexologies
somatologies1546234somatologies
soteriologies1453874soteriologies
stereologies1345914_stereologies
symbologies1945174sym_bologies
synecologies1844164synecologies
teleologies1247514tele_ologies
theologies141010104_the_ologies
ufologies1345984_u__fologies
uranologies1246134_uranologies
venologies1438374__venologies
virologies1447214__virologies
zymologies2546414zym__ologies

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 Limit124790987.67316263.5
3Display Results98980.0631555.6
 (SQL Overall)178691988.15921901.1
 
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.