public static SqlDouble levenshteinNormalized(SqlString string1, SqlString string2)
{
var compString = new CompStrings(string1, string2);
var sdist = new StringDist(compString.from, compString.to);
return(new SqlDouble(sdist.levenshteinNormalized()));
}
public static IEnumerable GetStringDistances(String query) {
ArrayList returnValues = new ArrayList();
using (SqlConnection connection = new SqlConnection("context connection=true")) {
connection.Open();
using (SqlCommand dataTable = new SqlCommand(query, connection)) {
using (SqlDataReader row = dataTable.ExecuteReader()) {
while (row.Read()) {
CompStrings comparisonStrings = new CompStrings(row.GetSqlString(0), row.GetSqlString(1));
StringDist dists = new StringDist(comparisonStrings.from, comparisonStrings.to);
returnValues.Add(new AllDistanceMetrics(comparisonStrings.from, comparisonStrings.to,
dists.hamming(), dists.jaccard(), dists.jaro(), dists.jaroWinkler(),
dists.levenshtein(), dists.levenshteinLower(), dists.levenshteinUpper(),
dists.levenshteinNormalized(), dists.overlap(), dists.ratcliff(), dists.sorensenIndex(),
dists.sorensenDistance(), dists.tanimotoCoefficient()));
}
}
}
}
return returnValues;
}
public static IEnumerable GetStringDistances(String query)
{
ArrayList returnValues = new ArrayList();
using (SqlConnection connection = new SqlConnection("context connection=true")) {
connection.Open();
using (SqlCommand dataTable = new SqlCommand(query, connection)) {
using (SqlDataReader row = dataTable.ExecuteReader()) {
while (row.Read())
{
CompStrings comparisonStrings = new CompStrings(row.GetSqlString(0), row.GetSqlString(1));
StringDist dists = new StringDist(comparisonStrings.from, comparisonStrings.to);
returnValues.Add(new AllDistanceMetrics(comparisonStrings.from, comparisonStrings.to,
dists.hamming(), dists.jaccard(), dists.jaro(), dists.jaroWinkler(),
dists.levenshtein(), dists.levenshteinLower(), dists.levenshteinUpper(),
dists.levenshteinNormalized(), dists.overlap(), dists.ratcliff(), dists.sorensenIndex(),
dists.sorensenDistance(), dists.tanimotoCoefficient()));
}
}
}
}
return(returnValues);
}
public static SqlDouble levenshteinNormalized(SqlString string1, SqlString string2)
{
var compString = new CompStrings(string1, string2);
var sdist = new StringDist(compString.from, compString.to);
return new SqlDouble(sdist.levenshteinNormalized());
}