By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE skills (description varchar(MAX));
INSERT INTO skills VALUES
('foo sports bar'),
('foo other bar');
2 rows affected
SELECT *
FROM skills
WHERE EXISTS (
SELECT 1
FROM OPENJSON('["Sports", "Life", "Relationship"]', '$') AS j
WHERE skills.description LIKE '%' + j.value + '%'
)
| description |
|---|
| foo sports bar |