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

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

79 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
swaths	12	53	1264	(None)
snaths	9	51	1291	1	snaths
swarths	13	53	732	1	swarths
swath	11	59	2038	1	swath_
swathe	12	55	1411	1	swathe
swathes	13	41	1551	1	swathes
swats	8	57	2686	1	swat_s
baths	10	59	2292	2	_baths
deaths	10	59	1444	2	deaths
heaths	12	63	1638	2	heaths
laths	8	60	2240	2	_laths
maths	10	56	2402	2	_maths
oaths	8	61	1731	2	_oaths
paths	10	55	2138	2	_paths
sates	5	49	4932	2	s_ates
satis	5	56	3368	2	s_atis
scathe	11	44	1499	2	scathe
scathes	12	45	1571	2	scathes
scats	7	59	3060	2	scat_s
scatts	8	59	1466	2	scatts
seats	5	48	4434	2	seat_s
shahs	11	59	1951	2	sha_hs
sheaths	13	5	875	2	sheaths
sixths	16	41	637	2	sixths
skates	10	42	1940	2	skates
skats	9	46	2154	2	skat_s
slates	6	49	3406	2	slates
slats	5	54	3690	2	slat_s
sloths	9	49	1189	2	sloths
smiths	11	47	1102	2	smiths
snath	8	64	1980	2	snath_
snathe	9	44	1511	2	snathe
snathes	10	48	1649	2	snathes
sooths	9	57	1559	2	sooths
soths	8	62	1863	2	s_oths
souths	9	52	1660	2	souths
spates	8	50	2817	2	spates
spathe	11	51	1569	2	spathe
spathes	12	51	1653	2	spathes
spats	7	50	3138	2	spat_s
staphs	11	44	1103	2	staphs
states	6	43	3708	2	states
stats	5	59	3336	2	stat_s
status	6	55	1521	2	status
straths	10	27	1172	2	straths
swabs	10	58	1727	2	swa_bs
swages	10	44	1707	2	swages
swags	9	49	2125	2	swa_gs
swails	9	49	1312	2	swails
swains	9	45	1395	2	swains
swales	9	39	2076	2	swales
swamis	11	42	1229	2	swamis
swamps	13	59	1026	2	swamps
swanks	13	48	1156	2	swanks
swans	8	46	2501	2	swa_ns
swaps	10	48	1920	2	swa_ps
swards	10	54	1513	2	swards
swarfs	12	56	1206	2	swarfs
swarms	11	61	1217	2	swarms
swarth	12	60	1208	2	swarth_
swarthy	16	46	637	2	swarthy
swash	11	63	1675	2	swash_
swashes	13	47	1440	2	swashes
swat	7	72	4444	2	swat__
swatch	14	54	928	2	swatch
swatches	16	16	996	2	swatches
swathed	14	46	1193	2	swathed
swather	13	42	1360	2	swather
swathers	14	45	1208	2	swathers
sways	11	55	1846	2	swa_ys
sweats	9	48	1461	2	sweat_s
swith	11	59	1740	2	swith_
swithe	12	40	1068	2	swithe
swots	8	55	1843	2	swot_s
synths	12	37	788	2	synths
twats	8	66	1660	2	twat_s
wats	7	75	5588	2	_wat_s
watts	8	69	2309	2	_watts
wraths	12	38	1008	2	wraths

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.343	520965.0
2	DLD Change Limit	82551	79	2.393	34496.9
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	2.766	64602.7