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

122 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
defensivenesses225574(None) 
defectivenesses2496052defectivenesses
defensiveness20115802defensivene_s_s
offensivenesses2464532offensivenesses
deceptivenesses23125873deceptivenesses
decisivenesses2056723de_cisivenesses
definitenesses1864223defin_itenesses
delusivenesses1856493de_lusivenesses
derisivenesses1857183de_risivenesses
diffusivenesses25103833diffusivenesses
effusivenesses2355683_effusivenesses
expensivenesses27105443expensivenesses
extensivenesses2595233extensivenesses
intensivenesses1856243intensivenesses
pensivenesses1848953__pensivenesses
recessivenesses1955773recessivenesses
retentivenesses1896363retentivenesses
adhesivenesses2155014adhe_sivenesses
attentivenesses1874654attentivenesses
aversivenesses2056524_aversivenesses
cohesivenesses2256164cohe_sivenesses
defectiveness2256544defectivene_s_s
densenesses1247354d__ens__enesses
divisivenesses2154924d_ivisivenesses
effectivenesses2665064effectivenesses
electivenesses1957584_electivenesses
elusivenesses1697634_e_lusivenesses
erosivenesses1648244_e_rosivenesses
evasivenesses1957084_e_vasivenesses
excessivenesses2675094excessivenesses
expansivenesses2794474expansivenesses
festivenesses1998404__festivenesses
inventivenesses21136224inventivenesses
obsessivenesses18104404obsessivenesses
offensiveness2274234offensivene_s_s
pervasivenesses2355154pervasivenesses
receptivenesses22106034receptivenesses
reclusivenesses2055244reclusivenesses
recursivenesses2055304recursivenesses
reflexivenesses2893374reflexivenesses
repulsivenesses2064854repulsivenesses
seclusivenesses1965014seclusivenesses
selectivenesses2055984selectivenesses
abrasivenesses19105525_abrasivenesses
abusivenesses1856235__abusivenesses
allusivenesses1755155_allusivenesses
assertivenesses1754915assertivenesses
coercivenesses2165635_coercivenesses
corrosivenesses2094565corrosivenesses
creativenesses1967015_creativenesses
cursivenesses1847465__cursivenesses
debonairnesses1771445debonai_rnesses
deceptiveness2155695deceptivene_s_s
decisiveness1855925de_cisivene_s_s
defenseless1551895defens__ele_s_s
defenselessly207705defens__elessly
defenselessness1861425defens__elessness
defensives1743865defensiv_____es
definiteness16105045defin_itene_s_s
definitiveness2163795definitivene_s_s
delusiveness1655755de_lusivene_s_s
demandingnesses2061745demandingnesses
dementednesses1853785demen_tednesses
derisiveness1656965de_risivene_s_s
deservednesses19163455dese__rvednesses
diffusenesses2052825diffus__enesses
diffusiveness2353425diffusivene_s_s
diversenesses1754075divers__enesses
dressinesses1245525d_ressi__nesses
effusiveness2154925_effusivene_s_s
entirenesses1249605___entirenesses
exclusivenesses2764615exclusivenesses
excursivenesses2794685excursivenesses
expensiveness2555555expensivene_s_s
explosivenesses2793875explosivenesses
extensiveness2355265extensivene_s_s
femininenesses1952975femin_inenesses
fertilenesses1648005__fertilenesses
fictivenesses2157115__fictivenesses
finitenesses1557695__fin_itenesses
forgivenesses2045835__forgivenesses
furtivenesses1947205__furtivenesses
genuinenesses1475255__genuinenesses
greensicknesses2261465greensicknesses
illusivenesses1755745_illusivenesses
immensenesses1762985immens__enesses
impassivenesses2164095impassivenesses
impulsivenesses2264275impulsivenesses
incisivenesses1966645_incisivenesses
inclusivenesses2065085inclusivenesses
infinitenesses1795015infin_itenesses
intensenesses1356035intens__enesses
intensiveness1667455intensivene_s_s
intrusivenesses1885395intrusivenesses
invasivenesses2055995_invasivenesses
invectivenesses23105995invectivenesses
lifelikenesses2152395life_likenesses
massivenesses1755885__massivenesses
naivenesses1449085____naivenesses
negativenesses1855845ne_gativenesses
objectivenesses2994455objectivenesses
obtrusivenesses2064335obtrusivenesses
passivenesses1746635__passivenesses
pensiveness1648645__pensivene_s_s
plaintivenesses2054295plaintivenesses
purposivenesses2263625purposivenesses
reactivenesses1956915re_activenesses
recessiveness1865905recessivene_s_s
reconditenesses1863145reconditenesses
reductivenesses21145695reductivenesses
requisitenesses2463465requisitenesses
resistivenesses1755745resistivenesses
restivenesses1679415__restivenesses
retentiveness1657135retentivene_s_s
secretivenesses2055665secretivenesses
seductivenesses21145445seductivenesses
sensiblenesses1555225__sensiblenesses
sensitivenesses1775305sensitivenesses
serenenesses12117095seren___enesses
suasivenesses1546775__suasivenesses
tensenesses1147595__tens__enesses
tentativenesses1854785tentativenesses

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 Filter178691658740.236757165.3
2DLD Change Limit658741224.89013471.2
3Display Results1221220.1101109.1
 (SQL Overall)1786911225.23634127.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.