SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select @@version;


(No column name)


Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) 
	Oct  8 2022 05:58:25 
	Copyright (C) 2022 Microsoft Corporation
	Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)



CREATE TABLE words(word varchar(40));

INSERT INTO words VALUES
  ('peaches'),
  ('apples');
2 rows affected

with cten as(
   select 1 as x union select 2 union select 3 union 
   select 4 union select 5 union select 6 union 
   select 7 union select 8 union select 9 union select 0
),
cte99 as (
select c1.x*10+c2.x as x
from cten as c1,cten as c2),

cte as (
    select STUFF(word,cte99.x,1,'_') as w
    from 
       words,
       cte99 
    where  cte99.x <= len(word) and cte99.x>0
) 
select * 
from cte
order by w;


w


_eaches

_pples

a_ples

ap_les

app_es

appl_s

apple_

p_aches

pe_ches

pea_hes

peac_es

peach_s

peache_