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

104 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
discretenesses175336(None) 
discreetnesses1762421discreetnesses
discreteness1554462discretene_s_s
concretenesses1854153concretenesses
discreetness1553013discreetne_s_s
disparatenesses18122883disparatenesses
desolatenesses1553964desolatenesses
desperatenesses1863724desperatenesses
dilutenesses1346104di__lutenesses
directednesses1863354di__rectednesses
directnesses1595264di__rectnesses
direnesses11311484di__r__enesses
dirtinesses1239874di__r_tinesses
dissolutenesses1561994dissolutenesses
distantnesses1453824distant_nesses
diversenesses1754074diver_senesses
iratenesses11411404_i__ratenesses
literatenesses1464774literatenesses
obsoletenesses1662224obsoletenesses
screwinesses1744744__screwinesses
serenenesses12117094__serenenesses
sincerenesses1554724sinc_erenesses
absolutenesses1662405absolutenesses
abstrusenesses1552555abstrusenesses
accuratenesses1853075accuratenesses
acutenesses13126955__ac_utenesses
assurednesses1352605assure_dnesses
astutenesses1245585_as_tutenesses
austerenesses1354155aus_terenesses
bizarrenesses2451995bizar_renesses
completenesses2053985completenesses
concertednesses2064185concertednesses
concreteness1655055concretene_s_s
contritenesses1655475contritenesses
crudenesses1476655___crudenesses
cutenesses12910875___c_utenesses
definitenesses1864225definitenesses
demurenesses1544745demur__enesses
deservednesses19163455deservednesses
desirablenesses1855585desirablenesses
desirousnesses1456845desirousnesses
destitutenesses1662655destitutenesses
differentnesses2271765differentnesses
diffusenesses2052825di_ffusenesses
directresses15123085di__rectresses
discreetest1453915discre_ete_s_t
discrepancies2061775discrepan_cies
dismalnesses1553975dis__malnesses
disparateness1684185disparatene_s_s
distinctnesses1752555distinctnesses
distresses1148845dis___t_resses
dividednesses1952905divide_dnesses
divisivenesses2154925divisivenesses
dustinesses121110335dus___tinesses
effetenesses1854485__effetenesses
extremenesses2252845_extremenesses
ficklenesses2144135fi_c_klenesses
fictivenesses2157115fi_ctivenesses
fidgetinesses1851885fi_dgetinesses
fiercenesses1744295fi_er_cenesses
finitenesses1557695fi__nitenesses
firstnesses1445735fi__rst_nesses
freenesses1339865___fre_enesses
hirsutenesses1653565hi_rsutenesses
inchoatenesses1953585_inchoatenesses
indiscreetness1771425indiscreetne_s_s
inertnesses1198715_iner_t_nesses
innatenesses1247175_i_nnatenesses
leisurelinesses1581045leisurelinesses
licitnesses1346395li_c_it_nesses
lissomenesses1453475lis_somenesses
listlessnesses1266915listlessnesses
litenesses10513005li____tenesses
minutenesses1476165mi__nutenesses
miserablenesses1954645miserablenesses
miserlinesses1554665miser_linesses
mistinesses131310605mis___tinesses
moderatenesses1764385moderatenesses
nicenesses12310335ni_c___enesses
obduratenesses1752895obduratenesses
obscurenesses1752735obsc_urenesses
repletenesses1554475_repletenesses
resolutenesses1493485resolutenesses
sacrednesses1544865_sacre_dnesses
scantinesses1437315__scantinesses
scantnesses1376535__scant_nesses
scarcenesses1644495__scarcenesses
secretivenesses2055665_secretivenesses
sedatenesses1346945__sedatenesses
separatenesses1654255separatenesses
severenesses1545585__severenesses
shrewdnesses1942925__shrewdnesses
sorenesses101313485__sor__enesses
sprucenesses1694615__sprucenesses
supremenesses1753175_supremenesses
surenesses101212205__sur__enesses
sveltenesses1545215__sveltenesses
sweetnesses1445725__sweet_nesses
tirednesses1247735ti__re_dnesses
tritenesses11710355___tritenesses
viscousnesses1785985visc_ousnesses
visiblenesses1855295vis_iblenesses
wickednesses2243275wi_cke_dnesses
wisenesses13310805wis____enesses

Search took 9 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 Filter178691950240.1231452772.4
2DLD Change Limit950241048.00011878.0
3Display Results1041040.143727.3
 (SQL Overall)1786911048.26621617.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.