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

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

100 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
sternness94609(None) 
starkness1335962starkness
steepness1145722steepness
sternest8314432ster_nest
sternnesses1146632sternnesses
alertness946053alertness
austereness1154293austereness
beeriness1137863beeriness
cleanness1144973cleanness
eeriness8311873_eeriness
eternalness1153823eternalness
eternises9119453eternises
evenness1135543eve_nness
fernless1136063_fernless
fieriness1238623fieriness
greenness1046793greenness
inertness947973inertness
keenness1234883_keenness
leanness837373_leanness
leeriness938323leeriness
lornness836493_lornness
meanness1037183_meanness
modernness1343523modernness
openness1035473ope_nness
otherness1245513other_ness
overtness1238223overtness
pertness10310093_pertness
scariness11310183scariness
seediness10219173seediness
seeress7311573seer__ess
selfness1135153s_elfness
sennets73712583s_e_nnets
sereneness1047133s_ereneness
serenes73222903s_erene_s
serenest82717623s_erenest
serines74229543s_erine_s
severeness1346123severeness
sexiness1537943s_exiness
sharpness1434933sharpness
sheerness1236273sheerness
shortness1236733shortness
skewness1533763ske_wness
sleekness1344543sleekness
smartness1136143smartness
soberness1186463sober_ness
solemnness1243213solemnness
soreness8914793s_oreness
sorriness939583sorriness
sourness839543sour_ness
southernness1552483southernness
spareness1139863spareness
spryness1334003s_pryness
staginess1038753staginess
staidness1037033staidness
stainless9176493stainless
staleness9310783staleness
starless81610843star_less
starnoses9157153starnoses
steadiness1146703steadiness
steaminess1236773steaminess
stearines9311283stearine_s
steeliness1046793steeliness
stemless1036653ste_mless
stenoses8310443ste_noses
stereos74314973ster__eos
steres63929533ster__e_s
sterlets8169273ster_lets
sterlingness1383383sterlingness
sterner7411913ster_ne_r
sternites9310073sternites
sternmost1144323sternmost
sternpost1144233sternpost
sternposts1252503sternposts
sterns64616763ster_n__s
sternsons944663sternsons
sternums1045783ster_nums
sternways1542593sternways
stiffness1543553stiffness
stillness936103stillness
stoniness938343stoniness
storminess1245213storminess
stoutness945863stoutness
stress66616673st_r__ess
stunners8277923st_unners
sturdiness1144843sturdiness
styrenes11116623styrene_s
superbness1446663superbness
sureness8912903s_ureness
swartness1236113swartness
sweetness1245683sweetness
tartness82210133_tartness
teariness9310633_teariness
tenners74014923_te_nners
termless1036233_termless
ternes65422903_ter_ne_s
terseness948403_terseness
thinness11277163_thinness
utterness946223utter_ness
wateriness1348073wateriness
wornness1136363_wornness

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.423422437.4
2DLD Change Limit1486411006.57622603.6
3Display Results1001000.0502000.0
 (SQL Overall)1786911007.04925349.8
 
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.