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

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
extensivenesses259526(None) 
expensivenesses27105471expensivenesses
excessivenesses2675122excessivenesses
expansivenesses2794502expansivenesses
extensiveness2355282extensivene_s_s
intensivenesses1856262intensivenesses
attentivenesses1874663attentivenesses
defensivenesses2255763defensivenesses
exclusivenesses2764643exclusivenesses
excursivenesses2794713excursivenesses
expensiveness2555573expensivene_s_s
explosivenesses2793903explosivenesses
offensivenesses2464553offensivenesses
pensivenesses1848973__pensivenesses
retentivenesses1896373retentivenesses
adhesivenesses2155034adhe_sivenesses
aversivenesses2056544_aversivenesses
cohesivenesses2256184cohe_sivenesses
effectivenesses2665084effectivenesses
effusivenesses2355714e_ffusivenesses
electivenesses1957604e_lectivenesses
elusivenesses1697664e__lusivenesses
erosivenesses1648274e__rosivenesses
evasivenesses1957114e__vasivenesses
excessiveness2554954excessivene_s_s
expansiveness2554284expansivene_s_s
exquisitenesses3162754exquisitenesses
extendednesses2362624exten_dednesses
intensenesses1356044intens__enesses
intensiveness1667464intensivene_s_s
intrusivenesses1885424intrusivenesses
inventivenesses21136234inventivenesses
obsessivenesses18104424obsessivenesses
obtrusivenesses2064354obtrusivenesses
recessivenesses1955794recessivenesses
tensenesses1147604__tens__enesses
abrasivenesses19105535_abrasivenesses
abusivenesses1856265__abusivenesses
activenesses1758185act___ivenesses
allusivenesses1755175_allusivenesses
assertivenesses1754915assertivenesses
attentiveness1665135attentivene_s_s
coercivenesses2165635_coercivenesses
corrosivenesses2094575corrosivenesses
creativenesses1967015_creativenesses
cursivenesses1847485__cursivenesses
deceptivenesses23125875deceptivenesses
decisivenesses2056745_decisivenesses
defectivenesses2496055defectivenesses
defensiveness20115805defensivene_s_s
delusivenesses1856515_delusivenesses
densenesses1247355__dens__enesses
derisivenesses1857205_derisivenesses
diffusivenesses25103845diffusivenesses
divisivenesses2154945_divisivenesses
entirenesses1249615___entirenesses
essentialnesses1462625essentialnesses
evocativenesses2364305evocativenesses
exclusiveness2554485exclusivene_s_s
excursiveness2554555excursivene_s_s
explosiveness2553675explosivene_s_s
expressiveness2664115expressivene_s_s
extremenesses2252855ext__remenesses
festivenesses1998405__festivenesses
genuinenesses1475265__genuinenesses
greensicknesses2261465greensicknesses
illusivenesses1755765_illusivenesses
immensenesses1762985immens__enesses
impassivenesses2164105impassivenesses
impulsivenesses2264295impulsivenesses
incisivenesses1966665_incisivenesses
inclusivenesses2065095inclusivenesses
inexpensiveness2762775inexpensivene_s_s
intuitivenesses1865305intuitivenesses
invasivenesses2056005_invasivenesses
invectivenesses23105995invectivenesses
massivenesses1755895__massivenesses
naivenesses1449085____naivenesses
nativenesses1548535nat___ivenesses
objectivenesses2994455objectivenesses
offensiveness2274235offensivene_s_s
passivenesses1746645__passivenesses
pensiveness1648645__pensivene_s_s
pervasivenesses2355165pervasivenesses
plaintivenesses2054295plaintivenesses
purposivenesses2263635purposivenesses
receptivenesses22106035receptivenesses
reclusivenesses2055265reclusivenesses
recursivenesses2055325recursivenesses
reflexivenesses2893375refle_xivenesses
repulsivenesses2064875repulsivenesses
restivenesses1679415__restivenesses
retentiveness1657145retentivene_s_s
seclusivenesses1965035seclusivenesses
secretivenesses2055665secre_tivenesses
selectivenesses2055985selectivenesses
sensiblenesses1555225__sensiblenesses
sensitivenesses1775315__sensitivenesses
suasivenesses1546795__suasivenesses
tenablenesses1546625__tenablenesses
tentativenesses1854785tent_ativenesses
tersenesses1149025__ters__enesses
votivenesses1847555vot___ivenesses

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.0931921408.6
2DLD Change Limit658741034.45314793.2
3Display Results1031030.0761355.3
 (SQL Overall)1786911034.62238661.0
 
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.