Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “shammy” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

53 similar words found! Changes to Transform each Found Word to your word are shown as:
~~remove a letter~~ ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
shammy	16	38	850	(None)
chammy	18	48	895	1	chammy
hammy	15	51	1343	1	_hammy
shamoy	14	37	991	1	shamoy
shimmy	16	30	641	1	shimmy
whammy	19	37	529	1	whammy
champy	18	50	961	2	champy
chasmy	16	46	854	2	chasmy
chummy	18	38	589	2	chummy
clammy	15	35	633	2	clammy
gammy	13	55	1489	2	_gammy
jammy	19	48	1019	2	_jammy
mammy	11	52	1516	2	_mammy
rammy	12	43	1249	2	_rammy
scummy	15	26	522	2	scummy
seamy	10	59	2127	2	sea_my
shabby	16	3	580	2	shabby
shady	12	54	1651	2	sha_dy
shaggy	14	47	804	2	shaggy
shaky	15	46	1684	2	sha_ky
shaley	12	37	1499	2	shaley
shaly	11	43	2286	2	sha_ly
sham	9	64	3635	2	sha_m_
shaman	11	33	1427	2	shaman
shamas	11	37	1793	2	shamas
shame	10	57	2670	2	sha_me
shamed	12	51	2021	2	shamed
shames	11	47	2622	2	shames
shammas	14	35	871	2	shammas
shammed	15	39	1142	2	shammed
shammer	14	46	1314	2	shammer
shammes	14	43	1283	2	shammes
shammos	14	30	720	2	shammos
shamos	11	42	1698	2	shamos
shamoys	15	36	728	2	shamoys
shams	10	58	2941	2	sha_ms
shamus	11	41	1281	2	shamus
shandy	13	47	1003	2	shandy
shanny	12	41	1009	2	shanny
shanty	12	47	1511	2	shanty
sharny	12	47	1183	2	sharny
sharpy	14	52	1103	2	sharpy
shawm	13	53	1614	2	shawm_
shawms	14	57	956	2	shawms
shay	10	71	3334	2	sha__y
slummy	13	32	586	2	slummy
smarmy	13	62	935	2	smarmy
stemmy	13	41	703	2	stemmy
swampy	16	43	723	2	swampy
swamy	13	67	1440	2	swa_my
swimmy	16	23	435	2	swimmy
tammy	12	40	1322	2	_tammy
whammo	16	40	519	2	whammo

Search took 3 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	82551	0.110	1624463.6
2	DLD Change Limit	82551	53	2.546	32423.8
3	Display Results	53	53	0.030	1766.7
	(SQL Overall)	178691	53	2.686	66526.8