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

134 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
offensiveness227424(None) 
defensiveness20115812defensiveness
inoffensiveness2472172inoffensiveness
offensivenesses2464572offensivenesses
effectiveness2455673effectiveness
effusiveness2154933eff_usiveness
expensiveness2555583expensiveness
extensiveness2355303extensiveness
intensiveness1667483intensiveness
obsessiveness1764503obsessiveness
offenseless1751353offens__eless
offensives1952193offensiv__e_s
pensiveness1648653__pensiveness
adhesiveness1954384adhe_siveness
attentiveness1665154attentiveness
aversiveness1896234_aversiveness
cohesiveness2056054cohe_siveness
defectiveness2256544defectiveness
defensivenesses2255784defensivenesses
diffusiveness2353434diffusiveness
excessiveness2554964excessiveness
expansiveness2554304expansiveness
festiveness1748224__festiveness
inventiveness1956974inventiveness
objectiveness2755164objectiveness
obtrusiveness1874224obtrusiveness
offensive1842774offensiv__e__
offensively2352764offensiv__ely
oppressiveness2163474oppressiveness
possessiveness1763234possessiveness
recessiveness1865904recessiveness
retentiveness1657164retentiveness
abrasiveness1754935_abrasiveness
abusiveness16165265__abusiveness
aggressiveness1962665aggressiveness
allusiveness1554405_allusiveness
assertiveness1655505assertiveness
coerciveness1955405_coerciveness
compulsiveness2362975compulsiveness
conclusiveness2162955conclusiveness
convulsiveness2282685convulsiveness
corrosiveness1854365corrosiveness
creativeness1747765_creativeness
cursiveness1647075__cursiveness
deceptiveness2155695deceptiveness
decisiveness1855925_decisiveness
defenseless1551895defens__eless
defensives1743865defensiv__e_s
definiteness16105045defin_iteness
definitiveness2163795definitiveness
delusiveness1655755_delusiveness
denseness1046865__dens__eness
derisiveness1656965_derisiveness
digressiveness1963375digressiveness
dispersiveness20104055dispersiveness
divisiveness1954365_divisiveness
effectivenesses2665105effectivenesses
effeteness1643675effe___teness
effusivenesses2355745eff_usivenesses
electiveness1757555_electiveness
elusiveness1466605__elusiveness
enliveners1342685___enliveners
entireness1048365___entireness
erosiveness1447585__erosiveness
evasiveness1755745__evasiveness
exclusiveness2554495exclusiveness
excursiveness2554565excursiveness
expensivenesses27105495expensivenesses
explosiveness2553685explosiveness
expressiveness2664125expressiveness
extensivenesses2595285extensivenesses
fertileness1447575__fertileness
fictiveness1946315__fictiveness
fiendishness1952335_fiendishness
finiteness1347115__fin_iteness
forgiveness1864985__forgiveness
fugitiveness1964025_fugitiveness
furtiveness1746535__furtiveness
genuineness1253845__genuineness
greensickness2061525greensickness
illusiveness1555235_illusiveness
immenseness1553135immens__eness
impassiveness2054495impassiveness
impressiveness2164465impressiveness
impulsiveness2054555impulsiveness
incisiveness1756335_incisiveness
inclusiveness1855125inclusiveness
indecisiveness2063965indecisiveness
ineffectiveness2683005ineffectiveness
inexpensiveness2762785inexpensiveness
infiniteness1555735infin_iteness
ingressiveness1864165ingressiveness
insensibleness1684405insensibleness
insensitiveness1863545insensitiveness
intenseness1156575intens__eness
intensivenesses1856285intensivenesses
intrusiveness1656315intrusiveness
invasiveness1855715_invasiveness
invectiveness2156735invectiveness
lifelikeness1951545life_likeness
massiveness1645265__massiveness
naiveness1277495____naiveness
obeseness1145895o_be_s__eness
obsessivenesses18104445obsessivenesses
offenses1443835offens____e_s
offishness1943795off___ishness
operativeness1876665operativeness
oppositeness1653435o_ppositeness
passiveness1646265__passiveness
pensivenesses1849025__pensivenesses
perfectiveness2455345perfectiveness
pervasiveness2155135pervasiveness
plaintiveness1854085plaintiveness
preventiveness2294895preventiveness
progressiveness2172865progressiveness
purposiveness2053595purposiveness
receptiveness2056125receptiveness
reclusiveness18185235reclusiveness
recursiveness1855395recursiveness
reflectiveness2255105reflectiveness
reflexiveness2662745reflexiveness
regressiveness1864225regressiveness
repressiveness1964815repressiveness
repulsiveness1854705repulsiveness
responsiveness1963195responsiveness
restiveness1449665__restiveness
seclusiveness18145095seclusiveness
selectiveness1856515selectiveness
sensibleness1455405__sensibleness
sensitiveness1655815__sensitiveness
suasiveness1446435__suasiveness
subversiveness2263045subversiveness
successiveness2072815successiveness
tenseness947115__tens__eness

Search took 10 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 Filter1786911247900.423422437.4
2DLD Change Limit1247901349.26613467.5
3Display Results1341340.0931440.9
 (SQL Overall)1786911349.78218267.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.