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

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

71 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
spathes	12	51	1653	(None)
scathes	12	45	1571	1	scathes
snathes	10	48	1649	1	snathes
spates	8	50	2817	1	spat_es
spathe	11	51	1569	1	spathe_
spathed	13	40	1318	1	spathed
swathes	13	41	1551	1	swathes
apaches	14	34	1183	2	apaches
apathies	13	3	900	2	apathies
bathes	11	65	2483	2	_bathes
lathes	9	51	2749	2	_lathes
loathes	10	35	1324	2	loathes
pashes	11	58	2839	2	_pashes
patches	14	33	2038	2	_patches
pates	7	60	4789	2	_pat_es
pathos	11	55	1669	2	_pathos
paths	10	55	2138	2	_path_s
sadhes	10	47	1537	2	s_adhes
sashes	9	47	2848	2	s_ashes
sates	5	49	4932	2	s_at_es
scathe	11	44	1499	2	scathe_
scathed	13	40	1264	2	scathed
scythes	15	35	652	2	scythes
seethes	10	36	1374	2	seethes
sheathes	14	6	1019	2	sheathes
skates	10	42	1940	2	skat_es
slashes	10	36	1910	2	slashes
slatches	13	15	1152	2	slatches
slates	6	49	3406	2	slat_es
slather	10	38	1607	2	slather
slathers	11	39	1478	2	slathers
smashes	12	39	1461	2	smashes
snashes	10	52	1475	2	snashes
snatches	13	14	1071	2	snatches
snathe	9	44	1511	2	snathe_
snaths	9	51	1291	2	snath_s
soothes	10	39	1711	2	soothes
spaces	10	47	2263	2	spa_ces
spades	9	42	2258	2	spa_des
spaes	7	60	2997	2	spa__es
spahee	11	3	1344	2	spa_hee
spahees	12	3	826	2	spahees
spahis	11	3	1038	2	spa_his
spales	8	47	2810	2	spa_les
spares	8	48	3455	2	spa_res
sparges	10	40	1634	2	sparges
spate	7	47	3158	2	spat_e_
spathal	12	3	626	2	spathal
spathic	14	3	754	2	spathic
spathose	13	4	563	2	spathose
spats	7	50	3138	2	spat__s
spatted	10	40	1414	2	spatted
spatter	9	40	1652	2	spatter
spatters	10	39	1470	2	spatters
spatzles	19	3	530	2	spatzles
spavies	12	30	1294	2	spavies
spazzes	17	3	526	2	spazzes
spites	8	41	2733	2	spit_es
spitzes	18	4	918	2	spitzes
splashes	13	3	750	2	splashes
staithes	11	3	895	2	staithes
stashes	10	39	1617	2	stashes
states	6	43	3708	2	stat_es
statues	7	46	1490	2	statues
swashes	13	47	1440	2	swashes
swatches	16	16	996	2	swatches
swathe	12	55	1411	2	swathe_
swathed	14	46	1193	2	swathed
swather	13	42	1360	2	swather
swathers	14	45	1208	2	swathers
swaths	12	53	1264	2	swath_s

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.436	409841.7
2	DLD Change Limit	107671	71	3.500	30763.1
3	Display Results	71	71	0.033	2151.5
	(SQL Overall)	178691	71	3.969	45021.7