Re: Fuzzy Matching-Algorithmus in VBA

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hallo Hans,

So etwa, Helmut?

vermute ja, obwohl ich das nicht alles
so schnell nachvollziehen kann.

Die Freunde aus word.vba.general haben
ja schon geholfen.

Mein Ansatz ist so:

"München" besteht aus:

Array1 = M ü n c h e n
Array2 = Mü ün nc ch he en
Array3 = Mün ünc nch che hen
Array4 = Münc ünch nche chen
Array5 = Münch ünche nchen
Array6 = Münche ünchen

Selbes für "Manching"

Und dann ausrechnen, wie oft jedes Element
in einem der Arrays in den anderen Arrays vorkommt.
Allerdings gibt's da viel zu rechnen.

Hat den Vorteil, dass die Reihenfolge nicht überbewerted wird.
abcdefghijklmnopqrstuvwxyz
und
zyxwvutsrqponmlkjihgfedcba
stimmen in Array1 zu 100 Prozent überein.
Dann käme die Frge nach der Gewichtung der Ergebnisse pro Array.

Den Code dafür müsste ich erst noch ausgraben. Kann dauern.


--
Gruß

Helmut Weber, MVP WordVBA

"red.sys" & chr$(64) & "t-online.de"
Win XP, Office 2003 (US-Versions)










.

Relevant Pages

  • Re: unconstrained array type problems
    ... yes that would work if the arrays each had its own data file. ... read in dimensions of array1 ... read in dimensions of array2 ...
    (comp.lang.ada)
  • Re: overginign two arrays to a package!
    ... my @array1 = @; ... my @array2 = @; ... I think you should point out that copying the arrays like this could be ...
    (comp.lang.perl.misc)
  • Re: Merging Multiple Array elements
    ... So I have to summing all the sub arrays ... use warnings; ... my @array2 =; ... While you call your arrays by fixed names (array1, array2, arrayfoo) ...
    (comp.lang.perl.misc)
  • Re: Array.sort with bignum fails?
    ... In case @array1 has no purpose (other than holding the values to be ... until they are sorted) and the one-element arrays are not wanted, ... My objective is to sort @array2 by numeric code and make a binary ... "bsearch" with simple array it's ok, but array into array dont't work. ...
    (comp.lang.ruby)
  • Re: Array.sort with bignum fails?
    ... In case @array1 has no purpose (other than holding the values to be ... until they are sorted) and the one-element arrays are not wanted, ... My objective is to sort @array2 by numeric code and make a binary ...
    (comp.lang.ruby)