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

82 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
deteriorative176258(None) 
deteriorate1255092deteriorat__e
deteriorating1553392deteriorating
deterioration14145282deterioration
deteriorated1453463deteriorat_ed
deteriorates1354443deteriorat_es
deteriorations15164693deteriorations
determinative1954073determinative
ameliorative1752944_ameliorative
decorative1648924d__e_corative
degenerative1754964dege_nerative
denigrative1655484d__enigrative
derivative1746684d__eri_vative
derogative1546984d__er_ogative
determinatives2052934determinatives
detonative1447134det___onative
deverbative2053624dever__bative
interpolative1865664interpolative
interrogative17104984interrogative
meliorative1655154__meliorative
reverberative2162134reverberative
alternative1454685alter__native
corporative1847155__corporative
decerebrate1664015decerebrat__e
decerebrating1953205decerebrating
decerebration1884195decerebration
declarative1754315d__eclarative
deformative2044975defor__mative
degradative1763085de_gr_adative
deliberative1854055de_liberative
delineative1554665d__elineative
demonstrative1964215demonstrative
denominative1854405denomi_native
denotative1456725d__e_notative
depersonalize25103645depersonalize
depreciative2084085de_preciative
derivatives1844645d__eri_vatives
derivatize2345985d__eri_vatize
descriptive1953685descri__ptive
desiccative1953945d__esiccative
desiderative1753685de_siderative
designative1654335d__esignative
detective1548105dete____ctive
determinate1446625determinat__e
determination1657645determination
deterrable1345725deter__ra_ble
detersive1346345dete___r_sive
detractive1647375det_r__active
detribalize2355005det_ri_balize
deverbatives2152175dever__batives
deviative1647725d__evi__ative
elaborative1653775_e_laborative
evaporative1953615_e_vaporative
execrative2246045_exe__crative
explorative2354245_e_xplorative
exteriorise1854635exterior__ise
exteriorities2053635exteriorities
exteriorize2753855exterior__ize
federative1746165fede___rative
generative1458565gene___rative
incorporative20124065incorporative
integrative1547125inte__grative
interiorise1148095interior__ise
interiorities1356705interiorities
interiorize2056335interior__ize
interoperative1974365interoperative
interpretive1775845inter_pretive
interrogatives18133475interrogatives
iterative12410715_ite___rative
pejorative2245695__pe_jorative
penetrative1646115pene__trative
performative22103875__performative
personative1647075__personative
prerogative1755355_prer_ogative
regenerative1655305rege_nerative
reiterative1447535reite___rative
reprobative1855645re_pr_obative
restorative1446945__restorative
retaliative1454985retali__ative
retributive1653515ret_ri_butive
retroactive1645825ret_r_oactive
terminative1656135__terminative

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.1401276364.3
2DLD Change Limit124790828.51614653.6
3Display Results82820.0461782.6
 (SQL Overall)178691828.70220534.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.