Andrew Pruski does a bit of math:
Here we are using cosine as a distance metric, but there are three available to us in SQL Server: –
- Euclidean Distance
- Negative Dot Product
- Cosine Distance
In this post we’ll run through all three, see how they are calculated, and explore how they differ from each other.
Click through for a description of each.