I want to know that is it possible to add Search box in the website created with Sitecake to search content.
As far as I know there is no searchbox widget (yet), but since you can use PHP files to build your site you can easily build your own search script by checking your files for certain keywords. This does take some coding.