DBScholar

Back to papers

Trie-Join: Efficient Trie-based String Similarity Joins with Edit-Distance Constraints

Summary: Trie-Join uses a trie to index strings and prune subtries for edit-distance constrained similarity joins. Small indexes, efficient dynamic updates, and order-of-magnitude speedups on short strings across real data sets. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
he54fb7a5982462d6
Venue
VLDB
Year
2010
Pagerank
6.9814064e-05
Overall Rank
3,822 | 74.39%
DOI
10.14778/1920841.1920992

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{wang_vldb10,
        title = {{Trie-Join: Efficient Trie-based String Similarity Joins with Edit-Distance Constraints}},
        author = {Wang, Jiannan and Feng, Jianhua and Li, Guoliang},
        journal = {PVLDB},
        series = {{VLDB} '10},
        volume = {3},
        number = {1},
        pages = {1219--1230},
        doi = {10.14778/1920841.1920992},
        url = {https://doi.org/10.14778/1920841.1920992},
        year = {2010}
}

Incoming Citations (Sorted by Pagerank)

Showing 18 of 18 citing papers.

Rank Citing Paper Year Venue Pagerank
966 Can We Beat the Prefix Filtering? An Adaptive Framework for Similarity Join and Search 2012 SIGMOD 0.00012777679
1,650 Falcon: Scaling Up Hands-Off Crowdsourced Entity Matching to Build Cloud Services 2017 SIGMOD 9.9690948e-05
1,941 Pass-Join: A Partition-based Method for Similarity Joins 2012 VLDB 9.3141839e-05
2,235 String Similarity Joins: An Experimental Evaluation 2014 VLDB 8.7832223e-05
3,166 Unicorn: A Unified Multi-tasking Model for Supporting Matching Tasks in Data Integration 2023 SIGMOD 7.5597853e-05
3,270 Efficient Exact Edit Similarity Query Processing with the Asymmetric Signature Scheme 2011 SIGMOD 7.4613275e-05
4,515 Approximate String Joins with Abbreviations 2018 VLDB 6.5529885e-05
5,135 SEAL: Spatio-Textual Similarity Search 2012 VLDB 6.245475e-05
5,233 String Similarity Measures and Joins with Synonyms 2013 SIGMOD 6.2049921e-05
6,145 Compression of Uncertain Trajectories in Road Networks 2020 VLDB 5.8561863e-05
6,617 A Pivotal Prefix Based Filtering Algorithm for String Similarity Search 2014 SIGMOD 5.7150599e-05
7,035 Efficient Similarity Join and Search on Multi-Attribute Data 2015 SIGMOD 5.5997831e-05
7,440 Cardinality Estimation of Approximate Substring Queries using Deep Learning 2022 VLDB 5.5118924e-05
7,640 SyncSignature: A Simple, Efficient, Parallelizable Framework for Tree Similarity Joins 2023 VLDB 5.4624931e-05
7,728 Scalable Column Concept Determination for Web Tables Using Large Knowledge Bases 2013 VLDB 5.4515436e-05
9,919 META: An Efficient Matching-Based Method for Error-Tolerant Autocompletion 2016 VLDB 5.0983269e-05
10,332 Efficient and Effective KNN Sequence Search with Approximate n-grams 2014 VLDB 5.0228171e-05
11,668 Dealing with Acronyms, Abbreviations, and Typos in Real-World Entity Matching 2024 VLDB 4.9605343e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 9 of 9 cited papers.

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

Rank Cited Paper Year Venue Pagerank
108 Approximate String Joins in a Database (Almost) for Free 2001 VLDB 0.00032945275
162 Robust and Efficient Fuzzy Match for Online Data Cleaning 2003 SIGMOD 0.00027626077
169 Efficient Exact Set-Similarity Joins 2006 VLDB 0.00027077763
202 Efficient set joins on similarity predicates 2004 SIGMOD 0.00025244506
934 Ed-Join: An Efficient Algorithm for Similarity Joins With Edit Distance Constraints 2008 VLDB 0.00012973416
1,068 VGRAM: Improving Performance of Approximate Queries on String Collections Using Variable-Length Grams 2007 VLDB 0.00012170201
1,751 Extending Autocompletion To Tolerate Errors 2009 SIGMOD 9.7128647e-05
2,327 n-Gram/2L: A Space and Time Efficient Two-Level n-Gram Inverted Index Structure 2005 VLDB 8.6228658e-05
4,462 Incremental Maintenance of Length Normalized Indexes for Approximate String Matching 2009 SIGMOD 6.5751733e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 4,878 Probabilistic String Similarity Joins 2010 SIGMOD
2 5,233 String Similarity Measures and Joins with Synonyms 2013 SIGMOD
3 4,515 Approximate String Joins with Abbreviations 2018 VLDB
4 966 Can We Beat the Prefix Filtering? An Adaptive Framework for Similarity Join and Search 2012 SIGMOD
5 9,918 Towards a Unified Framework for String Similarity Joins 2019 VLDB
6 6,160 Scaling Similarity Joins over Tree-Structured Data 2015 VLDB
7 12,517 Similarity Joins for Uncertain Strings 2014 SIGMOD
8 934 Ed-Join: An Efficient Algorithm for Similarity Joins With Edit Distance Constraints 2008 VLDB
9 1,941 Pass-Join: A Partition-based Method for Similarity Joins 2012 VLDB
10 2,235 String Similarity Joins: An Experimental Evaluation 2014 VLDB