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

73 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
devitrified195271(None) 
denitrified1653781denitrified
devitrifies1852871devitrifies
denitrifier1553122denitrifier
denitrifies1544262denitrifies
vitrified1645982__vitrified
decertified1853933decertified
denitrifiers1651913denitrifiers
desertified1654103desertified
devitrify1941963devitrif__y
devitrifying2352183devitrifying
gentrified1545673ge_ntrified
metrified1547863me__trified
nitrified1346733__nitrified
petrified1548343pe__trified
reverified1745123rev_erified
revivified2043833revi_vified
vitrifies1547223__vitrifies
aerified121310144ae___rified
beatified1577864be_at_ified
beautified1654224beaut_ified
certified1548424ce_rt_ified
citified1438254__cit_ified
countrified1754114countrified
deacidified1952124deacidified
decalcified2052664decalcified
decertifies1744574decertifies
deified123112414de____ified
demulsified1852394demulsified
demystified2152184demystified
denazified2443064de_nazified
denitrated1298034denitr_ated
denitrify1643074denitrif__y
denitrifying2062664denitrifying
densified1446714de__nsified
desertifies1544704desertifies
detoxified2243084de_toxified
devilries1345254devilr__ies
deviltries1444134deviltr__ies
devitalized25106974devitalized
dignified1545574d__ignified
diversified1962964diversified
electrified1754604electrified
esterified1445404_esterified
etherified1744084_etherified
gentrifier1444814ge_ntrifier
gentrifies1446894ge_ntrifies
identified1545054ide_nt_ified
lithified1644464__lithified
metrifies1439804me__trifies
micrified17126804__micrified
nigrified1445334__nigrified
nitrifier1245964__nitrifier
nitrifies12107924__nitrifies
petrifier1447124pe__trifier
petrifies14310364pe__trifies
recertified1754344recertified
rectified1539254re_ct_ified
refortified1853444refortified
reglorified1652544reglorified
renotified1455814renot_ified
repurified1645164re_purified
resinified1445764resi_nified
reverifies1645974rev_erifies
revivifies1944554revi_vifies
semideified18162924semideified
terrified13147584te__rrified
testified1397844te_st_ified
verified151510404__v_erified
vilified1547244__vi_lified
vinified1537544__vi_nified
vitrioled1343424__vitrioled
vivified1845894__vi_vified

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 Limit148819738.86016796.7
3Display Results73730.0332212.1
 (SQL Overall)178691739.31319187.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.