...
At the beginning of this exercise (January 13, 2011) there were 34,187 distinct object names among approximately 640,000 records (the initial query did not exclude virtual and template records).
Excluding virtual and template records, there were 33,148 distinct, non-null object names used for 536,372 objects.
As of January 31, 2011, there were 27,999 distinct, non-null object names used for 535,967 objects (named object count was reduced as meaningless names such as "fragment" or "object" were eliminated).
The strategy we decided to follow was this:
...
The following strings were removed from MTB_ObjectName:
- Veryvery
- Smallsmall
- Fragmentfragment[.][,]
- Fragmentsfragments[.][,]
- fragment[s]
- Fragments of
- Fragments of a
- Fragment of
- Fragment of aof [a]
- [;][,][:] frags
- yellow, purple, pink, blue, orange, brown
- 1, 2, 3, 4, 5, 6, 7, 8, 9 (beginning of string only, followed by space)
- two, three, four, five
The following strings still need to be removed from MTB_ObjectName:
...