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

52 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
demystifies205237(None) 
demystified2152181demystified
mystifies1745882__mystifies
decertifies1744573decertifies
demulsifies1752703demulsifies
demystify2151403demystif__y
demystifying2551903demystifying
densifies1347993de_ns_ifies
desertifies1544703desertifies
destinies10410843de__stinies
mystified1845083__mystified
mystifier1744363__mystifier
mystifiers1843113__mystifiers
rejustifies2153123rejustifies
retestifies1444533retestifies
testifies12139263te__stifies
beatifies1459284be__atifies
beautifies1554474be_autifies
certifies14310324ce__rtifies
damnifies1545544dam__nifies
deacidifies1852644deacidifies
decalcifies1953054decalcifies
decertified1853924decertified
declassifies18152624declassifies
deifies113317454de____ifies
demulsified1852394demulsified
denazifies2343294de_nazifies
denitrifies1544264denitrifies
densified1446714de_ns_ified
densities10310794de_ns_ities
desertified1654104desertified
destines93619664de__sti_nes
detoxifies2143604de_toxifies
devitrifies1852874devitrifies
emulsifies1543204_emulsifies
identifies1445804ide__ntifies
justifies1945794__justifies
mortifies1439394__mortifies
mysteries141211194__mysteries
mystiques2342424__mystiques
recertifies1644704recertifies
rectifies14310814re__ctifies
refortifies1753774refortifies
rejustified2253034rejustified
remodifies16116024rem_odifies
renotifies1356894re_notifies
retestified1554284retestified
semideifies17143564semideifies
testified1397844te__stified
testifier12116894te__stifier
testifiers13124504te__stifiers
versifies15159334ve_rs_ifies

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.436409841.7
2DLD Change Limit148819528.94016646.4
3Display Results52520.0301733.3
 (SQL Overall)178691529.40618997.6
 
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.