Forum Discussion

MustafaSH's avatar
MustafaSH
Regular Visitor
1 month ago
Solved

'EDIT_DISTANCE' is not a recognized built-in function name.

I'm using SQL Sever 2025 Dev Edition and study DP-800 from Microsoft learn

When try this code 

SELECT EDIT_DISTANCE('Apple', 'Apel');

I get this error 

Msg 195, Level 15, State 10, Line 18
'EDIT_DISTANCE' is not a recognized built-in function name
SQL database
  • v-achippa's avatar
    v-achippa
    1 month ago

    Hi MustafaSH,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Here the EDIT_DISTANCE is a preview feature in sql server 2025. If preview features are not enabled for the database, sql server returns the error.

    • Please enable preview features and then try the query again. Run the following command in your user database (not master):
      ALTER DATABASE SCOPED CONFIGURATION SET PREVIEW_FEATURES = ON;

    Then start a new query session and try again.

     

    Thanks and regards,

    Anjan Kumar Chippa

1 Reply

  • v-achippa's avatar
    v-achippa
    Community Support
    1 month ago

    Hi MustafaSH,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Here the EDIT_DISTANCE is a preview feature in sql server 2025. If preview features are not enabled for the database, sql server returns the error.

    • Please enable preview features and then try the query again. Run the following command in your user database (not master):
      ALTER DATABASE SCOPED CONFIGURATION SET PREVIEW_FEATURES = ON;

    Then start a new query session and try again.

     

    Thanks and regards,

    Anjan Kumar Chippa