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

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

65 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
swathers	14	45	1208	(None)
slathers	11	39	1478	1	slathers
swashers	14	38	953	1	swashers
swather	13	42	1360	1	swather_
swathes	13	41	1551	1	swathe_s
swatters	11	39	1179	1	swatters
swithers	14	43	1053	1	swithers
bathers	12	47	2036	2	_bathers
blathers	13	47	1379	2	blathers
fathers	13	39	1650	2	_fathers
feathers	14	35	1324	2	feathers
gathers	11	43	1507	2	_gathers
heathers	14	39	1473	2	heathers
lathers	10	43	2188	2	_lathers
leathers	11	42	1508	2	leathers
loathers	11	33	1044	2	loathers
scathes	12	45	1571	2	scathe_s
scatters	10	36	1275	2	scatters
seaters	7	40	2894	2	seat_ers
shatters	11	33	1391	2	shatters
sheathers	15	5	755	2	sheathers
skaters	11	35	1296	2	skat_ers
slashers	11	33	1361	2	slashers
slaters	7	31	2373	2	slat_ers
slather	10	38	1608	2	slather_
slithers	11	42	1295	2	slithers
smashers	13	33	959	2	smashers
smatters	10	40	1171	2	smatters
smithers	13	36	979	2	smithers
smothers	13	34	993	2	smothers
snatchers	14	14	631	2	snatchers
snathes	10	48	1649	2	snathe_s
soothers	11	39	1343	2	soothers
southers	11	42	1445	2	southers
spathes	12	51	1653	2	spathe_s
spatters	10	39	1470	2	spatters
staters	7	39	2234	2	stat_ers
swabbers	15	31	674	2	swabbers
swagers	11	42	1102	2	swa_gers
swaggers	13	40	722	2	swaggers
swampers	15	31	747	2	swampers
swanherd	15	3	348	2	swanherd
swanherds	16	4	254	2	swanherds
swappers	15	35	808	2	swappers
swarmers	13	4	632	2	swarmers
swasher	13	40	1151	2	swasher_
swashes	13	47	1440	2	swashe_s
swatches	16	16	996	2	swatche_s
swathe	12	55	1411	2	swathe__
swathed	14	46	1193	2	swathe_d
swaths	12	53	1264	2	swath__s
swatter	10	41	1332	2	swatter_
swayers	13	39	885	2	swa_yers
sweaters	11	38	1106	2	sweat_ers
swishers	14	32	805	2	swishers
switchers	17	14	663	2	switchers
swither	13	37	1099	2	swither_
swotters	11	44	848	2	swotters
washers	13	45	1752	2	_washers
watchers	16	35	1179	2	_watchers
waters	9	50	3063	2	_wat_ers
weathers	14	34	1283	2	weathers
wethers	13	52	1469	2	_wethers
withers	13	44	1775	2	_withers
wuthers	13	37	1152	2	_wuthers

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	121059	0.373	479064.3
2	DLD Change Limit	121059	65	3.563	33976.7
3	Display Results	65	65	0.016	4062.5
	(SQL Overall)	178691	65	3.952	45215.3