I guess I would have started out with a different schema but if it's too late for that:
select left(language, (len(language) - 3))
where right(name, 2) in (
select right(name, 2) from sysobjects where xtype='u' and name like 'texts___'
Or you could use sp_tables somehow I guess.