Here is an alternative way to characterize the transpositions, which works in $S_X$ whenever $|X|>6$: $\sigma$ is a transposition if and only if $\sigma$ has order $2$, and for every conjugate $\sigma' = \rho\sigma\rho^{-1}$, $\sigma\sigma'$ has order $1$, $2$, or $3$.
Using this characterization, I sketched the interpretation in $S_X$ of the group action of $S_X$ on $X$ in this answer.
In $S_n$ for $n<6$, the set of transpositions is an automorphism-invariant set (since every automorphism of $S_n$ is inner), and hence definable. But the outer automorphism of $S_6$ does not preserve the set of transpositions, so the set of transpositions is not even definable in $S_6$.
Note that Hodges only claims that his characterization works for symmetric groups on infinite sets. But as established in the comments, the characterization is wrong even in this context. Let's figure out which permutations his condition actually defines.
Let $A$ be a set and $S_A$ the symmetric group on $A$. For $\sigma\in S_A$, let $\DeclareMathOperator{\supp}{supp}\supp(\sigma) = \{a\in A\mid \sigma(a)\neq a\}$. If $\sigma^2 = 1$, then $\supp(\sigma)$ is partitioned into orbits of size $2$, and $\sigma$ transposes the elements of each of these orbits. Let $O_\sigma$ be the set of these orbits, and note that $\sigma$ is uniquely determined by $O_\sigma$.
Now for $\rho\in S_A$, $\rho\in C(\sigma)$ if and only if $\sigma = \rho\sigma\rho^{-1}$ if and only if $O_\sigma = O_{\rho\sigma\rho^{-1}}$ if and only if $O_\sigma = \rho(O_\sigma) = \{\{\rho(a),\rho(b)\}\mid \{a,b\}\in O_\sigma\}$. In other words, $\rho$ commutes with $\sigma$ if and only if $\rho$ permutes the non-trivial orbits of $\sigma$ (and acts arbitrarily on the trivial orbits).
Claim: If $\sigma^2 = \tau^2 = 1$, then $C(\sigma)\leq C(\tau)$ if and only if (a) $\tau = 1$, (b) $\tau = \sigma$, or (c) $\supp(\sigma) = A\setminus \{a,b\}$ for some $a,b\in A$, and $\tau = (a\,b)$ or $\tau = \sigma (a\,b)$.
Proof: If $\tau = 1$, then $C(\sigma)\leq C(\tau) = S_A$. If $\tau = \sigma$, then $C(\sigma) = C(\tau)$. And if (c) holds, then for all $\rho$, if $\rho(O_\sigma) = O_\sigma$, then $\rho(\{a,b\}) = \{a,b\}$, so $\rho(O_\tau) = O_\tau$. Thus $C(\sigma)\leq C(\tau)$.
Conversely, assume $\sigma^2 = \tau^2 = 1$ and $C(\sigma)\leq C(\tau)$. Let $a\in \supp(\sigma)\cap \supp(\tau)$, and suppose $\{a,b\}\in O_\sigma$. Then $(a\,b)\in C(\sigma)$, so $(a\,b)\in C(\tau)$, and thus $\{a,b\}\in O_\tau$. In particular, $\sigma(a) = \tau(a)$. Thus $\sigma$ and $\tau$ agree on $\supp(\sigma)\cap \supp(\tau)$.
Now if $\supp(\sigma)\cap \supp(\tau)$ is non-empty, I claim that $\supp(\sigma)\subseteq \supp(\tau)$. Indeed, pick some $a\in \supp(\sigma)\cap \supp(\tau)$. Now let $b\in \supp(\sigma)$. Let $a' = \sigma(a) = \tau(a)$, and let $b' = \sigma(b)$. Then $(a\,b)(a'\,b')$ swaps the $\sigma$-orbits $\{a,a'\}$ and $\{b,b'\}$, so it is in $C(\sigma)$ and hence in $C(\tau)$. Thus $\{b,b'\}$ is also a $\tau$-orbit, and $b\in \supp(\tau)$.
Case 1: $\supp(\tau)\subseteq \supp(\sigma)$. If $\supp(\tau) = \varnothing$, then $\tau = 1$ and (a) holds. If $\supp(\tau) \neq \varnothing$, then by the claim, $\supp(\sigma)\subseteq \supp(\tau)$, so they are equal. Then $\sigma = \tau$, since they agree on their supports, and (b) holds.
Case 2: $\supp(\tau)\not\subseteq \supp(\sigma)$. Let $a\in \supp(\tau)\setminus \supp(\sigma)$, and let $b = \tau(a)$. Note that $b\notin \supp(\sigma)$, otherwise we would have $\sigma(b) = \tau(b) = a$ and $a\in \supp(\sigma)$. Suppose for contradiction that there is some $c\in A\setminus \supp(\sigma)$ with $c\neq a$ and $c\neq b$. Then $(a\,c)\in C(\sigma)$, since neither $a$ nor $c$ are in $\supp(\sigma)$, but $(a\,c)\notin C(\tau)$, contradiction. Thus $A\setminus \supp(\sigma) = \{a,b\}$.
Now if $\supp(\tau)$ is disjoint from $\supp(\sigma)$, we must have $\tau = (a\,b)$. Otherwise, by the claim, $\supp(\sigma)\subseteq \supp(\tau)$, and since $\tau$ moves $a$ to $b$ and agrees with $\sigma$ on $\supp(\sigma)$, $\tau = \sigma(a\,b)$. In either case, (c) holds. $\square$
This shows that the condition in Hodges actually characterizes those elements of $S_A$ of order $2$ whose suppose is not of the form $S_a\setminus \{a,b\}$ for some $a,b\in A$.