Search Results
Nov 18, 2025 · SOUNDEX converts an alphanumeric string to a four-character code that is based on how the string sounds when spoken in English. The first character of the code is the first character of character_expression, converted to upper case. The second through fourth characters of the code are numbers that represent the letters in the expression. The letters A, E, I, O, U, H, W, and Y are ignored ...
Apr 27, 2025 · Learn how to use the SQL Server SOUNDEX function to compare how similar two words may be to each other.
Jul 23, 2025 · The SOUNDEX() function in SQL Server is a powerful tool for handling phonetic matching, which allows you to compare words based on their sound rather than their exact spelling.
Utilisez la fonction SOUNDEX ( ) pour rechercher des valeurs qui peuvent sembler similaires. La ressemblance phonétique constitue une façon de repérer les valeurs en double ou de trouver des fautes d'orthographe dans les données manuellement saisies.
La fonction SOUNDEX () va permettre de récupérer la liste des utilisateurs en fonction d’un nom, du moment que le nom se prononce de la même façon. La requête ci-dessous est un exemple m’étant en scène un utilisateur qui recherche l’utilisateur “john” avec une mauvaise orthographe, en utilisant à la place le mot “jone”.
The SOUNDEX () function returns a four-character code to evaluate the similarity of two expressions. Note: The SOUNDEX () converts the string to a four-character code based on how the string sounds when spoken.
People also ask
What is a soundex function?
What is Soundex function in SQL Server?
What is soundex in JSFiddle?
What is the value returned in Soundex?
Aug 22, 2018 · Here's an interactive demo in jsFiddle: And here's a demo in SQL using SQL Fiddle In SQL Server, SOUNDEX is often used in conjunction with DIFFERENCE, which is used to score how many of the resulting digits are identical (just like the game mastermind †), with higher numbers matching most closely. What are the Alternatives?
