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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

146 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
starkness133596(None) 
darkness13247342_darkness
scariness11310182scariness
sharpness1434932sharpness
slackness1535432slackness
smartness1136142smartness
spareness1139862spareness
stackless1555932stackless
staginess1038752staginess
staidness1037032staidness
staleness9310782staleness
stalkless1333722stalkless
starkers123712392stark_ers
starkest1239722stark_est
starknesses1545882starknesses
starless81610842star_less
sternness946092sternness
swartness1236112swartness
tartness82210132_tartness
apartness1146053apartness
awareness1236343awareness
bareness10912813_bareness
barkless14318023_barkless
baroness101210063_baroness
blackness1735663blackness
blankness1544673blankness
chariness14310063chariness
dankness13256693_dankness
dearness939973dear_ness
dwarfness1642793dwarfness
farness102912203_far_ness
frankness1655223frankness
glariness1038553glariness
hardness122411083_hardness
harness102413933_har_ness
hoariness1238823hoariness
lankness12237043_lankness
larkiness1338113_larkiness
nearness838313near_ness
packness1636933_packness
patroness1137483patroness
peartness1137773peartness
rankness12267943_rankness
rareness81112853_rareness
sadness8310613s_a_dness
safeness11239633s_afeness
sageness92111983s_ageness
saltness82610243s_altness
sameness102712683s_ameness
saneness82313723s_aneness
sarkiest123615063s_arkiest
sarsnets836783s_arsnets
scaliness1149303scaliness
scantness1135733scantness
scarceness1444763scarceness
scarless10189053scar_less
seaminess11310473seaminess
shadiness1337463shadiness
shakiness1637083shakiness
sharkers154011053shark_ers
shortness1236733shortness
sickness1437833s_ickness
slatiness92511363slatiness
sleekness1344543sleekness
slickness1535903slickness
smallness1174513smallness
smarminess1444303smarminess
snakiness1367473snakiness
snarkiest13207633snarkiest
soapiness1138293soapiness
soreness8914793s_oreness
sorriness939583sorriness
sourness839543sour_ness
spaciness1337083spaciness
sparkers144111313spark_ers
sparkiest15188093sparkiest
sparklers15315643sparklers
sparkles143210493sparkle_s
sparklets15275843sparklets
sparseness1245493sparseness
spryness1334003s_pryness
squareness1944763squareness
stableness1248823stableness
stackers143413563stack_ers
stainers83212173sta_iners
stainless9176493stainless
stairless9185623stairless
stakes103927293sta_k_e_s
stalkers12369853stalk_ers
stalkiest1347903stalkiest
stampless1334543stampless
stanes64933403sta__ne_s
stanines85115673stanine_s
starches131912913starche_s
starchiness1643943starchiness
starers74522313star__ers
stares66038753star__e_s
starets73515923star__ets
starker114114693stark_e_r
starlets81610083star_lets
starnose8136693star_nose
starnoses9157153star_noses
starriest9159763starriest
starters83714773star_ters
startlers9236743startlers
startles82111963startle_s
starvers11459643star_vers
starves104614553star_ve_s
stateless937563stateless
steadiness1146703steadiness
steaminess1236773steaminess
stearines9311283stearine_s
steepness1145723steepness
sternest8314433ster_nest
stickiness1635903stickiness
stiffness1543553stiffness
stillness936103stillness
stockiness1645243stockiness
stoniness938343stoniness
storminess1245213storminess
stoutness945863stoutness
strainers9510383strainers
straitness1046293straitness
strakes114218073strak_e_s
strapless1135793strapless
stress66616673st_r__ess
sturdiness1144843sturdiness
styrenes11116623styrene_s
suaveness1247703suaveness
sureness8912903s_ureness
swankiness1744253swankiness
tackiness1557693_tackiness
tackless14419483_tackless
talkiness1356913_talkiness
tallness837103_tallness
tameness102411253_tameness
tankless12267823_tankless
tardiness10229913_tardiness
tarriness9229243_tarriness
tartiness92112053_tartiness
tautness8217183_tautness
teariness9310633teariness
wariness11313213_wariness
warmness1337063_warmness
weakness1535353wea_kness
weariness1238843weariness

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 Filter1786911486410.1531167915.0
2DLD Change Limit1486411466.81321817.3
3Display Results1461460.0632317.5
 (SQL Overall)1786911467.02925422.0
 
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.