«id» «word»  
  1  смелый
  2  храбрый

«id» «word» «words_id» «synonym_id»
 1   смелый      1          2
 2   храбрый     2          1

create or alter procedure SP_ADD_SYNONYMS (
    IN_WORD_ID integer,
    IN_LIST_SYNONYM varchar(32000) character set WIN1251)
as
declare variable VAR_SYNONYM varchar(30);
declare variable VAR_SYNONYM_ID integer;
declare variable VAR_ Word varchar(30) character set WIN1251;
begin
--format variable "IN_LIST_SYNONYM" (ARRAY) must be: (~1628~1659~1456~1627~)
  select mt. Word
    from Words mt
      where mt.ID = :IN_WORD_ID
        into :VAR_ Word;

  for select ID, Word
        from Words
          where :IN_LIST_SYNONYM CONTAINING '~'||"ID"||'~'
          into :VAR_SYNONYM_ID,
               :VAR_SYNONYM  do
  begin
    insert into SYNONYM (Word, Word_ID, SYNONYM_ID)
      values (:VAR_ Word, :IN_WORD_ID, :VAR_SYNONYM_ID);

     insert into SYNONYM (Word, EW1_ID, SYNONYM_ID)
       values (:VAR_SYNONYM, :VAR_SYNONYM_ID, :IN_WORD_ID);
  end
  suspend;
end^