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

62 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
denitrifying206266(None) 
devitrifying2352181devitrifying
gentrifying1943812gen_trifying
nitrifying1744782__nitrifying
decertifying2292793decertifying
denazifying2892393den_azifying
denitrating13128333denitr_ating
denitrified1653783denitrif_ied
denitrifier1553123denitrif_ier
denitrifies1544263denitrif_ies
denitrify1643073denitrify___
densifying1844813den__sifying
desertifying2092873desertifying
identifying1943493iden_t_ifying
metrifying1945683me__trifying
nigrifying1843843__nigrifying
petrifying1945823pe__trifying
renotifying1844183renot_ifying
vitrifying2044173__vitrifying
aerifying1636494ae___rifying
beatifying1945734be_at_ifying
beautifying2043414beaut_ifying
centrifuging1951854cen_trifuging
certifying1945314ce_rt_ifying
citifying1845384__cit_ifying
dandifying1974314dan__difying
deacidifying2351894deacidifying
decalcifying2452184decalcifying
deifying1637634de____ifying
demulsifying2251864demulsifying
demystifying2551904demystifying
denigrating14146924denigr_ating
denitrifiers1651914denitrifiers
destroying1564904de_str_oying
detoxifying2652634de_toxifying
devitrified1952714devitrif_ied
devitrifies1852874devitrif_ies
devitrify1941964devitrify___
dignifying1944154d__ignifying
electrifying2153444electrifying
esterifying1873694_esterifying
etherifying2152844_etherifying
introfying1744854_in_trofying
lithifying2073644__lithifying
micrifying2144814__micrifying
nidifying1744224__ni_difying
nitriding1146724__nitri_ding
notifying1645624__not_ifying
prenotifying2153054prenot_ifying
recertifying2183234recertifying
rectifying1946374re_ct_ifying
refortifying2252794refortifying
reglorifying2052044reglorifying
repurifying2043934re_purifying
resinifying1844354resi_nifying
reverifying2143854re_verifying
revivifying2452854revi_vifying
sanctifying2043284sanct_ifying
semideifying2261774semideifying
terrifying1745164te__rrifying
testifying1745404te_st_ifying
verifying1936414ve___rifying

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 Filter1786911247900.376475242.0
2DLD Change Limit124790626.65618748.5
3Display Results62620.0302066.7
 (SQL Overall)178691627.06225303.2
 
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.