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

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
aggressiveness196266(None) 
digressiveness1963372digressiveness
ingressiveness1864162ingressiveness
regressiveness1864222regressiveness
expressiveness2664123expressiveness
impressiveness2164463impressiveness
oppressiveness2163473oppressiveness
progressiveness2172863progressiveness
repressiveness1964813repressiveness
abrasiveness1754934a_br_asiveness
adhesiveness1954384a_dhe_siveness
aggregateness1662334aggre_gateness
aggressions1353854aggressi_on__s
aggressive1554254aggressiv__e__
aggressively2052874aggressiv__ely
aggressivities1961624aggressivities
aversiveness1896234a__versiveness
excessiveness2554964_excessiveness
obsessiveness1764504_obsessiveness
possessiveness1763234possessiveness
recessiveness1865904_recessiveness
restiveness1449664___restiveness
successiveness2072814successiveness
suggestiveness1962924suggestiveness
suppressiveness2162414suppressiveness
abortiveness1755325abor__tiveness
abusiveness16165265a___busiveness
accessibleness2061845a_ccessibleness
agelessness1246075ageless___ness
aggresses1146145aggress____e_s
aggressing1344185aggressi__n__g
aggression1253945aggressi_on___
aggressivity2081975aggressiv__ity
agreeableness1654105a_greeableness
allusiveness1554405a__llusiveness
assertiveness1655505a_ssertiveness
attentiveness1665155a_ttentiveness
attractiveness1983555attractiveness
cohesiveness2056055_cohe_siveness
corrosiveness1854365_corrosiveness
creativeness1747765__creativeness
cursiveness1647075_cur__siveness
defensiveness20115815_defensiveness
derisiveness1656965_der_isiveness
dispersiveness20104055dispersiveness
dressiness1145545__dressi__ness
erosiveness1447585__er_osiveness
expensiveness2555585_expensiveness
extensiveness2355305_extensiveness
festiveness1748225___festiveness
greasiness1156545__greasi__ness
impassiveness2054495_impassiveness
ingressives1554255ingressiv__e_s
intensiveness1667485_intensiveness
intrusiveness1656315intr_usiveness
massiveness1645265___massiveness
obtrusiveness1874225obtr_usiveness
offensiveness2274245_offensiveness
passiveness1646265___passiveness
pensiveness1648655___pensiveness
percussiveness2193735percussiveness
permissiveness2163175permissiveness
pervasiveness2155135_pervasiveness
purposiveness2053595_purposiveness
resistiveness1656025___resistiveness
secretiveness1865865secre_tiveness
submissiveness2062255submissiveness
subversiveness2263045subversiveness

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.1231452772.4
2DLD Change Limit95024685.59616980.7
3Display Results68680.0461478.3
 (SQL Overall)178691685.76530995.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.