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

58 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
devitrifying235218(None) 
denitrifying2062661denitrifying
vitrifying2044172__vitrifying
decertifying2292793decertifying
desertifying2092873desertifying
devitrified1952713devitrif_ied
devitrifies1852873devitrif_ies
devitrify1941963devitrify___
gentrifying1943813ge_ntrifying
metrifying1945683me__trifying
nitrifying1744783__nitrifying
petrifying1945823pe__trifying
reverifying2143853rev_erifying
revivifying2452853revi_vifying
aerifying1636494ae___rifying
beatifying1945734be_at_ifying
beautifying2043414beaut_ifying
certifying1945314ce_rt_ifying
citifying1845384__cit_ifying
deacidifying2351894deacidifying
decalcifying2452184decalcifying
deifying1637634de____ifying
demulsifying2251864demulsifying
demystifying2551904demystifying
denazifying2892394de_nazifying
denitrating13128334denitr_ating
denitrified1653784denitrif_ied
denitrifier1553124denitrif_ier
denitrifies1544264denitrif_ies
denitrify1643074denitrify___
densifying1844814de__nsifying
destroying1564904de_str_oying
detoxifying2652634de_toxifying
devitalizing2645944devitalizing
dignifying1944154d__ignifying
diversifying2352164diversifying
electrifying2153444electrifying
esterifying1873694_esterifying
etherifying2152844_etherifying
identifying1943494ide_nt_ifying
lithifying2073644__lithifying
micrifying2144814__micrifying
nigrifying1843844__nigrifying
recertifying2183234recertifying
rectifying1946374re_ct_ifying
refortifying2252794refortifying
reglorifying2052044reglorifying
renotifying1844184renot_ifying
repurifying2043934re_purifying
resinifying1844354resi_nifying
semideifying2261774semideifying
terrifying1745164te__rrifying
testifying1745404te_st_ifying
verifying1936414__v_erifying
vilifying1944494__vi_lifying
vinifying1944714__vi_nifying
vitrioling1443584__vitrioling
vivifying2243844__vi_vifying

Search took 7 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 Filter1786911247900.393454684.5
2DLD Change Limit124790586.40619480.2
3Display Results58580.0301933.3
 (SQL Overall)178691586.82926166.5
 
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.