Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite SQL Function Reference » Alphabetical list of functions

SIGN function [Numeric] Next Page

SIMILAR function [String]

Returns a number indicating the similarity between two strings.


SIMILAR( string-expression-1, string-expression-2 )


string-expression-1    The first string to be compared.

string-expression-2    The second string to be compared.


The function returns an integer between 0 and 100 representing the similarity between the two strings. The result can be interpreted as the percentage of characters matched between the two strings. A value of 100 indicates that the two strings are identical.

This function can be used to correct a list of names (such as customers). Some customers may have been added to the list more than once with slightly different names. Join the table to itself and produce a report of all similarities greater than 90 percent, but less than 100 percent.

The calculation performed for the SIMILAR function is more complex than just the number of characters that match.

See also
Standards and compatibility

The following statement returns the value 75, indicating that the two values are 75% similar.

SELECT SIMILAR( 'toast', 'coast' );