MS SQL server text search and create new column

create columns with N characters after string pattern

needed MS SQL server REGEX specialist

https://www.sqlservercentral.com/scripts/extracting-string-after-and-before-a-characterpattern

like https://www.youtube.com/watch?v=c5VIPyqsxVY

but pattern not exactly known

for example "good big food" or " good big food" - spaces

" good big food"

" good big food "

or " good bg fod"

letter missed

or

" good biag fohod"

letter inserted

at least when many random spaces added

for "car plane asdfaf fa asdf good big food : abc table asdfasdf ff asdfasdf"

should be returned ": abc table asdfa"
12:56 PM
for query ("good big food", 16) where 16 is number of characters to return after "good big food"

if row does not have pattern "good big food" then write to output NAN

or https://www.youtube.com/watch?v=n6Ur7HPLc2M

https://www.sqlservercentral.com/scripts/extracting-string-after-and-before-a-characterpattern