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

155 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
sedatest924939(None) 
sedates83418031sedates_
featest102715112fe_atest
neatest72516002ne_atest
redates83423872redates_
searest73322022se_arest
sedate73019802sedate__
sedated93714342sedate_d
sedately1245222sedately
sedater83713622sedate_r
sedgiest10259762sedgiest
senates73322582senates_
adeptest1145453adeptest
aerates74627493aerates_
beadiest113815533beadiest
bedmates1349183bedmates_
berates94126873berates_
cerates95428253cerates_
daftest11248943__daftest
dates65639153__dates_
deadest93014883de_adest
deafest112911513de_afest
dearest83618673de_arest
debates103718533debates_
deftest112611713de_ftest
delates83526283delates_
derates84028893derates_
detest74122843__detest
edgiest92310353_edgiest
elates65032363_elates_
enates64026423_enates_
estates74520183estates_
etatist7415033_etatist
exactest1745453_exactest
gelates83219583gelates_
greatest939863greatest
headiest123015553headiest
headrest122910203headrest
hedgiest13298133hedgiest
ideates8313733ideates_
iodates8312903iodates_
iratest7312483_iratest
latest63822703__latest
leadiest93314983leadiest
leanest7415863le_anest
ledgiest10288593ledgiest
leftest10269463le_ftest
legates82917683legates_
meanest9315703me_anest
meatiest102816793me_atiest
medalist11414213medalist
mediates112814063mediates_
metates92720013metates_
nearest73415843ne_arest
negates83215843negates_
nidates8311893nidates_
peartest10311303peartest
peatiest103118803pe_atiest
pedate93117763pedate__
pedately1445433pedately
penates93321593penates_
pertest9317043pe_rtest
predates11615813predates_
readiest93719043readiest
realest73322433re_alest
rebates95123183rebates_
redate74124683redate__
redated93120923redate_d
reddest9311953red_dest
redigest1039733redigest
relates73731433relates_
remates93827113remates_
remotest103310723remotest
retest64028453re__test
saddest92412383sad_dest
safest95016603s__afest
sagest74920263s__agest
saltest71916513s_altest
sanest64426693s__anest
sates54949323s__ates_
savagest1245763savagest
savates10312953savates_
sayest94217743s__ayest
scantest101710183scantest
seamiest102715413seamiest
seatbelt1045943se_atbelt
seated75131053se_ate_d
seater64534153se_ate_r
seaters74028943se_aters
seatless83213003se_atless
seats54844343se_at_s_
secateur1042923secateur
secretest1147033secretest
securest1058583securest
sedans74816093seda_ns_
sedateness1146663sedateness
sedating103014113sedating
sedation9312453sedation
sedative1238853sedative
sedatives1346153sedatives_
sedges83817813sed_ges_
sediment11411103sediment
seduces1069283seduces_
seediest92714053seediest
seepiest102412623seepiest
semitist10413323semitist
senate63725143senate__
sensates8511133sensates_
septet8921133se_pte_t
septets998953se_ptets
serapes95218103serapes_
serenest82717623serenest
serest64831613se__rest
seriates82620673seriates_
serrates82617023serrates_
sesames9310743sesames_
sestet6826203se_ste_t
sestets7911473se_stets
severest11310323severest
sewages1139753sewages_
sexiest142112223se_xiest
sextet13916873se_xte_t
sextets1497143se_xtets
shadiest121711273shadiest
shoalest1168913shoalest
shortest11310783shortest
skates104219403s_kates_
slates64934063s_lates_
slatiest82616263s_latiest
smartest10310183smartest
sodaless936113sodaless
sodalist9311883sodalist
softest10310603s_oftest
solates73523853solates_
sparest94616423s_parest
spates85028173s_pates_
squarest17338223squarest
squattest1844613squattest
stalest73720173s_talest
states64337083s_tates_
statist7317723s_tatist
steadiest1038513steadiest
stoutest837613stoutest
straitest949173straitest
suavest10310623s_uavest
subtest9513963s_ubtest
sudsiest939623sudsiest
sveltest1135873sveltest
sweatiest1238413sweatiest
sweetest1137173sweetest
swiftest1434353swiftest
updates10329793updates_
weakest1439003we_akest
wedgiest13307983wedgiest
wettest10239363we_ttest

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.406440125.6
2DLD Change Limit1461621557.75018859.6
3Display Results1551550.0632460.3
 (SQL Overall)1786911558.21921741.2
 
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.