STRGROUP: match strings based on their Levenshtein edit distance
- February 28, 2020
- Package installation now downloads plugins for all platforms
- strgroup.ado then autodetects which plugin to use based on user's platform
- Thus, user is no longer required to do multiple installs when using a shared library with multiple platforms
which strgroup at the Stata prompt to determine which version you have installed. To install the most recent version of
strgroup, copy/paste the following line of code:
net install strgroup, from("https://raw.githubusercontent.com/reifjulian/strgroup/master") replace
To install the version that was uploaded to SSC, copy/paste the following line of code:
ssc install strgroup, replace
These two versions are typically synced, but occasionally the SSC version may be slightly out of date.
strgroup is implemented as a C plugin in order to minimize memory requirements and to maximize speed. Plugins are specific to the hardware architecture and software framework of your computer. Define a platform by two characteristics: machine type and operating system. Stata stores these characteristics in
strgroup supports the following platforms at this time:
|Machine type||Operating system|
|PC (64-bit x86-64)||Windows|
|PC (64-bit x86-64)||Unix|
|Macintosh (Intel 64-bit)||MacOSX|
strgroup might work with some other platforms (e.g., 32-bit unix), but this has not been tested.
strgroup is a Stata command that performs a fuzzy string match using the following algorithm:
Calculate the Levenshtein edit distance between all pairwise combinations of strings.
Normalize the edit distance. The default is to divide the edit distance by the length of the shorter string in the pair.
Match a string pair if their normalized edit distance is less than or equal to the user-specified threshold.
If string A is matched to string B and string B is matched to string C, then match A to C.
Assign each group of matches a unique number.
The Levenshtein edit distance is defined as the minimum number of insertions, deletions, or substitutions necessary to change one string into the other. For example, the Levenshtein edit distance between "mitten" and "fitting" is 3, since the following three edits change one into the other, and it is impossible to do it with fewer than three edits:
mitten -> fitten (substitution of 'f' for 'm')
fitten -> fittin (substitution of 'i' for 'e')
fittin -> fitting (insert 'g' at the end)
For more details, see the Stata help file included in this package.
The C source code for
strgroup is available in
/src/c. It must be compiled separately for different machine types.
PC Windows (Cygwin):
gcc -shared -mno-cygwin stplugin.c strgroup.c -O3 -funroll-loops -o strgroup.PC.Windows.plugin
PC Windows (Cygwin 64):
gcc -shared stplugin.c strgroup.c -O3 -funroll-loops -o strgroup.PC.Windows.plugin
64-bit Windows (needs Cygwin and mingw compiler):
x86_64-w64-mingw32-gcc -shared stplugin.c strgroup.c -O3 -funroll-loops -o "strgroup.PC (64-bit x86-64).Windows.plugin"
gcc -shared -fPIC -DSYSTEM=OPUNIX stplugin.c strgroup.c -O3 -funroll-loops -o "strgroup.PC (64-bit x86-64).Unix.plugin"
Mac OS X arch ppc (option 1). Note:
=arch ppc may no longer be available, in which case use option 2 below.
gcc -bundle -arch i386 -arch x86_64 -arch ppc -DSYSTEM=APPLEMAC stplugin.c strgroup.c -O3 -funroll-loops -o "strgroup.Macintosh.MacOSX.plugin"
Mac OS (option 2):
xcode-select --install gcc -bundle -arch i386 -arch x86_64 -DSYSTEM=APPLEMAC stplugin.c strgroup.c -O3 -funroll-loops -o "strgroup.Macintosh.MacOSX.plugin"
Additional information that may be helpful:
InspectExe allows you to to figure out if a compiled file is a 32-bit or 64-bit DLL: install InspectExe, right-click, properties->InspectExe
64-bit Cygwin should be able to compile to either 32-bit or 64-bit Windows. There are issues with longs, but
strgroup doesn't use them