Count of words in column

Input Data:

Output Data:

DECLARE @WordCount TABLE

(

       [Word List] varchar(100)

)

INSERT INTO @WordCount

VALUES

('Adam Michelle Larry'),('Pisa London Moscow Delhi'),

('Maths Physics'),('England'),('a b c d e f g h') 

 

SELECT * FROM @WordCount

SELECT [Word List],LEN([Word List]) - LEN(REPLACE([Word List], ' ', '')) + 1 AS [Count] FROM @WordCount