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 “macroscales” 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
macroscales175385(None) 
macroscale1654111macroscale_
microscales1756371microscales
microscale1646392microscale_
macrocytes1945863macro_cytes
macromoles1645373macro_moles
macrophages2154953macrophages
microscopes19119093microscopes
microstates1547443microstates
acrosomes1347844_acros_omes
acrospires1444074_acrospires
aeroscopes1448014_aeroscopes
aerospaces1443424_aerospaces
airscapes1345024_air_scapes
baroscopes1646754ba_roscopes
lacrosses1145304lacros__ses
macrames1438954macr___ames
macrocosms1853634macro_cosms
macrocysts1953184macro_cysts
macrocyte1845734macro_cyte_
macromeres1645754macro_meres
macromole1544934macro_mole_
macronuclei1792024macronuclei
macronucleus1861754macronucleus
macrophage2054364macrophage_
macrophytes2355714macrophytes
macroscopic1855034macroscopic
majuscules2151554ma_juscules
marascas1247384ma_rasca__s
marocains1346354ma_ro_cains
marsalas1038254ma_r_s_alas
marshaled1544644ma_r_shaled
marshalls1444834ma_r_shalls
marshals1337784ma_r_shal_s
mesoscale1343554m_esoscale_
microcodes1747374micro_codes
microcytes1948424micro_cytes
microimages1854734microimages
micromoles1648424micro_moles
microphages2156914microphages
micropyles1946964micro_pyles
microquakes28143704microquakes
microscope18138574microscope_
microscopies20167244microscopies
microsomes1649154micros_omes
microspores1747414microspores
microstate1448014microstate_
microwaves2045364micro_waves
nanoscale1152774na_noscale_
rescales103414574___rescales

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.420425454.8
2DLD Change Limit148819509.28316031.3
3Display Results50500.0301666.7
 (SQL Overall)178691509.73318359.3
 
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.