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 “nonderivative” with Change Limit: [1] [2] [3] [4] [5] [6]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
nonderivative206351(None) 
antiderivative2171823antiderivative
conservative20106993conser_vative
derivative1746683___derivative
antiderivatives2281354antiderivatives
conservatives2195194conser_vatives
conservatize26125504conser_vatize
derivatives1844644___derivatives
derivatize2345984___derivatize
noncreative1648234non_cr_eative
nondeceptive2053734nonde_ceptive
nondeductive1953764nonde_ductive
nondescriptive2261974nondescri_ptive
nondirective1854684nondir_ective
nonimitative1784544non_imitative
nonnarrative1553834nonnar_rative
nonnegative1555174nonne__gative
nonnormative1754864nonnor_mative
nonoperative1756284nonoper__ative
nonrelative1456834non__relative
concentrative2056215concentrative
conciliative1954165concili_ative
confederative2253755confederative
consecrative1957315conse_crative
conservation1749405conser_vation
conservatism19104955conser_vatism
conservatively25133875conser_vatively
conservatized28113605conser_vatized
conservatizes27114455conser_vatizes
conservatoire1862765conser_vatoire
constrictive1956625constri_ctive
contaminative2054375contaminative
contemplative22123705contemplative
contributive1953585con_tributive
cooperative1847055cooper__ative
derivate12311205___derivat__e
derivation14712785___derivation
derivatively2264315___derivatively
derivatized2554515___derivatized
derivatizes2445155___derivatizes
derogative1546985___derogative
deviative1647725___devi_ative
exonerative2155395exon_er__ative
federative1746165_feder__ative
generative1458565gen_er__ative
indicative1647715_ind__icative
indurative1447285_indur__ative
inoperative1646745ino_per__ative
motivative1844285mo___tivative
neoconservative2371655neoconser_vative
nominative1597685no___minative
nonabrasive1652575nonabr__asive
nonaddictive1963105nonaddi_ctive
nonadditive1683535nonaddi__tive
noncombative2154445non_combative
nonconservative2372845nonconser_vative
noncumulative2062545noncumulative
nondelegate1353175nondelegat__e
nondeliveries1762315nondeliveries
nondestructive2072745nondestructive
nondisruptive1962205nondisruptive
nondistinctive2071915nondistinctive
nondramatic1654475nond_ramati_c
noneffective2363585non_effective
nonelective1666855non_e_lective
nonevaluative1982485nonevaluative
nonexecutive2452875non_executive
nonfigurative2062825nonfigurative
noninvasive1772455non__invasive
nonirritating1472515nonirritating
nonnative1248345non____native
nonnutritive1563145nonnutri__tive
nonpermissive2061405nonpermissive
nonpunitive1654775nonpuni__tive
nonradioactive2071405nonradioactive
nonreactive1645955non__reactive
nonrelatives1564205non__relatives
nonrestrictive1972595nonrestri_ctive
nonretroactive1962035nonretroactive
nonselective1755415nonse_lective
nonsensitive1564955nonse_nsitive
nonspeculative2161995nonspeculative
nonterminating1773125nonterminating
normative1448895no___r_mative
operative141110555_o_per__ative
preservative2053955preser_vative
privative17188295____privative
tenderization2355735tenderization
tolerative1346255to_ler__ative
underactive1745965_under_active
vindicative2053795vind__icative

Search took 9 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 Limit124790918.17315268.6
3Display Results91910.0631444.4
 (SQL Overall)178691918.62620715.4
 
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.