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

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

62 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
heathers	14	39	1473	(None)
feathers	14	35	1324	1	feathers
heaters	10	42	2522	1	heat_ers
heathens	14	32	1015	1	heathens
heather	13	39	1485	1	heather_
heathery	17	34	908	1	heathery
leathers	11	42	1508	1	leathers
sheathers	15	5	755	1	sheathers
weathers	14	34	1283	1	weathers
aethers	10	36	1494	2	ae_thers
bathers	12	47	2036	2	_bathers
beaters	9	49	2504	2	beat_ers
blathers	13	47	1379	2	blathers
breathers	14	31	910	2	breathers
cheaters	13	36	1351	2	cheat_ers
eaters	6	55	3595	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	1507	2	_gathers
hatchers	16	31	1317	2	h_atchers
haters	9	49	3040	2	h_at_ers
hatters	10	42	2152	2	h_atters
headers	11	38	1939	2	hea_ders
healers	10	43	1946	2	hea_lers
heapers	12	36	1667	2	hea_pers
hearers	10	43	1978	2	hea_rers
heater	9	48	2830	2	heat_er_
heathen	13	34	1089	2	heathe_n
heathenry	18	4	340	2	heathenry
heathered	16	14	946	2	heathered
heathier	14	3	834	2	heathier_
heathless	15	3	559	2	heathless
heaths	12	63	1638	2	heath__s
heatless	11	30	1146	2	heatless
heavers	13	37	1719	2	hea_vers
hefters	13	43	1200	2	heft_ers
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	1044	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	635	2	regathers
seaters	7	40	2894	2	seat_ers
sheather	14	5	823	2	sheather_
sheathes	14	6	1019	2	sheathe_s
slathers	11	39	1478	2	slathers
swathers	14	45	1208	2	swathers
teachers	13	32	1239	2	teachers
teethers	11	32	871	2	teethers
tethers	10	38	1531	2	te_thers
theaters	11	42	1190	2	theat_ers
weather	13	35	1322	2	weather_
wethers	13	52	1469	2	we_thers
wreathers	15	25	749	2	wreathers

Search took 6 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.813	219792.1
2	DLD Change Limit	121059	62	4.156	29128.7
3	Display Results	62	62	0.030	2066.7
	(SQL Overall)	178691	62	4.999	35745.3