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

120 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
selenologies134528(None) 
selenologist1357002selenologist
selenologists1455332selenologists
semeiologies1545302semeiologies
speleologies1553882spele_ologies
teleologies1247512tele_ologies
balneologies1553313balneologies
demonologies1645503demonologies
enologies10312983___enologies
ethnologies1547983_ethnologies
menologies13310603__menologies
oenologies1139393__oenologies
paleologies1448583pale_ologies
palynologies1844873palynologies
penologies13311233__penologies
phenologies1749353_phenologies
phlebologies2054653phlebologies
phrenologies1846313phrenologies
poenologies1448323_poenologies
reflexologies2451813reflexologies
seismologies1543903seismologies
selenological1654663selenological
selenology1444223selenolog__y
semiologies1448803se_miologies
serologies11311333s__erologies
sexologies1837713s__exologies
sinologies1148893s__inologies
stereologies1345913stere_ologies
synecologies1844163synecologies
technologies1845973technologies
venologies1438373__venologies
aerologies11312024__aerologies
aetiologies1248984ae_tiologies
algologies1246794_al_gologies
anemologies1446924_anemologies
angelologies1453014angelologies
areologies1139824_are_ologies
autecologies1554574autecologies
cetologies13410854__cetologies
chronologies1846414chronologies
dendrologies1553794dendrologies
deontologies1445414deontologies
ecologies12312354___ecologies
electrologies1656264_electrologies
escapologies1753224escapologies
ethologies14310544_e_thologies
etiologies1139414_e_tiologies
etymologies17176804_etymologies
fetologies1439184__fetologies
gemmologies1745244ge_mmologies
gemologies1449004__gemologies
genealogies1353574gene_alogies
geologies11410644__ge_ologies
gerontologies1584434gerontologies
gynecologies1953444gynecologies
hematologies1847564hematologies
herbologies1746564he_rbologies
herpetologies1953464herpetologies
hierologies1547064_hierologies
hymnologies2046104_hymnologies
hypnologies2046084_hypnologies
ichnologies1746364_ichnologies
iconologies1447094_iconologies
ideologies1237334_ide_ologies
immunologies1774304immunologies
kremlinologies2161494kremlinologies
lexicologies2253634lexicologies
lichenologies1952914lichenologies
limnologies1445534_limnologies
malacologies1754384malacologies
meteorologies1653584meteorologies
metrologies1449584me_trologies
monologies13312544__monologies
museologies1444544muse_ologies
necrologies1447994ne_crologies
nematologies1546694nematologies
neologies10411724__ne_ologies
nephologies1747354ne_phologies
nephrologies1845074nephrologies
neurologies1248244ne_urologies
numerologies1563424numerologies
oceanologies1554234oceanologies
oecologies1339464__oecologies
oinologies1148304__oinologies
organologies1454084organologies
osteologies1247054oste_ologies
paleontologies17103884paleontologies
pedologies1439344__pedologies
petrologies1449894pe_trologies
phonologies17410004_phonologies
psephologies2044844pse_phologies
rheologies1488434_rhe_ologies
rhinologies1546504_rhinologies
sarcologies1446434s_arcologies
scatologies1446864s_catologies
sedimentologies1961554sedimentologies
selenoses947464selen__o_ses
selenosis945444selen__osi_s
semasiologies1652994semasiologies
semicolonies1653564semicolonies
sinologues1143744s__inologues
sitologies1148704s__itologies
sociologies1447804s_ociologies
somatologies1546234somatologies
soteriologies1453874soteriologies
speleologist1555744spele_ologist
speleologists1654324spele_ologists
symbologies1945174s_ymbologies
technologizes2853424technologizes
teleologic1375374tele_ologi_c
teleologist1249384tele_ologist
teleologists1347224tele_ologists
teleonomies1354684tele_onomies
teratologies1346874teratologies
terminologies1653444terminologies
theologies141010104_the_ologies
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.406440125.6
2DLD Change Limit1247901207.51316609.9
3Display Results1201200.0801500.0
 (SQL Overall)1786911207.99922339.2
 
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.