Database Paper Browser

Back to papers

Ed-Join: An Efficient Algorithm for Similarity Joins With Edit Distance Constraints

Summary: EdJoin leverages mismatch-based q-grams to derive two novel edit-distance lower bounds, enabling tighter filtering for similarity joins under edit-distance constraints. It dramatically reduces candidate sets and runtime, outperforming prior q-gram–based approaches on large real datasets. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
9727
Venue
VLDB
Year
2008
Pagerank
0.00013133604
Overall Rank
1,232 | 91.44%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 37 of 37 citing papers.

Rank Citing Paper Year Venue Pagerank
442 Efficient Parallel Set-Similarity Joins Using MapReduce 2010 SIGMOD 0.00023095823
1,396 Can We Beat the Prefix Filtering? An Adaptive Framework for Similarity Join and Search 2012 SIGMOD 0.00012215253
2,077 Extending Autocompletion To Tolerate Errors 2009 SIGMOD 9.6038296e-05
2,176 Falcon: Scaling Up Hands-Off Crowdsourced Entity Matching to Build Cloud Services 2017 SIGMOD 9.3729351e-05
2,387 Bed-Tree: An All-Purpose Index Structure for String Similarity Search Based on Edit Distance 2010 SIGMOD 8.9075095e-05
2,588 Pass-Join: A Partition-based Method for Similarity Joins 2012 VLDB 8.4872437e-05
2,729 String Similarity Joins: An Experimental Evaluation 2014 VLDB 8.2175463e-05
3,583 Efficient Approximate Entity Extraction with Edit Distance Constraints 2009 SIGMOD 6.944299e-05
3,779 Efficient Exact Edit Similarity Query Processing with the Asymmetric Signature Scheme 2011 SIGMOD 6.7709545e-05
4,215 Trie-Join: Efficient Trie-based String Similarity Joins with Edit-Distance Constraints 2010 VLDB 6.3464157e-05
4,682 Approximate String Joins with Abbreviations 2018 VLDB 5.9949001e-05
4,907 Probabilistic String Similarity Joins 2010 SIGMOD 5.8365853e-05
5,071 Faerie: Efficient Filtering Algorithms for Approximate Dictionary-based Entity Extraction 2011 SIGMOD 5.7122974e-05
5,297 Fast Subtrajectory Similarity Search in Road Networks under Weighted Edit Distance Constraints 2020 VLDB 5.5772847e-05
5,892 Efficient Approximate Search on String Collections (Tutorial) 2009 VLDB 5.2829767e-05
6,080 Pigeonring: A Principle for Faster Thresholded Similarity Search 2019 VLDB 5.219249e-05
6,730 A Pivotal Prefix Based Filtering Algorithm for String Similarity Search 2014 SIGMOD 4.9436522e-05
6,835 Boosting Graph Similarity Search through Pre-Computation 2021 SIGMOD 4.9065543e-05
7,055 Serving Deep Learning Models with Deduplication from Relational Databases 2022 VLDB 4.8428976e-05
7,106 Efficient Similarity Join and Search on Multi-Attribute Data 2015 SIGMOD 4.8250163e-05
7,215 SyncSignature: A Simple, Efficient, Parallelizable Framework for Tree Similarity Joins 2023 VLDB 4.7939964e-05
7,590 Scalable Column Concept Determination for Web Tables Using Large Knowledge Bases 2013 VLDB 4.6987033e-05
7,667 Human-in-the-loop Data Integration 2017 VLDB 4.6791871e-05
7,698 Near-Duplicate Text Alignment with One Permutation Hashing 2024 SIGMOD 4.6699546e-05
7,765 Cache-oblivious High-performance Similarity Join 2019 SIGMOD 4.6527424e-05
8,936 Comparative evaluation of entity resolution approaches with FEVER 2009 VLDB 4.4229886e-05
9,566 META: An Efficient Matching-Based Method for Error-Tolerant Autocompletion 2016 VLDB 4.3212967e-05
9,831 Balance-Aware Distributed String Similarity-Based Query Processing System 2019 VLDB 4.2710095e-05
9,933 Local Filtering: Improving the Performance of Approximate Queries on String Collections 2015 SIGMOD 4.245954e-05
10,068 DiskJoin: Large-scale Vector Similarity Join with SSD 2026 SIGMOD 4.1905499e-05
10,508 Privacy and Accuracy-Aware AI/ML Model Deduplication 2025 SIGMOD 4.1905499e-05
10,714 Extensible and Robust Evaluation of Similarity Queries 2025 VLDB 4.1905499e-05
10,933 Similarity Joins of Sparse Features 2024 SIGMOD 4.1905499e-05
11,090 Dealing with Acronyms, Abbreviations, and Typos in Real-World Entity Matching 2024 VLDB 4.1905499e-05
11,307 TokenJoin: Efficient Filtering for Set Similarity Join with Maximum Weighted Bipartite Matching 2023 VLDB 4.1905499e-05
11,730 ZigZag: Supporting Similarity Queries on Vector Space Models 2018 SIGMOD 4.1905499e-05
11,987 Similarity Joins for Uncertain Strings 2014 SIGMOD 4.1905499e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 12 of 12 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
34 Similarity Search in High Dimensions via Hashing 1999 VLDB 0.00076824554
125 Approximate String Joins in a Database (Almost) for Free 2001 VLDB 0.00044946098
248 Efficient set joins on similarity predicates 2004 SIGMOD 0.00030888982
264 Efficient Exact Set-Similarity Joins 2006 VLDB 0.00029950264
1,043 Set Containment Joins: The Good, The Bad and The Ugly 2000 VLDB 0.00014468616
1,203 VGRAM: Improving Performance of Approximate Queries on String Collections Using Variable-Length Grams 2007 VLDB 0.00013317317
1,530 Example-driven Design of Efficient Record Matching Queries 2007 VLDB 0.00011483613
1,559 Evaluation of Main Memory Join Algorithms for Joins with Subset Join Predicates 1997 VLDB 0.00011368746
1,757 Efficient Processing of Joins on Set-valued Attributes 2003 SIGMOD 0.00010659352
2,285 Epsilon Grid Order: An Algorithm for the Similarity Join on Massive High-Dimensional Data 2001 SIGMOD 9.1097273e-05
3,229 Extending Q-Grams to Estimate Selectivity of String Matching with Low Edit Distance 2007 VLDB 7.3390133e-05
3,258 Benchmarking Declarative Approximate Selection Predicates 2007 SIGMOD 7.3129307e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
6,240 Scaling Similarity Joins over Tree-Structured Data 2015 VLDB 5.1362097e-05
3,229 Extending Q-Grams to Estimate Selectivity of String Matching with Low Edit Distance 2007 VLDB 7.3390133e-05
3,779 Efficient Exact Edit Similarity Query Processing with the Asymmetric Signature Scheme 2011 SIGMOD 6.7709545e-05
248 Efficient set joins on similarity predicates 2004 SIGMOD 0.00030888982
125 Approximate String Joins in a Database (Almost) for Free 2001 VLDB 0.00044946098
4,907 Probabilistic String Similarity Joins 2010 SIGMOD 5.8365853e-05
2,729 String Similarity Joins: An Experimental Evaluation 2014 VLDB 8.2175463e-05
7,707 Efficient Top-k Algorithms for Approximate Substring Matching 2013 SIGMOD 4.6676985e-05
4,215 Trie-Join: Efficient Trie-based String Similarity Joins with Edit-Distance Constraints 2010 VLDB 6.3464157e-05
2,588 Pass-Join: A Partition-based Method for Similarity Joins 2012 VLDB 8.4872437e-05