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

102 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
offensivenesses246457(None) 
defensivenesses2255782defensivenesses
offensiveness2274242offensivene_s_s
effectivenesses2665103effectivenesses
effusivenesses2355743eff_usivenesses
expensivenesses27105493expensivenesses
extensivenesses2595283extensivenesses
intensivenesses1856283intensivenesses
obsessivenesses18104443obsessivenesses
pensivenesses1849023__pensivenesses
adhesivenesses2155054adhe_sivenesses
attentivenesses1874694attentivenesses
aversivenesses2056564_aversivenesses
cohesivenesses2256204cohe_sivenesses
defectivenesses2496074defectivenesses
defensiveness20115814defensivene_s_s
diffusivenesses25103864diffusivenesses
excessivenesses2675144excessivenesses
expansivenesses2794524expansivenesses
festivenesses1998434__festivenesses
inoffensiveness2472174inoffensivene_s_s
inventivenesses21136254inventivenesses
objectivenesses2994474objectivenesses
obtrusivenesses2064374obtrusivenesses
recessivenesses1955814recessivenesses
retentivenesses1896404retentivenesses
abrasivenesses19105555_abrasivenesses
abusivenesses1856295__abusivenesses
allusivenesses1755195_allusivenesses
assertivenesses1754935assertivenesses
coercivenesses2165655_coercivenesses
corrosivenesses2094595corrosivenesses
creativenesses1967035_creativenesses
cursivenesses1847505__cursivenesses
deceptivenesses23125895deceptivenesses
decisivenesses2056765_decisivenesses
definitenesses1864255defin_itenesses
delusivenesses1856545_delusivenesses
densenesses1247365__dens__enesses
derisivenesses1857235_derisivenesses
divisivenesses2154965_divisivenesses
effectiveness2455675effectivene_s_s
effetenesses1854525effe___tenesses
effusiveness2154935eff_usivene_s_s
electivenesses1957645_electivenesses
elusivenesses1697705__elusivenesses
entirenesses1249665___entirenesses
erosivenesses1648315__erosivenesses
evasivenesses1957145__evasivenesses
exclusivenesses2764665exclusivenesses
excursivenesses2794735excursivenesses
expensiveness2555585expensivene_s_s
explosivenesses2793925explosivenesses
extensiveness2355305extensivene_s_s
fertilenesses1648035__fertilenesses
fictivenesses2157125__fictivenesses
fiendishnesses2172475_fiendishnesses
finitenesses1557725__fin_itenesses
forgivenesses2045845__forgivenesses
fugitivenesses2154455_fugitivenesses
furtivenesses1947235__furtivenesses
genuinenesses1475305__genuinenesses
greensicknesses2261475greensicknesses
illusivenesses1755785_illusivenesses
immensenesses1762995immens__enesses
impassivenesses2164125impassivenesses
impulsivenesses2264315impulsivenesses
incisivenesses1966685_incisivenesses
inclusivenesses2065115inclusivenesses
infinitenesses1795035infin_itenesses
intensenesses1356055intens__enesses
intensiveness1667485intensivene_s_s
intrusivenesses1885445intrusivenesses
invasivenesses2056025_invasivenesses
invectivenesses23106015invectivenesses
lifelikenesses2152395life_likenesses
massivenesses1755915__massivenesses
naivenesses1449115____naivenesses
obesenesses1346765o_be_s__enesses
obsessiveness1764505obsessivene_s_s
offenseless1751355offens__ele_s_s
offensives1952195offensiv_____es
offishnesses2143815off___ishnesses
operativenesses2055775operativenesses
oppositenesses1854205o_ppositenesses
passivenesses1746665__passivenesses
pensiveness1648655__pensivene_s_s
pervasivenesses2355205pervasivenesses
plaintivenesses2054315plaintivenesses
purposivenesses2263655purposivenesses
receptivenesses22106055receptivenesses
reclusivenesses2055285reclusivenesses
recursivenesses2055345recursivenesses
reflexivenesses2893395reflexivenesses
repulsivenesses2064895repulsivenesses
restivenesses1679445__restivenesses
seclusivenesses1965055seclusivenesses
selectivenesses2056005selectivenesses
sensiblenesses1555255__sensiblenesses
sensitivenesses1775355__sensitivenesses
suasivenesses1546825__suasivenesses
tensenesses1147615__tens__enesses

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.343520965.0
2DLD Change Limit658741023.95316664.3
3Display Results1021020.0761342.1
 (SQL Overall)1786911024.37240871.7
 
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.