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

129 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
sweetest113717(None) 
fleetest1136722fleetest
sheerest11310082sheerest
sleekest1236152sleekest
sleetiest938552sleetiest
steepest1038122steepest
sveltest1135872sveltest
sweatiest1238412sweatiest
sweepiest1435672sweepiest
sweeten10267312sweete_n
sweetens11255432sweetens
sweeter103212002sweete_r
sweeties11159722sweeties_
sweetish1445372sweetish
sweetmeat1442822sweetmeat
sweetness1245682sweetness
sweets94214432sweet_s_
swellest1137662swellest
swiftest1434352swiftest
wettest10239362_wettest
adeptest1145453adeptest
alertest8310173alertest
deepest10310443_deepest
deftest112611713_deftest
detest74122843__detest
dweebiest1542663dweebiest
featest102715113_featest
gleetiest1035913gleetiest
greatest939863greatest
greenest9312623greenest
keenest11410963_keenest
leftest10269463_leftest
meekest1336893_meekest
neatest72516003_neatest
pertest9317043_pertest
pretest9517633_pretest
queerest1746273queerest
quietest1757173quietest
retest64028453__retest
saltest71916513s_altest
scantest101710183scantest
searest73322023s_earest
secretest1147033secretest
sedatest9249393sedatest
seediest92714053seediest
seepiest102412623seepiest
seeress7311573s_eeress
seethes103613743s_eethes_
septet8921133s_epte_t
septets998953s_eptets
serenest82717623serenest
serest64831613s__erest
sestet6826203s_este_t
sestets7911473s_estets
severest11310323severest
sexiest142112223s_exiest
sextet13916873s_exte_t
sextets1497143s_extets
sheeniest12158353sheeniest
sheeted113813043sheete_d
sheeter103814913sheete_r
sheeters113111863sheeters
sheetless1235823sheetless
sheets93918503sheet_s_
sheeves133911953sheeves_
shortest11310783shortest
silentest948103silentest
skeeter113410413skeete_r
skeeters12298963skeeters
skeets104513253skeet_s_
sleekiest1336063sleekiest
sleepiest1136713sleepiest
sleeted83113223sleete_d
sleets64318873sleet_s_
sleeves103311343sleeves_
smartest10310183smartest
sneeriest939313sneeriest
sneezes16278503sneezes_
sneeziest1845153sneeziest
snellest839493snellest
soberest10310353soberest
softest10310603s_oftest
speediest1257463speediest
steeliest939643steeliest
steeves103410903steeves_
sternest8314433sternest
stoutest837613stoutest
subtest9513963s_ubtest
swankest15105933swankest
sweated113411543sweate_d
sweater103712723sweate_r
sweaters113811063sweaters
sweats94814613sweat_s_
swedes102711893sw_edes_
sweeney13387003sweene_y
sweeneys14294023sweeneys
sweenies11148763sweenies_
sweeper12329373sweepe_r
sweepers13348163sweepers
sweeps114110513swee_ps_
sweet85330523sw_e_e_t
sweetened1343253sweetened
sweetener1243403sweetener
sweetheart1662913sweetheart
sweetie10157873sweet_ie
sweeting123911313sweeting
sweetly1335593sweet_ly
sweetmeats1551633sweetmeats
sweetsop1341893sweetsop
swelter103711173swelte_r
swelters113110193swelters
sweltriest1343283sweltriest
swerves1377533swerves_
tweediest1344273tweediest
tweeness11246403tweeness
tweeted11336583tweete_d
tweeter10288533tweete_r
tweeters11287143tweeters
tweets94210103tweet_s_
tweezes19345703tweezes_
wattest102412153_wattest
weakest1439003_weakest
weediest122311133_weediest
weeniest112411213_weeniest
weepiest13219473_weepiest
weest85026773_w_e_est
weeted103913793_weete_d
weets85427723_weet_s_
whitest133710113_whitest

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621297.20320291.8
3Display Results1291290.0502580.0
 (SQL Overall)1786911297.40924118.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.