Ref discussion at CA. Let's take Gaussian white noise sequence, data here. Look only at the 100 middle values. Nothing special here.

Then filter that data with (non-causal) moving average , N=5, 21, 49, 75 :

Correlation coefficient doesn't care about the scale, so now you can just choose the filter that gives the answer you want.