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

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

73 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
dastardlinesses1761831dastardlinesses_
dastardliness1561373dastardline_s_s_
masterlinesses1673524master_linesses_
cowardlinesses2052515_cowardlinesses_
deadlinesses1446225d__ea_dlinesses_
niggardlinesses1871355niggardlinesses_
pastoralnesses1653135pastoral_nesses_
starchinesses1843215__starchinesses_
statelinesses1344235__statelinesses_
sturdinesses1345795__sturd_inesses_
tardinesses121110245___tard_inesses_
towardlinesses1851915_towardlinesses_
bastardises1473486bastard_i___ses_
beastlinesses1563426beast___linesses_
beggarlinesses1871886beggar_linesses_
casualnesses1443786casua__l_nesses_
costlinesses1446256cost___linesses_
dailinesses1249496d___a_ilinesses_
damnablenesses1954616damna_blenesses_
datednesses1357906da_t_ed__nesses_
desirablenesses1855616desirablenesses_
dismalnesses1553986disma__l_nesses_
disparatenesses18122886disparatenesses_
distantnesses1453836dista__ntnesses_
drearinesses1347446d_rear__inesses_
dustinesses121110356dust____inesses_
earlinesses11311046___ear_linesses_
earthlinesses1643916eart__hlinesses_
fatalnesses1456286fa_ta__l_nesses_
fatherlinesses2052616fa_therlinesses_
ghastlinesses1742746ghast___linesses_
haggardnesses1952256haggard__nesses_
hardinesses151110216___hard_inesses_
hastinesses141210696hast____inesses_
laggardnesses1652396laggard__nesses_
lordlinesses1345176___lordlinesses_
mannerlinesses1652406manner_linesses_
masterfulnesses2053296masterfulnesses_
masterliness1463836master_line_s_s_
miserlinesses1554666mis_er_linesses_
nastinesses111110746nast____inesses_
naturalnesses1354256na_tural_nesses_
painterlinesses1792016painter_linesses_
paltrinesses1445516palt_r__inesses_
pastinesses13911716past____inesses_
salutarinesses1462776salutar__inesses_
sandinesses12911396__s_and_inesses_
scalinesses1339326__sca__linesses_
scarinesses1339906__scar__inesses_
shadinesses1538646__sha_d_inesses_
shapelinesses1843416__shapelinesses_
smarminesses1645106__smar_minesses_
stablenesses1448106__sta_blenesses_
staginesses1238466__sta__ginesses_
staidnesses1237196__staid__nesses_
stalenesses11311106__sta__lenesses_
starknesses1545886__star__knesses_
steadinesses1346906__stead_inesses_
steelinesses1246726__st_eelinesses_
stodginesses1443946__st_odginesses_
storminesses1445036__stor_minesses_
surlinesses11310056__s_ur_linesses_
swarthinesses1943456__swarthinesses_
tarrinesses11129086___tar_rinesses_
tartinesses111011506___tar_tinesses_
tastefulnesses1754606tasteful_nesses_
tastinesses111110786tast____inesses_
tawdrinesses1643436___tawdrinesses_
unstablenesses1656036unsta_blenesses_
unsteadinesses1553066unstead_inesses_
wastefulnesses2054526wasteful_nesses_
waterinesses1567196wa_ter__inesses_
waywardnesses2351766wayward__nesses_

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.326548131.9
2DLD Change Limit65874734.33015213.4
3Display Results73730.0461587.0
 (SQL Overall)178691734.70238003.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.