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

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
desertifying209287(None) 
decertifying2292791decertifying
recertifying2183232recertifying
certifying1945313__certifying
demystifying2551903demystifying
denitrifying2062663denitrifying
desertified1654103desertif_ied
desertifies1544703desertif_ies
desertify1643643desertify___
deserting11713143desert___ing
devitrifying2352183devitrifying
diversifying2352163diversifying
esterifying1873693_ester_ifying
refortifying2252793refortifying
retestifying1993413retestifying
reverifying2143853rever_ifying
testifying1745403tes__tifying
acetifying1944454_ace_tifying
aerifying1636494__aer_ifying
beatifying1945734__beatifying
beautifying2043414be_autifying
deacidifying2351894deacidifying
decalcifying2452184decalcifying
decertified1853924decertif_ied
decertifies1744574decertif_ies
decertify1843464decertify___
deifying1637634d__e__ifying
demeriting1448684demer_i_ting
demulsifying2251864demulsifying
denazifying2892394de_nazifying
densifying1844814d__ensifying
describing1645074descr_i_bing
descrying1635104descr___ying
desertion10410204deserti__on_
desertions1139884deserti__ons
deserving1497904deser___ving
destining11311434des__ti_ning
destroying1564904des__troying
determining1545294determi_ning
detoxifying2652634de_toxifying
disentitling1453634disentitling
dissatisfying2161104dissatisfying
electrifying2153444_electrifying
etherifying2152844ether_ifying
fortifying2045154__fortifying
gentrifying1943814gentr_ifying
identifying1943494_identifying
justifying2444054jus__tifying
metrifying1945684me_tr_ifying
mortifying1944924__mortifying
mystifying2243944mys__tifying
objectifying3051694objectifying
petrifying1945824pe_tr_ifying
prettifying2044004_prettifying
rectifying1946374__rectifying
reedifying1845244re_e_difying
reidentifying2151854reidentifying
rejustifying2652374rejustifying
renotifying1844184re_notifying
repurifying2043934repur_ifying
reservicing1753424reservi_cing
resinifying1844354res_inifying
respecifying2372554respecifying
stratifying1843524__stratifying
terrifying1745164__terrifying
verbifying2244354__verbifying
verifying1936414__ver_ifying
versifying2045034__versifying

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.390458182.1
2DLD Change Limit124790687.47016705.5
3Display Results68680.0461478.3
 (SQL Overall)178691687.90622601.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.