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

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

50 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
macroscopic185503(None) 
microscopic1856381microscopic
cryoscopic1853513__cryoscopic
gastroscopic1963563gastroscopic
gyroscopic2054003_gyroscopic
hagioscopic2162613hagioscopic
hygroscopic2453643hygroscopic
laparoscopic2062473laparoscopic
macrobiotic1953053macrobiotic
macrocosmic1852623macro_cosmic
macrocytic1854673macro_cytic
microscope18138573microscop_e
microscopes19119093microscopes
microscopical2063353microscopical
microscopies20167243microscopies
microscopist2055643microscopist
microscopy21115843microscop_y
uroscopic1555203__uroscopic
acrostic1239944_acros__tic
aeroscope1347684_aeroscop_e
aeroscopes1448014_aeroscopes
apocopic1645824_a_po_copic
arthroscopic2163994arthroscopic
baroscope1546574ba_roscop_e
baroscopes1646754ba_roscopes
cystoscopic1962964cystoscopic
endoscopic1754474_endoscopic
fluoroscopic2162984fluoroscopic
macrocosm1743784macro_co_sm
macrocosms1853634macro_cosms
macrocyclic1852764macrocyclic
macroeconomic2071744macroeconomic
macrophagic2353964macrophagic
macrophytic2554774macrophytic
macroscale1654114macrosc_ale
macroscales1753854macroscales
macroscopically2561844macroscopically
megascopic1952514m_egascopic
micrococci1454524micro_cocci
microcopies19117854micro_copies
microcopy2085494micro_cop_y
microcosmic1854244micro_cosmic
microcytic1856224micro_cytic
microphonic2256514microphonic
microscopists2164064microscopists
orthoscopic2054244orthoscopic
periscopic1854424_periscopic
spectroscopic2062824spectroscopic
stereoscopic1863544stereoscopic
submicroscopic237934submicroscopic

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 Filter1786911488190.453394461.4
2DLD Change Limit148819509.17016228.9
3Display Results50500.0331515.2
 (SQL Overall)178691509.65618505.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.