I have a huge blog with over 10K posts and a lot of posts with some adult keywords in titles, urls, content and tags. I am trying to remove all adult ones with "search and replace" plugin. It works fine, but the problem is the url slugs also changes if there is a bad keyword in the url and the original url becomes 404.
For example, http://www.domain.com/adult-keyword-url changes to http://www.renamed-keyword-url which is fine, but the adult keyword url is now 404 and does not redirect to renamed url. Is there a way that the original url automatically do 301 redirects to the changed url?
I tried using the redirection plugin too which claims to auto-redirect such posts. It works fine only when you manually change the url slug of a post and update a post. But it does not work in this case when you are updating a lot of posts by directly changing the database with search and replace plugin.