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

90 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
devitrifies185287(None) 
denitrifies1544261denitrifies
devitrified1952711devitrified
denitrified1653782denitrified
denitrifier1553122denitrifier
denitrifiers1651912denitrifiers
vitrifies1547222__vitrifies
decertifies1744573decertifies
desertifies1544703desertifies
devilries1345253devilr__ies
deviltries1444133deviltr__ies
devitrify1941963devitrif__y
devitrifying2352183devitrifying
gentrifies1446903ge_ntrifies
metrifies1439803me__trifies
nitrifies12107923__nitrifies
petrifies14310363pe__trifies
reverifies1645973rev_erifies
revivifies1944553revi_vifies
vitrified1645983__vitrified
aerifies111313394ae___rifies
beatifies1459284be_at_ifies
beautifies1554474beaut_ifies
certifies14310324ce_rt_ifies
citifies13310684__cit_ifies
deacidifies1852644deacidifies
debilities13411294debi_lities
decalcifies1953054decalcifies
decertified1853934decertified
deifies113317454de____ifies
deities82621924de_it___ies
demulsifies1752704demulsifies
demystifies2052374demystifies
denazifies2343294de_nazifies
denitrates1169514denitr_ates
denitrify1643074denitrif__y
denitrifying2062664denitrifying
densifies1347994de__nsifies
desertified1654104desertified
destinies10410844de_st_inies
detoxifies2143604de_toxifies
deviancies1644594devi_ancies
devilfishes2151994devilfishes
devitalizes24107104devitalizes
dexterities1945824dexterities
dextrines1798314de_xtri_nes
dignifies1446364d__ignifies
diversifies1853814diversifies
divinities1447744divi_nities
editrices1245324_editri_ces
editrixes1743814_editri_xes
electrifies1645754electrifies
esterifies1347154_esterifies
etherifies1645284_etherifies
gentrified1545684ge_ntrified
gentrifier1444824ge_ntrifier
gentrifiers1543004ge_ntrifiers
heritrices1555304heritri_ces
heritrixes2043744heritri_xes
identifies1445804ide_nt_ifies
levities11310714levit___ies
lithifies1545504__lithifies
metrified1547864me__trified
micrifies16118674__micrifies
nigrifies1346364__nigrifies
nitrified1346734__nitrified
nitrifier1245964__nitrifier
nitrifiers1343924__nitrifiers
petrified1548344pe__trified
petrifier1447124pe__trifier
petrifiers1544674pe__trifiers
recertifies1644704recertifies
rectifies14310814re_ct_ifies
refortifies1753774refortifies
reglorifies1553004reglorifies
renotifies1356894renot_ifies
repurifies1546144re_purifies
resinifies1346914resi_nifies
reverified1745124rev_erified
revivified2043834revi_vified
semideifies17143564semideifies
seniorities1148134seniorities
severities1348524sev_erities
terrifies12139724te__rrifies
testifies12139264te_st_ifies
verifies141313484__v_erifies
vilifies1439594__vi_lifies
vinifies1439874__vi_nifies
vitrines112610914__vitri_nes
vivifies1747024__vi_vifies

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.440406115.9
2DLD Change Limit148819908.75017007.9
3Display Results90900.0461956.5
 (SQL Overall)178691909.23619347.2
 
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.