Week 92 – Easy

Have you heard about Artic? What incredible news! But for this challenge we will leave AI and LLMs aside and focus on a very cute function for finding matches or making a comparison between two input strings: JAROWINKLER_SIMILARITY.

Your task is to write a SQL query in Snowflake that sorts a table of strings based on their Jaro-Winkler similarity to a given reference string.

-- Create a table named fruit_salad
CREATE OR REPLACE TABLE fruit_salad (
    fruits VARCHAR(255)
);

-- Insert sample frutis into the fruit_salad
INSERT INTO fruit_salad (fruits) VALUES
('apple'),
('apricot'),
('banana'),
('pineapple'),
('oranges'),
('kiwi'),
('strawberry'),
('grape'),
('watermelon'),
('pear'),
('peach'),
('strawberry'),
('blueberry'),
('mango'),
('lemon'),
('lime'),
('papaya'),
('cherry'),
('plum'),
('fig'),
('passion fruit'),
('raspberry'),
('blackberry'),
('nectarine'),
('cantaloupe'),
('apricot'),
('tangerine'),
('guava'),
('dragon fruit');

The query you need to create should return strings sorted in descending order based on their similarity to the reference string.

Remember if you want to participate:

1. Sign up as a member of Frosty Friday. You can do this by clicking on the sidebar, and then going to ‘REGISTER‘ (note joining our mailing list does not give you a Frosty Friday account)
2. Post your code to GitHub and make it publicly available (Check out our guide if you don’t know how to here)
3. Post the URL in the comments of the challenge.