A woman in South Carolina who had been missing since August has been found chained up in a padlocked metal container.