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 “demystified” 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
demystified215218(None) 
demystifies2052371demystifies
mystified1845082__mystified
decertified1853923decertified
demulsified1852393demulsified
demystify2151403demystif__y
demystifying2551903demystifying
densified1446713de_ns_ified
desertified1654103desertified
mystifier1744363__mystifier
mystifies1745883__mystifies
rejustified2253033rejustified
retestified1554283retestified
testified1397843te__stified
beatified1577864be__atified
beautified1654224be_autified
certified1548414ce__rtified
damnified1644884dam__nified
deacidified1952124deacidified
decalcified2052664decalcified
decertifies1744574decertifies
declassified19142494declassified
deified123112414de____ified
demasted1238764demast___ed
demulsifies1752704demulsifies
denazified2443064de_nazified
denitrified1653784denitrified
densifies1347994de_ns_ifies
desertifies1544704desertifies
destined103312454de__sti_ned
destinies10410844de__stinies
detoxified2243084de_toxified
devitrified1952714devitrified
emulsified1652934_emulsified
identified1545054ide__ntified
justified2045044__justified
mortified1547384__mortified
mystifiers1843114__mystifiers
recertified1754334recertified
rectified1539244re__ctified
refortified1853444refortified
rejustifies2153124rejustifies
remodified17115264rem_odified
renotified1455814re_notified
retestifies1444534retestifies
semideified18162924semideified
testifier12116894te__stifier
testifies12139264te__stifies
unjustified2252324unjustified
versified16147594ve_rs_ified

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 Filter1786911488190.420425454.8
2DLD Change Limit148819508.11018350.1
3Display Results50500.0163125.0
 (SQL Overall)178691508.54620909.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.