Well, the text is very, very long. You know you cannot do WHERE text = 'ADAD', you have to use 'like', remember? You cannot do DISTINCT textcol since it is too hard for a RDBMS to compare text columns.
Sorry, no can do. You could perhaps select the text column and ID into a temp table, then outer join to the main table where maintable.text LIKE 'othercol'
But that may not work. You'll probably have to do it in your application.