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

114 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
deceptivenesses2312587(None) 
receptivenesses22106031receptivenesses
deceptiveness2155692deceptivene_s_s
defectivenesses2496052defectivenesses
decisivenesses2056723dec_isivenesses
defensivenesses2255743defensivenesses
electivenesses1957583_electivenesses
receptiveness2056123receptivene_s_s
recessivenesses1955773recessivenesses
retentivenesses1896363retentivenesses
secretivenesses2055663secretivenesses
selectivenesses2055983selectivenesses
acceptingnesses2261514acceptingnesses
activenesses1758184_ac__tivenesses
adaptivenesses2054244_adaptivenesses
assertivenesses1754914assertivenesses
attentivenesses1874654attentivenesses
costivenesses1848154__costivenesses
creativenesses1967014_creativenesses
deceitfulnesses2173014deceitfulnesses
defectiveness2256544defectivene_s_s
delusivenesses1856494de_lusivenesses
derisivenesses1857184de_risivenesses
effectivenesses2665064effectivenesses
excessivenesses2675094excessivenesses
festivenesses1998404__festivenesses
fictivenesses2157114fic__tivenesses
invectivenesses23105994invectivenesses
inventivenesses21136224inventivenesses
lucrativenesses2054354lucrativenesses
negativenesses1855844ne_gativenesses
objectivenesses2994454objectivenesses
perceptiveness2354784perceptivene_s_s
reactivenesses1956914re_activenesses
reclusivenesses2055244reclusivenesses
recursivenesses2055304recursivenesses
reductivenesses21145694reductivenesses
resistivenesses1755744resistivenesses
restivenesses1679414__restivenesses
seclusivenesses1965014seclusivenesses
seductivenesses21145444seductivenesses
sensitivenesses1775304sensitivenesses
tentativenesses1854784tentativenesses
abortivenesses1985285_abortivenesses
adhesivenesses2155015adhe_sivenesses
amativenesses1856765__amativenesses
aversivenesses2056525_aversivenesses
citizenesses2345645__c_itizenesses
coercivenesses2165635_coercivenesses
cohesivenesses2256165cohe_sivenesses
combativenesses2464145combativenesses
cursivenesses1847465__cursivenesses
decidednesses1853885dec___idednesses
decisiveness1855925dec_isivene_s_s
decorativeness2054165decorativene_s_s
deepnesses1366675de_ep____nesses
defensiveness20115805defensivene_s_s
definitenesses1864225de_finitenesses
dejectednesses2553045deject_ednesses
dementednesses1853785dement_ednesses
depravednesses2152365d__epravednesses
descriptiveness2362265descriptivene_s_s
deservednesses19163455dese__rvednesses
desperatenesses1863725desperatenesses
destitutenesses1662655destitutenesses
diffusivenesses25103835diffusivenesses
divisivenesses2154925d_ivisivenesses
effusivenesses2355685_effusivenesses
electiveness1757545_electivene_s_s
elusivenesses1697635_e_lusivenesses
emptinesses1545985_e_mpti__nesses
entirenesses1249605___entirenesses
erosivenesses1648245_e_rosivenesses
evasivenesses1957085_e_vasivenesses
evocativenesses2364295evocativenesses
exclusivenesses2764615exclusivenesses
excursivenesses2794685excursivenesses
expensivenesses27105445expensivenesses
extensivenesses2595235extensivenesses
fertilenesses1648005__fertilenesses
fugitivenesses2154425_fugitivenesses
furtivenesses1947205__furtivenesses
imitativenesses2084465imitativenesses
incisivenesses1966645inc_isivenesses
inclusivenesses2065085inclusivenesses
intensivenesses1856245intensivenesses
intuitivenesses1865285intuitivenesses
nativenesses1548535___nativenesses
normativenesses2084515normativenesses
obsessivenesses18104405obsessivenesses
offensivenesses2464535offensivenesses
operativenesses2055755operativenesses
pensivenesses1848955__pensivenesses
pervasivenesses2355155pervasivenesses
petitenesses14169315__pe_titenesses
plaintivenesses2054295plaintivenesses
positivenesses1965945_positivenesses
primitivenesses2263925primitivenesses
promotivenesses22113885promotivenesses
punitivenesses1965625_punitivenesses
recentnesses1465365recent___nesses
recessiveness1865905recessivene_s_s
reconditenesses1863145reconditenesses
reflexivenesses2893375reflexivenesses
repulsivenesses2064855repulsivenesses
retentiveness1657135retentivene_s_s
secretiveness1865855secretivene_s_s
selectiveness1856505selectivene_s_s
sportivenesses1956275_sportivenesses
susceptiveness2163355susceptivene_s_s
talkativenesses2273395talkativenesses
versatilenesses1853625versatilenesses
votivenesses1847555___votivenesses
weepinesses1646135we_ep_i__nesses

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 Limit658741145.00013174.8
3Display Results1141140.123926.8
 (SQL Overall)1786911145.21634258.2
 
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.