For what it’s worth (following the resurrection of this very old thread) for some time we have been able to search by SIC code(s) via the Companies House Public Data API using the Companies Advanced Search Endpoint.
It’s also possible to do this via Companies House web interface as well from Advanced Search there.