Differents between STUFF and REPLACE in Sql Server

1.Select STUFF ('this is a test', 6,2, 'was')

o/p:-this was a test

2.Select REPLACE ('That is a test and it is successful!','is','was')
           
o/p:- That was a test and it was successful!