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

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

115 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
macroscopically2561841macroscopically_
microscopically2572082microscopically_
gyroscopically2762234_gyroscopically_
macrocosmically2592094macro_cosmically_
microscopical2063354microscopica_l__
acrostically1968395_acros__tically_
endoscopically2472025_endoscopically_
macroscopic1855035macroscopic_____
megascopically2661845m_egascopically_
microcosmically2572115micro_cosmically_
acrobatically2255746_acro_batically_
acronymically2553546_acro_nymically_
agronomically2184706_agro_nomically_
metronomically2354556metro_nomically_
microphysically32132506microphysically_
microscopic1856386microscopic_____
mycologically2655436myc_o_logically_
narcotically1947386na_r__cotically_
prosodically2056586__pros_odically_
telescopically2361966_telescopically_
achromatically2654697_achro_matically_
acoustically1946547_ac_o_ustically_
acropetally1852687_acr___opetally_
acrostical1445837_acros__tica_l__
aerobically1848117_aer___obically_
aeronautically1954227_aeronautically_
alcoholically2353457_alco_holically_
allosterically1962747_allosterically_
allotypically2382687_allo_typically_
ambrosially1852107ambros___i_ally_
anisotropically2292317anisotropically_
aoristically1749367_aoris__tically_
apotropaically2362987_a_potropaically_
archaically2145827_a_r__chaically_
arctically17410377_a_r__c_tically_
aromatically19410667_a_ro_matically_
ascetically1848407_a___scetically_
astrologically2055437astro_logically_
astronomically2163907astro_nomically_
autonomically2054897_auto_nomically_
autotrophically2562817_autotrophically_
axiologically2655277_axio_logically_
barometrically2353927ba_rometrically_
cosmetically2147937__c_osmetically_
cosmically1948027__c_os__mically_
ecologically2067727_ec_o_logically_
economically2156807_ec_o_nomically_
ectopically2047127_ec___topically_
entropically1977827entr___opically_
farcically2046327fa_r__c__ically_
gastronomically2362277gastro_nomically_
geotropically2154927__geotropically_
harmonically2255767ha_r__monically_
hydrologically27104507hydro_logically_
hydroponically2863207hydro_ponically_
hydrostatically2762477hydrostatically_
hygroscopicity3071027hygroscopic_ity_
iatrogenically20103447iatro_genically_
isosmotically2053947__isosmotically_
isotopically1955377__iso_topically_
karyotypically2781467ka_ryotypically_
laconically1846537la____conically_
macroscale1654117macros____ca_l_e
macroscales1753857macros____ca_les
majestically2665407ma_jes__tically_
manometrically2354037ma_nometrically_
matrimonially2072047matr_imoni_ally_
meristically1949017m_eris__tically_
microcephaly26103417micro_cep_ha_ly_
micrococcal1553877micro_co_cca_l__
microscopies20167247microscopi____es
microscopist2055647microscopi____st
microscopists2164067microscopi___sts
microscopy21115847microscop_____y_
microsurgical2062467microsurgica_l__
microtonally1953577micro_to__nally_
monodically1946797m___o_nodically_
monophonically2663417m_onophonically_
monotonically2055327m_ono_tonically_
moronically1849107m___o_ronically_
mosaically1747427m___os__aically_
motorically1849437m___o_torically_
myopically2246177m_____yopically_
mythologically28154957mytho_logically_
necromantically2463047necromantically_
neurologically2074967neuro_logically_
osmotically1847777____osmotically_
parabiotically2374127pa_rabiotically_
parabolically2254007pa_r_abolically_
paradoxically2853717pa_r_adoxically_
paranoically1956557pa_r_ano_ically_
parasitically2056807pa_ras_itically_
parochially2153187pa_ro_c_hi_ally_
participially2271947pa_rticipi_ally_
pathologically2585557patho_logically_
patriotically2057017patr__iotically_
petrologically2256067petro_logically_
philosophically3072357philos_ophically_
phototropically2763377phototropically_
prosaically1847847__pros__aically_
radiologically2174547radio_logically_
robotically1868517___ro_botically_
saprophytically3062237saprophytically_
sarcastically2055617sarcas__tically_
sardonically1855297sa_r__donically_
seriocomically2373107_seriocomically_
serologically1957127_sero_logically_
sociologically2254757socio_logically_
tautologically2094177tauto_logically_
taxonomically2753157ta_xo_nomically_
theosophically2763167_theos_ophically_
thrasonically2153417_thras_onically_
tropically1749847__tr___opically_
ultrasonically1972777ultras_onically_
virologically2255167_viro_logically_

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 Filter178691950240.356501941.0
2DLD Change Limit950241158.00011878.0
3Display Results1151150.0801437.5
 (SQL Overall)1786911158.43621182.0
 
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.