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

Here are the results of your fuzzy-string dictionary search for “sneaker” 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.

55 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
sneaker	11	29	1045	(None)
sneaked	12	32	969	1	sneaked
sneakers	12	30	864	1	sneakers
sneakier	12	4	514	1	sneakier
speaker	13	33	1121	1	speaker
beaker	12	55	2069	2	_beaker
bleaker	13	35	1053	2	bleaker
breaker	13	39	1292	2	breaker
kneader	12	7	589	2	kneader
leaker	10	46	2007	2	_leaker
nearer	6	46	1889	2	_nearer
neater	6	44	2431	2	_neater
necker	12	40	1279	2	_necker
saker	9	51	3202	2	s__aker
sealer	6	39	2896	2	s_ealer
seamer	8	42	2361	2	s_eamer
searer	6	54	3202	2	s_earer
seater	6	45	3416	2	s_eater
seeker	10	36	1536	2	s_eeker
shaker	13	43	1946	2	s_haker
shearer	10	44	1468	2	shearer
slaker	10	42	1927	2	s_laker
sleeker	11	33	982	2	sleeker
smearer	9	41	1040	2	smearer
snacker	13	31	1260	2	snacker
snake	9	48	2111	2	sn_ake_
snaked	11	50	1759	2	sn_aked
snakes	10	39	1960	2	sn_akes
snakey	13	50	1127	2	sn_akey
snakier	11	28	1000	2	sn_akier
snarer	6	46	2084	2	sn_arer
sneak	9	60	1617	2	sneak__
sneakered	14	4	371	2	sneakered
sneaks	10	43	1249	2	sneak_s
sneaky	13	42	784	2	sneak_y
sneaped	10	33	881	2	sneaped
sneer	5	49	1995	2	sne__er
sneerer	7	35	1231	2	sneerer
sneezer	16	23	796	2	sneezer
sneller	7	35	1284	2	sneller
snicker	13	30	1267	2	snicker
snooker	11	39	1030	2	snooker
soaker	10	57	1753	2	s_oaker
speakers	14	29	945	2	speakers
spearer	9	39	1366	2	spearer
squeaker	21	8	488	2	squeaker
stealer	7	29	1397	2	stealer
steamer	9	33	1309	2	steamer
streaker	12	22	948	2	streaker
swearer	10	34	995	2	swearer
sweater	10	37	1272	2	sweater
uneager	8	3	975	2	uneager
unmaker	13	27	951	2	unmaker
weaker	13	40	1544	2	_weaker
wreaker	14	36	1004	2	wreaker

Search took 4 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	107671	0.406	440125.6
2	DLD Change Limit	107671	55	3.110	34620.9
3	Display Results	55	55	0.030	1833.3
	(SQL Overall)	178691	55	3.546	50392.3