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

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

92 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
staunchness165169(None) 
staunches1444602staunch_e_s
staunchest1543122staunch_est
staunchnesses1851462staunchnesses
paunchiness1842343_paunchiness
raunchiness1642883_raunchiness
sauciness1138043s_au_ciness
stanchers14206813sta_nch_ers
stanches132312793sta_nch_e_s
stanchest14218213sta_nch_est
starchiness1643943sta_rchiness
staunched1553473staunch_e_d
stauncher1443513staunch_e_r
suchness1335763s__u_chness
archness1337514__a_rchness
branchless1743304bra_nchless
butchness1643454__butchness
chanciness1745124cha_nciness
craunches1655724craunch_e_s
crunchiness1843284_crunchiness
fanciness1437674_fa_nciness
gaucheness1642774_gau_cheness
gauntness1044204_gaun_tness
haunches1656964_haunch_e_s
jauntiness1743974_jauntiness
launchers1454334_launch_ers
launches1387914_launch_e_s
muchness1534074__mu_chness
paunches1568184_paunch_e_s
paunchiest1743854_paunchiest
punchless1643654__punchless
ranchless1444454_ra_nchless
raunches1368054_raunch_e_s
raunchiest1543934_raunchiest
sandiness102111714s_a_ndiness
saneness82313724s_a_n_eness
scantiness1236884sca_ntiness
scantness1135734sca_n_tness
scarceness1444764sca_rceness
scrunches1635404scrunch_e_s
scrunchies1744354scrunchie_s
searchless1543374sea_rchless
seasickness1752664seasickness
slackness1535434sla__ckness
slanginess1146274sla_nginess
slavishness1753704slavishness
slouchiness1642654slou_chiness
soundness1036964s_oun_dness
spaciness1337084spa__ciness
spruceness1444104spru_ceness
spunkiness1644174s_punkiness
stableness1248824sta_bleness
stackless1555934sta__ckless
staginess1038754sta__giness
staidness1037034sta__idness
stainless9176504stain__less
staleness9310784sta__leness
stances93715964sta_nc__e_s
stanched14208904sta_nch_e_d
stancher13198814sta_nch_e_r
stanchions1543664sta_nchions
stanines85115674sta_n_ine_s
starches131912914sta_rch_e_s
starchiest1547194sta_rchiest
starkness1335964sta__rkness
stateliness1144234stateliness
staunch1244274staunch____
staunching1643214staunch_ing
staunchly1742034staunch__ly
stenches132110294st_ench_e_s
stenchiest1545084st_enchiest
sternness946094stern__ness
stinginess1145954st_inginess
stoniness938344st_on_iness
stoutness945864stou__tness
strangeness1246104strangeness
strictness1245644st_rictness
stringiness1245274stringiness
stuffiness1643694st_uffiness
stunners8277924st_un__ners
stuntedness1244064st_untedness
stupidness1343034st_upidness
sturdiness1144844st_urdiness
stylishness1743444stylishness
sunniness9247944s__unniness
swainishness1852294swainishness
swankiness1744254swa_nkiness
tanginess10239284_ta_nginess
tautness8217184_tau__tness
tawniness1245124_tawn_iness
touchiness1544614_tou_chiness
toughness1355094_tou_ghness

Search took 10 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 Filter1786911488190.436409841.7
2DLD Change Limit148819929.20316170.7
3Display Results92920.0462000.0
 (SQL Overall)178691929.68518450.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.