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

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

103 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
expensivenesses27105491expensivenesses_
expansivenesses2794522expansivenesses_
extensivenesses2595282extensivenesses_
excessivenesses2675143excessivenesses_
expensiveness2555583expensivene_s_s_
explosivenesses2793923explosivenesses_
pensivenesses1849023__pensivenesses_
defensivenesses2255784defensivenesses_
exclusivenesses2764664exclusivenesses_
excursivenesses2794734excursivenesses_
expansiveness2554304expansivene_s_s_
extensiveness2355304extensivene_s_s_
intensivenesses1856284intensivenesses_
offensivenesses2464574offensivenesses_
adhesivenesses2155055adhe_sivenesses_
attentivenesses1874695attentivenesses_
aversivenesses2056565_aversivenesses_
cohesivenesses2256205cohe_sivenesses_
effectivenesses2665105effectivenesses_
effusivenesses2355745e_ffusivenesses_
electivenesses1957645e_lectivenesses_
elusivenesses1697705e__lusivenesses_
erosivenesses1648315e__rosivenesses_
evasivenesses1957145e__vasivenesses_
excessiveness2554965excessivene_s_s_
explosiveness2553685explosivene_s_s_
expressiveness2664125expressivene_s_s_
exquisitenesses3162795exquisitenesses_
impassivenesses2164125impassivenesses_
impulsivenesses2264315impulsivenesses_
inexpensiveness2762785inexpensivene_s_s_
inventivenesses21136255inventivenesses_
obsessivenesses18104445obsessivenesses_
passivenesses1746665__passivenesses_
pensiveness1648655__pensivene_s_s_
recessivenesses1955815recessivenesses_
repulsivenesses2064895repulsivenesses_
retentivenesses1896405retentivenesses_
abrasivenesses19105556_abrasivenesses_
abusivenesses1856296__abusivenesses_
allusivenesses1755196_allusivenesses_
appositenesses1863716_appositenesses_
assertivenesses1754936assertivenesses_
coercivenesses2165656_coercivenesses_
corrosivenesses2094596corrosivenesses_
creativenesses1967036_creativenesses_
cursivenesses1847506__cursivenesses_
deceptivenesses23125896deceptivenesses_
decisivenesses2056766_decisivenesses_
defectivenesses2496076defectivenesses_
defensiveness20115816defensivene_s_s_
delusivenesses1856546_delusivenesses_
densenesses1247366__dens__enesses_
derisivenesses1857236_derisivenesses_
diffusivenesses25103866diffusivenesses_
divisivenesses2154966_divisivenesses_
entirenesses1249666___entirenesses_
essentialnesses1462646essentialnesses_
evocativenesses2364346evocativenesses_
exclusiveness2554496exclusivene_s_s_
excursiveness2554566excursivene_s_s_
expectednesses2662956expe_ctednesses_
expertnesses2144846expe___rtnesses_
explicitnesses2561316explici_tnesses_
extendednesses2362656exten_dednesses_
festivenesses1998436__festivenesses_
genuinenesses1475306__genuinenesses_
greensicknesses2261476greensicknesses_
illusivenesses1755786_illusivenesses_
immensenesses1762996immens__enesses_
incisivenesses1966686_incisivenesses_
inclusivenesses2065116inclusivenesses_
intensenesses1356056intens__enesses_
intensiveness1667486intensivene_s_s_
intrusivenesses1885446intrusivenesses_
invasivenesses2056026_invasivenesses_
invectivenesses23106016invectivenesses_
massivenesses1755916__massivenesses_
naivenesses1449116____naivenesses_
objectivenesses2994476objectivenesses_
obtrusivenesses2064376obtrusivenesses_
offensiveness2274246offensivene_s_s_
operativenesses2055776_operativenesses_
oppositenesses1854206_oppositenesses_
pervasivenesses2355206pervasivenesses_
petitenesses14169366__pe_titenesses_
plaintivenesses2054316plaintivenesses_
punitivenesses1965656__punitivenesses_
purposivenesses2263656purposivenesses_
receptivenesses22106056receptivenesses_
reclusivenesses2055286reclusivenesses_
recursivenesses2055346recursivenesses_
reflexivenesses2893396refle_xivenesses_
responsiveness1963196responsivene_s_s_
restivenesses1679446__restivenesses_
seclusivenesses1965056seclusivenesses_
secretivenesses2055686secre_tivenesses_
selectivenesses2056006selectivenesses_
sensiblenesses1555256__sensiblenesses_
sensitivenesses1775356__sensitivenesses_
sportivenesses1956286_sportivenesses_
suasivenesses1546826__suasivenesses_
tensenesses1147616__tens__enesses_

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.326548131.9
2DLD Change Limit658741034.69014045.6
3Display Results1031030.0761355.3
 (SQL Overall)1786911035.09235092.5
 
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.