This query returns the linked list of your comments (along with score and post where you've posted them) partially matching the entered comment text. Search is not case sensitive. The UserID parameter is your user ID (by default prefilled with your user ID) and the CommentText is the text which you want to search for.
Q&A for those who study, teach, research and apply economics and econometrics
DECLARE @MyUserID INT = ##UserID:int##
DECLARE @CommentText nvarchar(600) = ##CommentText:string##
SELECT @CommentText = UPPER(@CommentText)
PostId AS [Post Link],
Score AS [Score],
Id AS [Comment Link],
CreationDate AS [Creation Date]
UserId = @MyUserID AND
UPPER(Text) LIKE '%' + @CommentText + '%'