use tempdb;
go

create function dbo.fnPartOfSpeech
(
 @word varchar(100)
)
returns table
as
return (
 with WordEndings as
 (
  select
   t.mask, '%' + t.we as we
  from
   (
    values
     (1, 'ее'), (1, 'ие'), (1, 'ые'), (1, 'ое'), (1, 'ими'), (1, 'ыми'), (1, 'ей'),  
     (1, 'ий'), (1, 'ый'), (1, 'ой'), (1, 'ем'), (1, 'им'),(1, 'ым'),(1, 'ом'),(1, 'его'), 
     (1, 'ого'),(1, 'ему'),(1, 'ому'),(1, 'их'),(1, 'ых'),(1, 'ую'),(1, 'юю'),(1, 'ая'), 
     (1, 'яя'),(1, 'ою'),(1, 'ею'), 

     (2, 'ивш'),(2, 'ывш'),(2, 'ующ'),(2, 'ем'),(2, 'нн'),(2, 'вш'),(2, 'ющ'), 
     (2, 'щ'),(2, 'ущи'),(2, 'ющи'), (2, 'ящий'),(2, 'щих'),(2, 'щие'),

     (4, 'ила'), (4, 'ыла'), (4, 'ена'), (4, 'ейте'), (4, 'уйте'), (4, 'ите'), 
     (4, 'или'), (4, 'ыли'), (4, 'ей'),  (4, 'уй'), (4, 'ил'), (4, 'ыл'), 
     (4, 'им'), (4, 'ым'), (4, 'ен'), (4, 'ило'), (4, 'ыло'), (4, 'ено'), 
     (4, 'ят'), (4, 'ует'), (4, 'уют'), (4, 'ит'), (4, 'ыт'), (4, 'ены'), (4, 'ить'), 
     (4, 'ыть'), (4, 'ишь'), (4, 'ую'), (4, 'ю'), (4, 'ла'), (4, 'на'), (4, 'ете'), 
     (4, 'йте'), (4, 'ли'), (4, 'й'), (4, 'л'), (4, 'ем'), (4, 'н'), (4, 'ло'), (4, 'но'), 
     (4, 'ет'), (4, 'ют'), (4, 'ны'), (4, 'ть'), (4, 'ешь'), (4, 'нно'),

     (8, 'а'),(8, 'ев'),(8, 'ов'),(8, 'ие'),(8, 'ье'),(8, 'е'),(8, 'иями'), 
     (8, 'ями'),(8, 'ами'),(8, 'еи'),(8, 'ии'),(8, 'и'),(8, 'ией'), 
     (8, 'ей'),(8, 'ой'),(8, 'ий'),(8, 'й'),(8, 'иям'),(8, 'ям'),(8, 'ием'), 
     (8, 'ем'),(8, 'ам'),(8, 'ом'),(8, 'о'),(8, 'у'),(8, 'ах'),(8, 'иях'), 
     (8, 'ях'),(8, 'ы'),(8, 'ь'),(8, 'ию'),(8, 'ью'),(8, 'ю'),(8, 'ия'), 
     (8, 'ья'),(8, 'я'),(8, 'ок'), (8, 'мва'), (8, 'яна'), (8, 'ровать')
   ) t(mask, we)
 )
 select
  sum(a.mask) as mask
 from
  (select ltrim(rtrim(@word))) t(word) cross apply
  (
   select top (1) with ties mask from WordEndings where t.word like we order by row_number() over (partition by mask order by len(we) desc)
  ) a(mask) 
);
go

declare @t table (s varchar(100));
insert into @t
values
 ('Автоматический выключатель АП 50Б-3МТ'),
 ('Выключатель АП 50Б'),
 ('Выключатель автоматический серии АП-50Б');

select
 t.s, stuff(d.s, 1, 1, upper(left(d.s, 1)))
from
 @t t cross apply
 (
  select
   case when b.mask is not null then lower(a.value) else a.value end + ' '
  from
   string_split(t.s, ' ') a outer apply
   dbo.fnPartOfSpeech(a.value) b 
  order by
   case when b.mask = 8 and row_number() over (partition by case when b.mask = 8 then 1 else 0 end order by (select 1)) = 1 then 0 else 1 end,
   row_number() over (order by (select 1))
  for xml path(''), type
 ) c(x) cross apply
 (select c.x.value('.', 'varchar(100)')) d(s);
go

drop function dbo.fnPartOfSpeech;
go