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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 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
assertivenesses175493(None) 
assertiveness1655502assertivene_s_s
abortivenesses1985293a_bortivenesses
attentivenesses1874693attentivenesses
aversivenesses2056563a_versivenesses
sportivenesses1956283_sportivenesses
activenesses1758214a___ctivenesses
adaptivenesses2054254a_daptivenesses
adhesivenesses2155054adhe_sivenesses
amativenesses1856784a__mativenesses
coercivenesses2165654_coercivenesses
costivenesses1848164cos__tivenesses
creativenesses1967034_creativenesses
deceptivenesses23125894deceptivenesses
defectivenesses2496074defectivenesses
effectivenesses2665104effectivenesses
electivenesses1957644_electivenesses
essentialnesses1462644essentialnesses
fertilenesses1648034__fertilenesses
festivenesses1998434__festivenesses
furtivenesses1947234__furtivenesses
invectivenesses23106014invectivenesses
inventivenesses21136254inventivenesses
massivenesses1755914mass___ivenesses
objectivenesses2994474objectivenesses
obsessivenesses18104444obsessivenesses
operativenesses2055774_operativenesses
passivenesses1746664pass___ivenesses
positivenesses1965974pos_itivenesses
receptivenesses22106054receptivenesses
resistivenesses1755764resistivenesses
restivenesses1679444__restivenesses
retentivenesses1896404retentivenesses
secretivenesses2055684_secretivenesses
selectivenesses2056004selectivenesses
servilenesses1646304__servilenesses
abortiveness1755325a_bortivene_s_s
abrasivenesses19105555a_brasivenesses
abstrusenesses1552565abstr_usenesses
abusivenesses1856295a__busivenesses
acceptingnesses2261515acceptingnesses
adversenesses1753395adver__senesses
alertnesses1147235a_lert___nesses
alivenesses1448875a____livenesses
allusivenesses1755195a_llusivenesses
artinesses10815215a___rti__nesses
assaultiveness1762085assaultivene_s_s
assurednesses1352615assur__ednesses
astutenesses1245595a_s__tutenesses
attentiveness1665155attentivene_s_s
austerenesses1354175aus__terenesses
averagenesses1755015a_ver_agenesses
aversenesses1545665a_ver__senesses
aversiveness1896235a_versivene_s_s
cohesivenesses2256205cohe_sivenesses
combativenesses2464155combativenesses
cursivenesses1847505__cursivenesses
defensivenesses2255785defensivenesses
derisivenesses1857235__derisivenesses
deservednesses19163485deser__vednesses
entirenesses1249665___entirenesses
erosivenesses1648315___erosivenesses
evocativenesses2364345evocativenesses
excessivenesses2675145excessivenesses
excursivenesses2794735excursivenesses
expensivenesses27105495expensivenesses
extensivenesses2595285extensivenesses
fictivenesses2157125__fictivenesses
forgivenesses2045845__forgivenesses
fugitivenesses2154455_fugitivenesses
imitativenesses2084495imitativenesses
intensivenesses1856285intensivenesses
intuitivenesses1865335intuitivenesses
lucrativenesses2054375lucrativenesses
masterlinesses1673525masterli__nesses
miserablenesses1954665miserablenesses
miserlinesses1554665miserli__nesses
nativenesses1548565___nativenesses
negativenesses1855855_negativenesses
normativenesses2084525normativenesses
offensivenesses2464575offensivenesses
pensivenesses1849025__pensivenesses
petitenesses14169365__pe_titenesses
plaintivenesses2054315plaintivenesses
primitivenesses2263945primitivenesses
promotivenesses22113895promotivenesses
punitivenesses1965655_punitivenesses
reactivenesses1956925_reactivenesses
recessivenesses1955815recessivenesses
recursivenesses2055345recursivenesses
reductivenesses21145725reductivenesses
reservednesses18163325reser__vednesses
seductivenesses21145475seductivenesses
sensitivenesses1775355sensitivenesses
serenenesses12117115__ser_enenesses
serriednesses1454275__serriednesses
sportinesses1447875_sporti__nesses
sportiveness1766985_sportivene_s_s
sterlingnesses1553145_sterlingnesses
suasivenesses1546825__suasivenesses
subtilenesses1585065__subtilenesses
sveltenesses1545235_svelt__enesses
sweatinesses1546915_sweati__nesses
talkativenesses2273405talkativenesses
tentativenesses1854815tentativenesses
votivenesses1847585___votivenesses

Search took 5 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.313570897.8
2DLD Change Limit658741063.78017427.0
3Display Results1061060.0761394.7
 (SQL Overall)1786911064.16942861.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.