How to find number of temp tables currently created in database

use tempdb
go
select * from sys.tables

find last word in string

SELECT RIGHT(Address1,COALESCE(NULLIF(CHARINDEX(' ', REVERSE(Address1)) - 1,-1),LEN(Address1)))