There are some new fantastic features available in SQL Server.
You’ll need to enable the compatibility level at 170, as below.
ALTER DATABASE [DatabaseName] SET COMPATIBILITY_LEVEL = 170;
Namely REGEX which is in preview at the time of writing as is Fuzzy String-Matching.
Regular Expressions Functions (Transact-SQL) – SQL Server | Microsoft Learn
Fuzzy String Match – SQL Server | Microsoft Learn
These bring exciting new ‘shortcuts’ to the database consumer. Bringing Jaro–Winkler similarity to databases in a simple T-SQL query can be transformational to some organisations.
REGEX and FUZZY match in SQL Server