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

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

99 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
myrmecological266264(None) 
gynecological22113783gy_necological
mycological2147113my___cological
myrmecologies2352433myrmecologi_es
myrmecologist2353313myrmecologi_st
myrmecologists2452783myrmecologists
synecological21104113sy_necological
autecological1854414_autecological
dermatological2053854dermatological
ecological1548704____ecological
herpetological2253304herpetological
malacological2053974m_alacological
morphological2353944mor_phological
museological1754774m_use_ological
musicological2053544m_usicological
myrmecology2462084myrmecolog___y
mythological2346884my__thological
numerological1854014_numerological
pharmacological2793514pharmacological
phrenological2156304phr_enological
rheological17127454__rhe_ological
terminological1953644terminological
unecological1745824__unecological
aerobiological1955095aerobiological
bryological1945375_br__yological
cardiological1954965car_diological
chronological2175925chr_onological
climatological2162615climatological
codicological1853875_codicological
cosmological1946065cosm__ological
criminological21102775criminological
cryobiological2463885cryobiological
cryptological2354795_cryptological
cytological1947435cy___tological
demonological1954945_demonological
dialectological2162095dialectological
embryological2353185embr__yological
enological1348885____enological
etymological2045855etym__ological
gemological1747015___gemological
geological1448065___ge_ological
gerontological1854155gerontological
graphological2253525_graphological
gynecologic2052635gy_necologic__
hematological2155925_hematological
homological1948415_hom__ological
horological1748255hor___ological
hydrobiological2763545hydrobiological
hydrological2246465hy__drological
ideological15106635__ide_ological
immunological2054015_immunological
karyological2274735kar__yological
lichenological22112835lichenological
limnological1745075_lim_nological
meteorological1953765meteorological
methodological2353285methodological
metrological1748355m__etrological
microbiological2464335microbiological
mineralogical1862285m_ineralogical
mycologic1946945my___cologic__
mycologically2655435my___cologically
narratological1763095narratological
necrological1747285___necrological
nematological1855665_nematological
nomological1648055_nom__ological
oncological1647235___oncological
orismological1853605_orismological
osteological1546345_oste_ological
paleoecological2263525paleoecological
pedological1757595___pedological
penological1648855___penological
phenological2068025__phenological
phraseological2283665phraseological
phycological2546915__phycological
planetological1953155planetological
pomological1848005_pom__ological
praxeological2554415_praxeological
prebiological2055935_prebiological
precolonial1554255_pr_ecoloni_al
prelogical1546685_pr_e__logical
primatological2183195primatological
proctological2055795_proctological
radiological1646975__radiological
selenological1654665_selenological
semiological1747775_sem_iological
serological1468775___serological
somatological1854855_somatological
speleological1853905spele_ological
stereological1655655stere_ological
teleological1546555_tele_ological
teratological1656115ter_atological
theological1798245__the_ological
toxicological2553955_toxicological
tribological1745955_tr_ibological
tropological1746615_tr_opological
typological1946665ty___pological
unideological1763325unide_ological
urological1347755_ur___ological
virological1746305vir___ological

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 Filter178691950240.1101624463.6
2DLD Change Limit95024996.97013633.3
3Display Results99990.0601650.0
 (SQL Overall)178691997.14025026.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.