Excel Fuzzy Lookup Add-in - Exception out of memory


New Member
Jun 19, 2015
I have been using Fuzzy Lookup for a while to match 2 lists with no problems.

Just recently I have started to experience an error that return the following exception - Exception of type 'System.OutOfMemoryException' was thrown. (mscorlib)

I am not sure if it's caused bu the volume of the lists I am trying to match - List 1 = 58,000 rows & list 2 = 8,000 rows

I am sure that prior this starting, I had run a number of fuzzy lookups on this data with no issues so I am curious as to why it has suddenly started.

I have tried to reboot, uninstall & re-install, running on 2007 (currently using 2013) but after about running through about 3,000 rows of the 58k dataset, this exception gets returned.

I can get by by taking the data not checked and running again but it's a pain and it's billable time which I can't bill as it's not my clients fault :eek:(

Any help with resolving this would be appreciated.

Details from the exception report -

Exception of type 'System.OutOfMemoryException' was thrown. (mscorlib)

Program Location:

at System.StubHelpers.ValueClassMarshaler.ConvertToNative(IntPtr dst, IntPtr src, IntPtr pMT, CleanupWorkList& pCleanupWorkList)
at Microsoft.DataIntegration.FuzzyMatching.IWordBreaker.BreakText(TEXT_SOURCE& pTextSource, IWordSink pWordSink, IPhraseSink pPhraseSink)
at Microsoft.DataIntegration.FuzzyMatching.FtsRecordTokenizer.Tokenize(TokenizerContext tokenizerContext, IDataRecord record)
at Microsoft.DataIntegration.FuzzyMatching.LookupUpdateContext.TokenizeAndWeigh(ComparisonProviderInfo cpi, RecordContext rc, IDataRecord r, Boolean weigh)
at Microsoft.DataIntegration.FuzzyMatching.LookupUpdateContext.TokenizeAndRuleMatch(IDataRecord record)
at Microsoft.DataIntegration.FuzzyMatching.FuzzyComparer.Compare(ISession _session, IDataRecord leftRecord, IDataRecord rightRecord, ComparisonResult& result)
at Microsoft.DataIntegration.FuzzyMatching.FuzzyLookupBuilder.CustomComparer.Compare(Session session, FuzzyComparer comparer1, ISession comparerSession1, FuzzyComparer comparer2, ISession comparerSession2, IDataRecord leftRecord, IDataRecord rightRecord, Double threshold, ComparisonResult& result)
at Microsoft.DataIntegration.FuzzyMatching.FuzzyLookupBuilder.CustomComparer.Compare(ISession _session, IDataRecord leftRecord, IDataRecord rightRecord, ComparisonResult& result)
at Microsoft.DataIntegration.FuzzyMatching.FuzzyQuery.ProcessRid(Session session, IFuzzyLookupStateManager stateManager, RecordContext leftRecordContext, IDataRecord leftRecord, Int32 rid)
at Microsoft.DataIntegration.FuzzyMatching.FuzzyQuery.ProcessRidList(Session session, IFuzzyLookupStateManager stateManager, RecordContext leftRecordContext, IDataRecord leftRecord, RidList ridList)
at Microsoft.DataIntegration.FuzzyMatching.FuzzyQuery.Process_EarlyTermination(IDataRecord inputRecord, Int32 maxResults, Session session, Int32 numIndexes)
at Microsoft.DataIntegration.FuzzyMatching.FuzzyQuery.Match(ISession _session, IDataRecord inputRecord, Int32 maxResults)
at Microsoft.DataIntegration.FuzzyMatching.FuzzyQuery.Match(IDataRecord inputRecord)
at FuzzyLookupAddInForExcel.FuzzyJoinControl.FuzzyJoin(Worksheet worksheet, ProgressDialog progressDialog)


Well-known Member
Jun 17, 2014
if you are using Excel 32 bit, on a OS 64 PC, you WILL get outta memory errors. Sorry.

Forum statistics

Latest member
Tommy O

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...