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

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

100 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
microscopically2572081microscopically_
macroscopically2561842macroscopically_
microscopical2063353microscopica_l__
gyroscopically2762234_gyroscopically_
microcosmically2572114micro_cosmically_
endoscopically2472025_endoscopically_
macrocosmically2592095macro_cosmically_
megascopically2661845m_egascopically_
microphysically32132505microphysically_
microscopic1856385microscopic_____
acrostically1968396_acros__tically_
isosmotically2053946_i_sosmotically_
isotopically1955376_i_so_topically_
macroscopic1855036macroscopic_____
metronomically2354556metro_nomically_
microcephaly26103416micro_cep_ha_ly_
micrococcal1553876micro_co_cca_l__
microscopies20167246microscopi____es
microscopist2055646microscopi____st
microscopists2164066microscopi___sts
microscopy21115846microscop_____y_
microsurgical2062466microsurgica_l__
microtonally1953576micro_to__nally_
mycologically2655436myc_o_logically_
prosodically2056586__pros_odically_
telescopically2361966_telescopically_
virologically2255166vi_ro_logically_
acrobatically2255747_acro_batically_
acronymically2553547_acro_nymically_
agronomically2184707_agro_nomically_
alcoholically2353457alc_o_holically_
anisotropically2292317anisotropically_
astrologically2055437astro_logically_
astronomically2163907astro_nomically_
biologically2067057bi__o_logically_
biosocially1852747bi__os_oci_ally_
cosmetically2147937__c_osmetically_
cosmically1948027__c_os__mically_
dichotically2356227dic___hotically_
ecologically2067727_ec_o_logically_
economically2156807_ec_o_nomically_
ectopically2047127_ec___topically_
entropically1977827entr___opically_
geotropically2154927__geotropically_
hierarchically2762217hierarc_hically_
histologically2364317histo_logically_
historically2056467hi___storically_
hydrologically27104507hydro_logically_
hydroponically2863207hydro_ponically_
hydrostatically2762477hydrostatically_
hygroscopicity3071027hygroscopic_ity_
iconically1769277_i____conically_
ideologically2055037_ideo_logically_
impractically2454367impr_ac_tically_
ironically151110547_i_r___onically_
isentropically2162697_isentropically_
isostatically1855007_i_sostatically_
isotonically1756057_i_so_tonically_
lithologically2364067litho_logically_
meristically1949017m_eris__tically_
miasmically2045057mi__as__mically_
microcephalic2363637micro_cep_ha_lic
microcephalics2482957micro_cep_halics
microcephalies2573417micro_cep_halies
microcopies19117857micro_copi____es
microcopy2085497micro_cop_____y_
microphysical2763187microphysica_l__
microscale1646397micros____ca_l_e
microscales1756377micros____ca_les
microscope18138577microscop______e
microscopes19119097microscop_____es
microsomal1655927micros_o__ma_l__
microspherical2582447microspherica_l__
microsporangia2171547micros__porangia
mineralogically2372377mineralogically_
mitotically1849127mi____totically_
monodically1946797m___o_nodically_
monophonically2663417m_onophonically_
monotonically2055327m_ono_tonically_
moronically1849107m___o_ronically_
mosaically1747427m___os__aically_
motorically1849437m___o_torically_
myopically2246177m_____yopically_
mythologically28154957mytho_logically_
narcotically1947387_nar__cotically_
necromantically2463047necromantically_
neurologically2074967neuro_logically_
osmotically1847777____osmotically_
petrologically2256067petro_logically_
philosophically3072357philos_ophically_
phototropically2763377phototropically_
prosaically1847847__pros__aically_
robotically1868517___ro_botically_
seriocomically2373107_seriocomically_
serologically1957127_sero_logically_
sociologically2254757socio_logically_
theosophically2763167_theos_ophically_
thrasonically2153417_thras_onically_
tropically1749847__tr___opically_
ultrasonically1972777ultras_onically_

Search took 10 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 Limit950241008.73610877.3
3Display Results1001000.0761315.8
 (SQL Overall)1786911009.16819490.7
 
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.