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

104 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
sweetness124568(None) 
fleetness1244752fleetness
meetness1036652_meetness
sheerness1236272sheerness
sheetless1235822sheetless
sleekness1344542sleekness
steepness1145712steepness
swartness1236112swartness
sweatiness1336462sweatiness
sweeneys14294022swee_neys
sweeteners1343162sweeteners
sweetens11255432sweet_ens
sweetest1137172sweet_est
sweeties11159722sweetie_s
sweetnesses1445722sweetnesses
swiftness1543652swiftness
tweeness11246402twee_ness
wetness10277722_w_etness
adeptness1273953adeptness
alertness946053alertness
deepness1136443_deepness
deftness1236303_deftness
erectness1146123erectness
feetless1137383_feetless
freeness11710443free_ness
greatness1036893greatness
greenness1046793greenness
ineptness1145073ineptness
inertness947973inertness
keenness1234883_keenness
meekness1434303_meekness
neatness839153_neatness
overtness1238223overtness
pertness10310093_pertness
queerness1844213queerness
quietness1844753quietness
safeness11239633safe_ness
sageness92111983sage_ness
saltness82610243s_altness
sameness102712683same_ness
saneness82313723sane_ness
scantness1135733scantness
scentless1135113scentless
seatless83213003s_eatless
seediness10219173seediness
seedless9319513s_eedless
seeress7311573s_ee_ress
seethes103613743s_eethe_s
selectness1245453selectness
selfness1135153s_elfness
sewerless1244303sewerless
sexiness1537943s_exiness
sheeneys14294903shee_neys
sheeters113111853sheet_ers
shortness1236733shortness
sidedness1146783sidedness
silentness1044573silentness
skeeters12298963skeet_ers
skewness1533763s_kewness
sleepiness1245133sleepiness
sleepless1144553sleepless
sleetiest938553sleetiest
smartness1136143smartness
soberness1186463soberness
softness1136433s_oftness
soleness8814263sole_ness
soreness8914793sore_ness
speediness1345223speediness
squatness1844943squatness
steeliness1046793steeliness
sternness946093sternness
stoutness945853stoutness
sureness8912903sure_ness
svelteness1344423svelteness
sweaters113811053sweat_ers
sweatiest1238413sweatiest
sweeney13387003swee_ne_y
sweenies11148763swee_nies
sweepers13348163swee_pers
sweepiest1435673sweepiest
sweeten10267313sweet_e_n
sweetened1343253sweetened
sweetener1243403sweetener
sweeter103212003sweet_e_r
sweetie10157863sweetie__
sweetings13326183sweetings
sweetish1445373sweet_ish
sweetmeat1442823sweetmeat
sweetmeats1551633sweetmeats
sweets94214433sweet___s
sweetsops1441993sweetsops
swelters113110193swelt_ers
tweediness1443173tweediness
tweeners11306243twee_ners
tweeters11287143tweet_ers
waeness102512783_wae_ness
weakness1535353_weakness
weediness13247043_weediness
weedless12287963_weedless
weepiness14215963_weepiness
wellness1135793_wellness
whatness1435093_whatness
witness103010013_w_itness
woeness1020211543_woe_ness

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 Filter1786911486410.1701051123.5
2DLD Change Limit1486411047.89318832.0
3Display Results1041040.0601733.3
 (SQL Overall)1786911048.12321998.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.