DIFFERENCE in JS

Applies to

• SQL Server

• Azure Synapse Analytics

Description

Unfortunately, this functionality is not available in JS, but this can be implemented easily.

This functions requires the SOUNDEX algorithm implementation.

Sample Source Pattern

Implementation Example

function DIFFERENCE(strA, strB) {
    var count = 0;
    for (var i = 0; i < strA.length; i++){
       if ( strA[i] == strB[i] ) count++; 
    }
    
    return count;
}

Arguments

strA, strB: String expressions resulting by executing the SOUNDEX algorithm.

Return Type

String.

Examples

Query

CREATE OR REPLACE FUNCTION SOUNDEX_DIFFERENCE(str_1 varchar, str_2 varchar)
  RETURNS string
  LANGUAGE JAVASCRIPT
AS
$$
    function DIFFERENCE(strA, strB) {
      var count = 0;
      for (var i = 0; i < strA.length; i++){
         if ( strA[i] == strB[i] ) count++; 
      }
    
    return count;
    }
    
    return DIFFERENCE(STR_1, STR_2);
$$;

SELECT SOUNDEX_DIFFERENCE(GET_SOUNDEX('two'), GET_SOUNDEX('too')) DIFFERENCE;

Result

   DIFFERENCE|
-------------+
            4| 

Known Issues

No issues were found.

Related EWIs

No related EWIs.