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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

125 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
nematologies154669(None) 
hematologies1847561hematologies
dermatologies1755252dermatologies
nematologist15208472nematologist
nematologists16166602nematologists
neonatologies1453822neonatologies
onomatologies1653382onomatologies
pneumatologies1962812pneumatologies
somatologies1546232somatologies
teratologies1346872teratologies
anemologies1446923anem__ologies
cetologies13410853ce__tologies
climatologies1852803climatologies
demonologies1645503demonologies
deontologies1445413deontologies
fetologies1439183fe__tologies
gemmologies1745243gem_mologies
gemologies1449003gem__ologies
hematologic1956353hematologi_c
hematologist18219203hematologist
hematologists19217053hematologists
narratologies1452753narratologies
necrologies1447983ne_crologies
nematological1855663nematological
nematology16125203nematolog__y
neologies10411713ne___ologies
nephologies1747353ne_phologies
nephrologies1845073nephrologies
neurologies1248233ne_urologies
nomologies1339473nom__ologies
nostologies1246583n_ostologies
numerologies1563423numerologies
primatologies1863873primatologies
rheumatologies2062473rheumatologies
scatologies1446863_scatologies
semasiologies1652993semasiologies
semeiologies1545303semeiologies
semiologies1448803sem_iologies
acarologies1446064_acarologies
aerologies11312024ae__rologies
aetiologies1248984ae_tiologies
apologies12311194___apologies
campanologies2052464campanologies
cosmetologies1852924cosmetologies
cryptologies2055424cryptologies
cytologies1639264__cytologies
demagogies1593674dema__gogies
demythologizes33112624demythologizes
dendrologies1553794dendrologies
dermatologic1854494dermatologi_c
dermatologist1786464dermatologist
dermatologists18134924dermatologists
ecologies12312354_e__cologies
embryologies2053164_embryologies
enologies10312984_e__nologies
entomologies1575324entomologies
enzymologies2752954enzymologies
escapologies1753224escapologies
eschatologies1952634eschatologies
ethnologies1547984_ethnologies
ethologies14310544_e_thologies
etiologies1139414_e_tiologies
etymologies17176804_etymologies
geologies11410644ge___ologies
gerontologies1584434gerontologies
hematological2155944hematological
hematology1995774hematolog__y
herbologies1746564he_rbologies
herpetologies1953464herpetologies
histologies1546634_histologies
homologies16311524hom__ologies
hymnologies2046104hym_nologies
immunologies1774304immunologies
lexicologies2253634lexicologies
limnologies1445534lim_nologies
malacologies1754374malacologies
menologies13310604__menologies
metrologies1449584me_trologies
misologies13139064__misologies
mixologies20136584__mixologies
monologies13312544__monologies
mycologies1848864__mycologies
myologies1539754__m_yologies
mythologies2047844__mythologies
nematocides16113134nemato_cides
nematodes1254734nemat__o_des
neologizes2047244ne___ologizes
neonatologist14135354neonatologist
neonatologists1584194neonatologists
nosologies1148104n__osologies
oceanologies1554234oceanologies
oecologies1339464oe__cologies
oenologies1139394oe__nologies
onomatologist1654404onomatologist
onomatologists1753334onomatologists
ontologies1139884__ontologies
organologies1454084organologies
otologies10311404___otologies
pathologies1748734__pathologies
pedologies1439344pe__dologies
penologies13311234pe__nologies
petrologies1449894pe_trologies
phytologies2049044_phytologies
pomologies15310044pom__ologies
proctologies1746314proctologies
remythologizes3282504remythologizes
seismologies1543904seismologies
selenologies1345284selenologies
semicolonies1653564semicolonies
serologies11311334se__rologies
sexologies1837714se__xologies
sitologies1148704__sitologies
symbologies1945174sym_bologies
tautologies1245914_tautologies
technologies1845974technologies
teleologies1247514te_leologies
teratologic1455654teratologi_c
teratologist13108574teratologist
teratologists1496594teratologists
terminologies1653444terminologies
thanatologies1752834thanatologies
uranologies1246134_uranologies
urbanologies1552964urbanologies
venologies1438374ve__nologies
zymologies2546414zym__ologies

Search took 8 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.390458182.1
2DLD Change Limit1247901257.26317181.6
3Display Results1251250.0801562.5
 (SQL Overall)1786911257.73323107.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.