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 “microtonality” 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.

43 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
microtonality206315(None) 
microtonally1953572microtonal_ly
microtonal1456143microtonal___
microtonalities19122683microtonalities
fictionality2054614fic_tionality
irrationality1654004_irrationality
microgravity2382714micro_gravity
microporosity2263294microporosity
atonality1247075____atonality
commonality2055535__commonality
corporality1854655__corporality
criminality1855225__criminality
criticality1854215__criticality
directionality2062505directionality
emotionality17144185__emotionality
exceptionality2872115exceptionality
immortality1873795immort__ality
impersonality2063605impersonality
isotonicity1652995_i_sotonicity
marginality1754415m_ar_ginality
microanalyst1963255micro_analyst
microanalysts2062535micro_analysts
microanalytic2262605micro_analytic
microanatomy2162685micro_anatomy
microdont1447755microdon___t_
microlith1646925micr__o__lith
micromanaging2162325micromanaging
microsomal1655925microsomal___
microtomies1748555microto__mies
microtomy1846265microto____my
microtone1349675microton____e
microtones1449805microton___es
microvolt1656435microvo__l_t_
microvolts1765495microvo__l_ts
monotonicity1993065m_onotonicity
mortality1467735m_or_t__ality
notionality14126235___notionality
orthogonality2072215orthogonality
personality1656335_per_sonality
polytonality2062345_polytonality
rationality1458095___rationality
tonality1139795_____tonality
virtuality1644305vi_r_t_uality

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 Filter1786911247900.406440125.6
2DLD Change Limit124790439.40613267.1
3Display Results43430.0301433.3
 (SQL Overall)178691439.84218156.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.