public static SqlString longestSubSequence(SqlString string1, SqlString string2) { var compString = new CompStrings(string1, string2); var sdist = new StringDist(compString.from, compString.to); return(new SqlString(sdist.longestSubSequence())); }
public static SqlDouble sorensenDistance(SqlString string1, SqlString string2) { var compString = new CompStrings(string1, string2); var sdist = new StringDist(compString.from, compString.to); return(new SqlDouble(sdist.sorensenDistance())); }
public static SqlDouble overlap(SqlString string1, SqlString string2) { var compString = new CompStrings(string1, string2); var sdist = new StringDist(compString.from, compString.to); return(new SqlDouble(sdist.overlap())); }
public static SqlDouble tanimotoCoefficient(SqlString string1, SqlString string2) { var compString = new CompStrings(string1, string2); var sdist = new StringDist(compString.from, compString.to); return(new SqlDouble(sdist.tanimotoCoefficient())); }
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 SqlDouble jaroWinklerPrefix(SqlString string1, SqlString string2, SqlDouble scale) { var compString = new CompStrings(string1, string2); var sdist = new StringDist(compString.from, compString.to); return(new SqlDouble(sdist.jaroWinklerPrefix((double)scale))); }
public static SqlDouble jaroWinkler(SqlString string1, SqlString string2) { var compString = new CompStrings(string1, string2); var sdist = new StringDist(compString.from, compString.to); return(new SqlDouble(sdist.jaroWinkler())); }
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 SqlBoolean approximatelySame(SqlString string1, SqlString string2, SqlString comparisonOptions, SqlString toleranceOptions) { var compString = new CompStrings(string1, string2, toleranceOptions, comparisonOptions); var sdist = new StringDist(compString.from, compString.to); return(new SqlBoolean(sdist.approxSame(compString.comp, compString.tolerance))); }
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 jaroWinkler(SqlString string1, SqlString string2) { var compString = new CompStrings(string1, string2); var sdist = new StringDist(compString.from, compString.to); return new SqlDouble(sdist.jaroWinkler()); }
public static SqlString longestSubSequence(SqlString string1, SqlString string2) { var compString = new CompStrings(string1, string2); var sdist = new StringDist(compString.from, compString.to); return new SqlString(sdist.longestSubSequence()); }
public static SqlBoolean approximatelySame(SqlString string1, SqlString string2, SqlString comparisonOptions, SqlString toleranceOptions) { var compString = new CompStrings(string1, string2, toleranceOptions, comparisonOptions); var sdist = new StringDist(compString.from, compString.to); return new SqlBoolean(sdist.approxSame(compString.comp, compString.tolerance)); }
public static SqlDouble overlap(SqlString string1, SqlString string2) { var compString = new CompStrings(string1, string2); var sdist = new StringDist(compString.from, compString.to); return new SqlDouble(sdist.overlap()); }
public static SqlDouble sorensenDistance(SqlString string1, SqlString string2) { var compString = new CompStrings(string1, string2); var sdist = new StringDist(compString.from, compString.to); return new SqlDouble(sdist.sorensenDistance()); }
public static SqlDouble tanimotoCoefficient(SqlString string1, SqlString string2) { var compString = new CompStrings(string1, string2); var sdist = new StringDist(compString.from, compString.to); return new SqlDouble(sdist.tanimotoCoefficient()); }
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 SqlDouble jaroWinklerPrefix(SqlString string1, SqlString string2, SqlDouble scale) { var compString = new CompStrings(string1, string2); var sdist = new StringDist(compString.from, compString.to); return new SqlDouble(sdist.jaroWinklerPrefix((double)scale)); }