{"active":true,"blog_title":"New string functions and operators in Fabric Data Warehouse (Preview)","blog_url":"https://community.fabric.microsoft.com/t5/Fabric-Updates-Blog/New-string-functions-and-operators-in-Fabric-Data-Warehouse/ba-p/5195232","feature_description":"Fabric Data Warehouse will introduce string similarity and comparison functions based on Levenshtein and Jaro-Winkler algorithms. These functions make it easier to find strings that are similar, even when they have small changes or spelling errors.New functions that will be added are:* EDIT_DISTANCE - Returns the number of edits (insertions, deletions, substitutions) needed to transform one string into another.* EDIT_DISTANCE_SIMILARITY - Calculates a similarity score (0-1) based on Levenshtein distance, where 1 means identical strings.* JARO_WINKLER_DISTANCE - Measures the distance between two strings using the Jaro-Winkler algorithm, considering transpositions and common prefixes.* JARO_WINKLER_SIMILARITY - Returns a similarity score (0-1) using Jaro-Winkler, optimized for short strings and minor typos.","feature_name":"Fuzzy string matching","last_modified":"2026-07-29","product_id":"fa3a73cd-dcd6-ee11-9079-000d3a310f67","product_name":"Data Warehouse","release_date":"Q2 2026","release_item_id":"9b0e4fae-ecb8-f011-bbd3-000d3a30273e","release_status":"Shipped","release_type":"Public preview"}