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
expensivenesses27105451expensivenesses_
expansivenesses2794482expansivenesses_
extensivenesses2595242extensivenesses_
excessivenesses2675103excessivenesses_
expensiveness2555563expensivene_s_s_
explosivenesses2793883explosivenesses_
pensivenesses1848963__pensivenesses_
defensivenesses2255754defensivenesses_
exclusivenesses2764624exclusivenesses_
excursivenesses2794694excursivenesses_
expansiveness2554274expansivene_s_s_
extensiveness2355274extensivene_s_s_
intensivenesses1856254intensivenesses_
offensivenesses2464544offensivenesses_
adhesivenesses2155025adhe_sivenesses_
attentivenesses1874665attentivenesses_
aversivenesses2056535_aversivenesses_
cohesivenesses2256175cohe_sivenesses_
effectivenesses2665075effectivenesses_
effusivenesses2355695e_ffusivenesses_
electivenesses1957595e_lectivenesses_
elusivenesses1697645e__lusivenesses_
erosivenesses1648255e__rosivenesses_
evasivenesses1957095e__vasivenesses_
excessiveness2554945excessivene_s_s_
explosiveness2553665explosivene_s_s_
expressiveness2664115expressivene_s_s_
exquisitenesses3162735exquisitenesses_
impassivenesses2164095impassivenesses_
impulsivenesses2264275impulsivenesses_
inexpensiveness2762775inexpensivene_s_s_
inventivenesses21136235inventivenesses_
obsessivenesses18104415obsessivenesses_
passivenesses1746635__passivenesses_
pensiveness1648645__pensivene_s_s_
recessivenesses1955785recessivenesses_
repulsivenesses2064855repulsivenesses_
retentivenesses1896375retentivenesses_
abrasivenesses19105526_abrasivenesses_
abusivenesses1856236__abusivenesses_
allusivenesses1755156_allusivenesses_
appositenesses1863696_appositenesses_
assertivenesses1754916assertivenesses_
coercivenesses2165636_coercivenesses_
corrosivenesses2094566corrosivenesses_
creativenesses1967016_creativenesses_
cursivenesses1847466__cursivenesses_
deceptivenesses23125876deceptivenesses_
decisivenesses2056726_decisivenesses_
defectivenesses2496056defectivenesses_
defensiveness20115806defensivene_s_s_
delusivenesses1856496_delusivenesses_
densenesses1247356__dens__enesses_
derisivenesses1857186_derisivenesses_
diffusivenesses25103836diffusivenesses_
divisivenesses2154926_divisivenesses_
entirenesses1249606___entirenesses_
essentialnesses1462616essentialnesses_
evocativenesses2364296evocativenesses_
exclusiveness2554476exclusivene_s_s_
excursiveness2554536excursivene_s_s_
expectednesses2662916expe_ctednesses_
expertnesses2144816expe___rtnesses_
explicitnesses2561286explici_tnesses_
extendednesses2362626exten_dednesses_
festivenesses1998406__festivenesses_
genuinenesses1475256__genuinenesses_
greensicknesses2261466greensicknesses_
illusivenesses1755746_illusivenesses_
immensenesses1762986immens__enesses_
incisivenesses1966646_incisivenesses_
inclusivenesses2065086inclusivenesses_
intensenesses1356046intens__enesses_
intensiveness1667466intensivene_s_s_
intrusivenesses1885406intrusivenesses_
invasivenesses2055996_invasivenesses_
invectivenesses23105996invectivenesses_
massivenesses1755886__massivenesses_
naivenesses1449086____naivenesses_
objectivenesses2994456objectivenesses_
obtrusivenesses2064346obtrusivenesses_
offensiveness2274236offensivene_s_s_
operativenesses2055756_operativenesses_
oppositenesses1854176_oppositenesses_
pervasivenesses2355156pervasivenesses_
petitenesses14169316__pe_titenesses_
plaintivenesses2054296plaintivenesses_
punitivenesses1965626__punitivenesses_
purposivenesses2263626purposivenesses_
receptivenesses22106036receptivenesses_
reclusivenesses2055246reclusivenesses_
recursivenesses2055306recursivenesses_
reflexivenesses2893376refle_xivenesses_
responsiveness1963186responsivene_s_s_
restivenesses1679416__restivenesses_
seclusivenesses1965016seclusivenesses_
secretivenesses2055666secre_tivenesses_
selectivenesses2055986selectivenesses_
sensiblenesses1555226__sensiblenesses_
sensitivenesses1775306__sensitivenesses_
sportivenesses1956276_sportivenesses_
suasivenesses1546776__suasivenesses_
tensenesses1147606__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.0931921408.6
2DLD Change Limit658741035.78311391.0
3Display Results1031030.0901144.4
 (SQL Overall)1786911035.96629951.6
 
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.