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

154 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
selfness113515(None) 
selfless1135011selfless
deafness1236212deafness
fellness1135912fellness
halfness1435562halfness
saltness82610242saltness
selfnesses1335892selfnesses
sexiness1537942sexiness
slyness1035262s_lyness
soleness8814262soleness
wellness1135792wellness
baldness1137043baldness
beefiness1435583beefiness
beefless1335493beefless
beltless10297713beltless
boldness1136973boldness
calmness1236643calmness
coldness1137953coldness
deadness1039233deadness
dearness939973dearness
deepness1136443deepness
deftness1236303deftness
demoness1138053demoness
dewiness1238453dewiness
dullness934873dullness
dulness8307983dul_ness
eeriness8311873eeriness
eldress835003_eldress
felines104718073feline_s
fewness1335003fe_wness
feyness1334923fe_yness
fullness1135443fullness
fulness10248963ful_ness
gelidness1144473gelidness
glegness1034613glegness
haleness11312623haleness
helmless1334273helmless
helpless1335063helpless
holiness112512503holiness
idleness936843idleness
illness736473_illness
keenness1234883keenness
leafiness1236483leafiness
leafless11246573leafless
leanness837373leanness
lewdness1254173lewdness
maleness10312313maleness
mealiness11310063mealiness
meanness1037183meanness
meekness1434303meekness
meetness1036653meetness
mildness1136523mildness
nearness838313nearness
neatness839153neatness
newness1035703ne_wness
oiliness8311563oiliness
oldness836403_oldness
paleness10312983paleness
peltless10267373peltless
pertness10310093pertness
realness8410443realness
redness82012443re_dness
relines75331323reline_s
sadness8310613s_adness
safeness11239633safeness
sageness92111983sageness
salines74029413saline_s
saltiness93312113saltiness
saltless8259343saltless
sameness102712683sameness
saneness82313723saneness
scaliness1149303scaliness
seaminess11310473seaminess
seamless10238723seamless
seatless83213003seatless
seediness10219173seediness
seedless9319513seedless
seemliness1244153seemliness
seeress7311573se_eress
seiners74219273se_iners
seines65029903se_ine_s
selectness1245453selectness
selenoses947463selenoses
selenosis945443selenosis
selenous848973selenous
selfdoms1443683selfdoms
selfed10310913self_e_d
selfheal1442413selfheal
selfheals1541933selfheals
selfish1388513self_ish
selfishness1743813selfishness
selflessly1642623selflessly
selfs85220243self___s
selkies113513353selkie_s
sellers73721313sel_lers
selles64426983sel_le_s
seltzers1735063seltzers
selves94119613sel_ve_s
sennets73712583se_nnets
senses63923943se__nses
serenes73222903serene_s
serenest82717623serenest
serines74229543serine_s
setlines8312743setline_s
sexless1467243se_xless
sheerness1236273sheerness
shyness1344993s_hyness
sickness1437833sickness
silanes72517163silane_s
silkiness1337253silkiness
silliness9510363silliness
siziness1737423siziness
skewness1533763skewness
sleekness1344543sleekness
slimness1036523slimness
slowness1135013slowness
smallness1174513smallness
smugness1143813smugness
snubness1044373snubness
snugness934323snugness
softness1136433softness
soleless8910033soleless
solidness1036903solidness
solonets838233solonets
soreness8914793soreness
sourness839543sourness
splines94718893spline_s
spryness1334003spryness
staleness9310783staleness
steeliness1046793steeliness
steepness1145723steepness
sternness946093sternness
stiffness1543553stiffness
stillness936103stillness
suchness1335763suchness
sulfones1147683sulfone_s
sulkiness1347353sulkiness
sultaness945613sultaness
sureness8912903sureness
surliness939943surliness
svelteness1344423svelteness
sweetness1245683sweetness
swiftness1543653swiftness
tallness837103tallness
telfers10299073telf_ers
telnets738373tel_nets
ugliness936863ugliness
useless7188423usel__ess
vileness1139983vileness
weakness1535353weakness
weldless12285813weldless
wetness10277723we_tness
wildness1236203wildness
wiliness1139113wiliness

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621547.84618628.9
3Display Results1541540.0632444.4
 (SQL Overall)1786911548.32921454.1
 
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.