• An interesting approach, with quite a lot of time invested in it!

    I come at this from a different angle. All of my source code is contained in several local Git repositories & I am able to search that code (usually just .sql and .dtsx files) using third-party search software (I use FileSeek). This software allows for the search of regular expressions, so ignoring words which appear after in-line comments is easy enough. Handling block comments would be more tricky.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.