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

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

47 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
heifers	13	3	793	(None)
heifer	12	3	820	1	heifer_
ceilers	9	39	1253	2	ceilers
defers	10	51	1694	2	de_fers
defiers	11	39	1399	2	defiers
deicers	10	36	1273	2	deicers
deifiers	12	34	899	2	deifiers
eiders	7	43	2136	2	_eiders
fifers	12	54	1492	2	_fifers
hailers	10	40	1726	2	hailers
headers	11	38	1939	2	headers
healers	10	43	1946	2	healers
heapers	12	36	1667	2	heapers
hearers	10	43	1978	2	hearers
heaters	10	42	2522	2	heaters
heavers	13	37	1719	2	heavers
heders	10	41	1976	2	he_ders
hedgers	12	43	1026	2	hedgers
heeders	11	42	1374	2	heeders
heelers	10	38	1562	2	heelers
hefters	13	43	1200	2	hefters
heiress	10	3	681	2	heiress
heirs	8	56	1856	2	hei__rs
heisters	11	34	1313	2	heisters
hellers	10	36	1983	2	hellers
helpers	12	33	1185	2	helpers
hemmers	14	33	1084	2	hemmers
herders	11	39	1412	2	herders
hewers	12	37	1527	2	he_wers
hexers	16	56	1275	2	he_xers
hiders	10	49	1965	2	h_iders
hikers	13	50	1435	2	h_ikers
hirers	9	45	1806	2	h_irers
hoofers	13	45	1332	2	hoofers
knifers	14	53	708	2	knifers
lifers	9	56	1784	2	_lifers
reefers	10	33	1259	2	reefers
refers	9	39	2108	2	re_fers
reifiers	11	30	984	2	reifiers
reivers	10	51	1708	2	reivers
seiners	7	42	1927	2	seiners
seisers	7	38	1639	2	seisers
seizers	16	41	1250	2	seizers
telfers	10	29	907	2	telfers
veilers	10	39	1182	2	veilers
veiners	10	41	1252	2	veiners
weiners	10	39	1306	2	weiners

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.373	479064.3
2	DLD Change Limit	107671	47	2.940	36622.8
3	Display Results	47	47	0.013	3615.4
	(SQL Overall)	178691	47	3.326	53725.5