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

55 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
restrictiveness209341(None) 
destructiveness2173802destructiveness
descriptiveness2362273descriptiveness
instructiveness2064153instructiveness
obstructiveness2273393obstructiveness
refractiveness2254853re_fractiveness
resistiveness1656023res__istiveness
respectiveness2155363res_pectiveness
restrictives1755083restrictiv__e_s
attractiveness1983554_attractiveness
distinctiveness2162914distinctiveness
reactiveness1756924re___activeness
reductiveness1955544re__ductiveness
reflectiveness2255104re_flectiveness
repetitiveness1963844repeti_tiveness
restiveness1449664res____tiveness
restrictionism1863784restricti_onism
restrictionisms1963244restricti_onisms
restrictionist1665044restricti_onist
restrictionists1764084restricti_onists
restrictions1449284restricti_on__s
restrictive1646364restrictiv__e__
restrictively2153824restrictiv__ely
retentiveness1657164re_t_entiveness
assertiveness1655505asser__tiveness
decorativeness2054185decor_ativeness
defectiveness2256545de__fectiveness
definitiveness2163795defini_tiveness
derisiveness1656965de__ri_siveness
derivativeness2163805de__rivativeness
destituteness1462925dest_i_tuteness
disruptiveness2083335dis_ruptiveness
effectiveness2455675_e_ffectiveness
electiveness1757565_e__lectiveness
festiveness1748225fes____tiveness
fictiveness1946315____fictiveness
intuitiveness1656195_intui_tiveness
perfectiveness2455345pe_rfectiveness
positiveness1756495pos__i_tiveness
protectiveness2154595prot_ectiveness
receptiveness2056125re__ceptiveness
recursiveness1855395recur__siveness
regressiveness1864225re_gressiveness
repressiveness1964815re_pressiveness
resistivenesses1755765res__istivenesses
responsiveness1963195res_ponsiveness
restricting1449305restricti__n__g
restriction1349365restricti_on___
secretiveness1865865se_cr_etiveness
seductiveness1955245__seductiveness
selectiveness1856515__selectiveness
sensitiveness1655815se_nsi_tiveness
strictness1245645__strict___ness
tentativeness1655025tent__ativeness
vindictiveness2363035_vindictiveness

Search took 6 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 Filter178691658740.326548131.9
2DLD Change Limit65874554.98613211.8
3Display Results55550.0461195.7
 (SQL Overall)178691555.35833350.3
 
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.