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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

99 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
excursivenesses279468(None) 
cursivenesses1847462__cursivenesses
excessivenesses2675092excessivenesses
exclusivenesses2764612exclusivenesses
excursiveness2554532excursivene_s_s
recursivenesses2055302recursivenesses
effusivenesses2355683effu_sivenesses
elusivenesses1697633e_lu_sivenesses
expansivenesses2794473expansivenesses
expensivenesses27105443expensivenesses
explosivenesses2793873explosivenesses
exquisitenesses3162723exquisitenesses
extensivenesses2595233extensivenesses
abusivenesses1856234_abu_sivenesses
allusivenesses1755154allu_sivenesses
aversivenesses2056524_aversivenesses
cursiveness1647064__cursivene_s_s
decisivenesses2056724dec_isivenesses
delusivenesses1856494delu_sivenesses
erosivenesses1648244e__rosivenesses
evasivenesses1957084e__vasivenesses
excessiveness2554934excessivene_s_s
exclusiveness2554474exclusivene_s_s
excusablenesses2663964excusablenesses
furtivenesses1947204__furtivenesses
illusivenesses1755744illu_sivenesses
impulsivenesses2264274impulsivenesses
incisivenesses1966644inc_isivenesses
inclusivenesses2065084inclusivenesses
intrusivenesses1885394intrusivenesses
obtrusivenesses2064334obtrusivenesses
recessivenesses1955774recessivenesses
reclusivenesses2055244reclusivenesses
recursiveness1855394recursivene_s_s
repulsivenesses2064854repulsivenesses
seclusivenesses1965014seclusivenesses
suasivenesses1546774__suasivenesses
abortivenesses1985285_abortivenesses
abrasivenesses19105525_abrasivenesses
accuratenesses1853075accur_atenesses
accursednesses1961765accurs_ednesses
activenesses1758185_ac__tivenesses
adhesivenesses2155015_adhesivenesses
assertivenesses1754915assertivenesses
coercivenesses2165635_coercivenesses
cohesivenesses2256165_cohesivenesses
corrosivenesses2094565corrosivenesses
costivenesses1848155__costivenesses
curablenesses17146955__curablenesses
curlinesses1338725__curli__nesses
cursednesses1554965__curs_ednesses
cursorinesses1553285__cursorinesses
deceptivenesses23125875deceptivenesses
defensivenesses2255745defensivenesses
derisivenesses1857185_derisivenesses
diffusivenesses25103835diffusivenesses
discursiveness20103295discursivene_s_s
divisivenesses2154925_divisivenesses
effectivenesses2665065effectivenesses
effusiveness2154925effu_sivene_s_s
electivenesses1957585e_lectivenesses
elusiveness1466595e_lu_sivene_s_s
enduringnesses1662475endur_ingnesses
evocativenesses2364295evocativenesses
excitablenesses2664525excitablenesses
excursionists2282725excursi_on_ists
execrablenesses2674165execrablenesses
expansiveness2554265expansivene_s_s
expensiveness2555555expensivene_s_s
explosiveness2553665explosivene_s_s
exquisiteness2962545exquisitene_s_s
extensiveness2355265extensivene_s_s
extremenesses2252845ex_tr_emenesses
fictivenesses2157115fic__tivenesses
forgivenesses2045835__forgivenesses
impassivenesses2164095impassivenesses
intensivenesses1856245intensivenesses
intuitivenesses1865285intuitivenesses
invasivenesses2055995_invasivenesses
lucrativenesses2054355lucrativenesses
massivenesses1755885__massivenesses
mercurialnesses1981415mercur_ialnesses
obsessivenesses18104405obsessivenesses
offensivenesses2464535offensivenesses
passivenesses1746635__passivenesses
pensivenesses1848955__pensivenesses
percussiveness2193735percussivene_s_s
pervasivenesses2355155pervasivenesses
purposivenesses2263625purposivenesses
pursinesses1338725__pursi__nesses
reactivenesses1956915reac__tivenesses
receptivenesses22106035receptivenesses
reductivenesses21145695reductivenesses
requisitenesses2463465requisitenesses
scurvinesses1743925_scur__vinesses
secretivenesses2055665secretivenesses
securenesses1445665secur___enesses
seductivenesses21145445seductivenesses
sportivenesses1956275_sportivenesses

Search took 8 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 Limit65874996.8909560.8
3Display Results99990.156634.6
 (SQL Overall)178691997.13925030.3
 
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.