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

66 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
resistiveness165602(None) 
resistivenesses1755762resistivenesses
restiveness1449662re__stiveness
decisiveness1855923decis_iveness
derisiveness1656963deris_iveness
festiveness1748223fe__stiveness
positiveness1756493posi_tiveness
reactiveness1756923re_activeness
receptiveness2056123receptiveness
recessiveness1865903recessiveness
reductiveness1955543reductiveness
respectiveness2155363respectiveness
restrictiveness2093413restrictiveness
retentiveness1657163retentiveness
sensitiveness1655813sensi_tiveness
assertiveness1655504assertiveness
costiveness1648214__costiveness
creativeness1747764cre__ativeness
deceptiveness2155694deceptiveness
defectiveness2256544defectiveness
definitiveness2163794definitiveness
delusiveness1655754delus_iveness
derivativeness2163804derivativeness
descriptiveness2362274descriptiveness
divisiveness1954364divis_iveness
electiveness1757554_electiveness
elusiveness1466604_elus_iveness
erosiveness1447584_eros_iveness
evasiveness1755744_evas_iveness
feistiness1345074fe_isti__ness
fictiveness1946314__fictiveness
fugitiveness1964024fugi_tiveness
incisiveness1756334incis_iveness
massiveness1645264mas_s_iveness
meditativeness2062884meditativeness
negativeness1656084ne_gativeness
obsessiveness1764504obsessiveness
passiveness1646264pas_s_iveness
pensiveness1648654pe_ns_iveness
permissiveness2163174permissiveness
plaintiveness1854084plaintiveness
preventiveness2294894preventiveness
primitiveness2054564primi_tiveness
punitiveness1755364puni_tiveness
reclusiveness18185234reclusiveness
recursiveness1855394recursiveness
reflectiveness2255104reflectiveness
reflexiveness2662744reflexiveness
refractiveness2254854refractiveness
regressiveness1864224regressiveness
repetitiveness1963844repetitiveness
repressiveness1964814repressiveness
repulsiveness1854704repulsiveness
requisiteness2263404requis_iteness
resistive1247584resistiv__e__
resistively1745034resistiv__ely
resistivities1694494resistivities
resistless1043174resist___less
resistlessness1282604resistlessness
responsiveness1963194responsiveness
restivenesses1679444re__stivenesses
secretiveness1865864secretiveness
seductiveness1955244seductiveness
selectiveness1856514selectiveness
tentativeness1655024tentativeness
transitiveness1763274transi_tiveness

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 Filter178691950240.356501941.0
2DLD Change Limit95024664.87619488.1
3Display Results66660.0461434.8
 (SQL Overall)178691665.27833855.8
 
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.