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

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

64 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
weathers	14	34	1283	(None)
feathers	14	35	1324	1	feathers
heathers	14	39	1473	1	heathers
leathers	11	42	1508	1	leathers
weather	13	35	1322	1	weather_
wethers	13	52	1469	1	we_thers
wreathers	15	25	748	1	wreathers
aethers	10	36	1494	2	ae_thers
aweather	14	3	426	2	aweather_
bathers	12	47	2036	2	_bathers
beaters	9	49	2503	2	beat_ers
blathers	13	47	1379	2	blathers
breathers	14	31	909	2	breathers
eaters	6	55	3594	2	_eat_ers
ethers	9	45	1841	2	_e_thers
fathers	13	39	1650	2	_fathers
feather	13	36	1350	2	feather_
feathery	17	36	807	2	feathery
gathers	11	43	1506	2	_gathers
heaters	10	42	2521	2	heat_ers
heathens	14	32	1015	2	heathens
heather	13	39	1485	2	heather_
heathery	17	34	908	2	heathery
lathers	10	43	2188	2	_lathers
leachers	13	37	1281	2	leachers
leather	10	38	1578	2	leather_
leathern	11	39	891	2	leathern
leathery	14	43	897	2	leathery
loathers	11	33	1043	2	loathers
neatherd	12	10	719	2	neatherd
neatherds	13	9	577	2	neatherds
peachers	15	32	1384	2	peachers
pleathers	14	4	645	2	pleathers
reachers	13	35	1572	2	reachers
regathers	13	3	633	2	regathers
seaters	7	40	2893	2	seat_ers
sheathers	15	5	754	2	sheathers
slathers	11	39	1477	2	slathers
swathers	14	45	1207	2	swathers
sweaters	11	38	1105	2	sweat_ers
teachers	13	32	1239	2	teachers
teethers	11	32	871	2	teethers
tethers	10	38	1531	2	te_thers
washers	13	45	1752	2	w_ashers
watchers	16	35	1179	2	w_atchers
waters	9	50	3062	2	w_at_ers
weaners	10	46	1383	2	wea_ners
wearers	10	46	1590	2	wea_rers
weathered	16	16	851	2	weathered
weatherly	18	4	440	2	weatherly
weavers	13	37	1446	2	wea_vers
weighers	15	13	567	2	weighers
welchers	16	33	805	2	welchers
welshers	14	24	681	2	welshers
welters	10	35	1606	2	welt_ers
wenchers	16	31	921	2	wenchers
westers	10	52	2196	2	west_ers
wether	12	33	1539	2	we_ther_
wetters	10	38	1775	2	we_tters
withers	13	44	1775	2	w_ithers
wreather	14	26	860	2	wreather_
wreathes	14	29	989	2	wreathe_s
writhers	14	39	898	2	writhers
wuthers	13	37	1152	2	w_uthers

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.153	1167915.0
2	DLD Change Limit	121059	64	3.486	34727.2
3	Display Results	64	64	0.016	4000.0
	(SQL Overall)	178691	64	3.655	48889.5