Find missing record and return adjacent records SQL, Sql Server

Language: Layout:

create table Results ([BatchId] varchar(13), [CreateDate] datetime, [UserId] varchar(8), [Batch] int) ; 
insert into Results ([BatchId], [CreateDate], [UserId], [Batch]) values 
    ('4L182855 - 1', '2017-09-28 14:04:46', '4L182855', 9),
    ('4L182855 - 2', '2017-09-28 15:19:32', '4L182855', 9),
    ('4L182855 - 4', '2017-09-28 17:57:20', '4L182855', 9),
    ('4L182855 - 5', '2017-09-28 18:20:57', '4L182855', 9),
    ('4L182855 - 1', '2017-09-29 11:04:46', '4L182855', 0),
    ('4L182855 - 2', '2017-09-29 11:19:32', '4L182855', 0),
    ('4L182855 - 3', '2017-09-29 11:30:27', '4L182855', 0),
    ('4L182855 - 4', '2017-09-29 11:57:20', '4L182855', 0),
    ('4L182855 - 5', '2017-09-29 12:00:57', '4L182855', 0),
    ('4L182855 - 6', '2017-09-29 12:04:46', '4L182855', 0),
    ('4L182855 - 7', '2017-09-29 12:19:32', '4L182855', 0),
    ('4L182855 - 8', '2017-09-29 12:30:27', '4L182855', 0),
    ('4L182855 - 10','2017-09-29 14:20:57', '4L182855', 0)

select s.BatchId, s.CreateDate, s.UserId, s.Batch
from (
  select t.*
    , PrevSeq = lag(x.BatchSeq)  over (partition by Batch order by CreateDate)
    , x.BatchSeq
    , NextSeq = lead(x.BatchSeq) over (order by CreateDate)
  from results t
    cross apply (values (convert(int,stuff(t.batchid,1,charindex('- ',t.batchid)+1,'')))
      ) x (BatchSeq)
  ) s
where BatchSeq - isnull(PrevSeq,0) != 1 
  or (BatchSeq - NextSeq !=-1 and NextSeq != 1)
order by createdate

View schema
Execution time: 0,02 sec, rows selected: 4, rows affected: 13, absolute service time: 0,17 sec