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

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

68 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
mystifies174588(None) 
mystified1845081mystified
mystifier1744361mystifier
mystifiers1843111mystifiers
demystifies2052372demystifies
justifies1945792justifies
mortifies1439392mortifies
mysteries141211192mysteries
mystiques2342422mystiques
testifies12139262testifies
acetifies1447133acetifies
basifies13310493bas_ifies
beatifies1459283beatifies
brutifies1445713brutifies
certifies14310323certifies
citifies13310683_citifies
cystines1339473cysti_nes
cystitides1644063cystitides
cystitis1345713cystiti_s
demystified2152183demystified
destinies10410843destinies
fortifies1548693fortifies
gasifies1238693gas_ifies
gratifies1347993gratifies
justified2045043justified
justifier1944363justifier
justifiers2043083justifiers
magnifies1547283magnifies
masteries111018493masteries
mastiches1647333mastiches
mastiffs1644233mastif_fs
mastitides1345833mastitides
mastitis1039103mastiti_s
mastixes1738253masti_xes
mestinoes1157313mestinoes
mestizoes2064173mestizoes
metrifies1439803metrifies
micrifies16118673micrifies
minifies13312903m_inifies
mistimes12612613misti_mes
mistitles1147953mistitles
modifies1439163m_odifies
mollifies1447553mollifies
mortified1547383mortified
mortifier1446923mortifier
mortifiers1544393mortifiers
mummifies1543713mummifies
mutinies10311503m_utinies
mysticetes1753053mysticetes
mysticism1845383mysticism
mysticisms1944603mysticisms
mystics14279103myst__ics
mystify1843563mystif__y
mystifying2243943mystifying
mystique2242393mystique_
notifies11310423_notifies
ossifies1177563_ossifies
ratifies11313513_ratifies
rectifies14310813rectifies
russifies1245443russifies
stiffies14258383__stiffies
stifles103013393__stifles
stimies9316563__stimies
testified1397843testified
testifier12116893testifier
testifiers13124503testifiers
typifies1644963ty_pifies
vastities1248933vastities

Search took 8 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 Filter1786911486410.1561145455.1
2DLD Change Limit148641687.03321134.8
3Display Results68680.0302266.7
 (SQL Overall)178691687.21924752.9
 
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.