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

Here are the results of your fuzzy-string dictionary search for “barehands” with Change Limit: [1] [2] [3] [4]

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.

45 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
barehands	15	4	525	(None)
barehand	14	4	615	1	barehand_
backhands	21	4	630	2	backhands
barchans	15	8	868	2	barchan_s
barehanded	17	4	344	2	barehanded
farmhands	18	4	335	2	farmhands
forehands	16	5	674	2	forehands
armbands	13	5	514	3	_armbands
bacchants	18	4	502	3	bacchants
backhand	20	4	743	3	backhand_
backlands	18	4	682	3	backlands
badlands	12	3	667	3	ba_dlands
barchan	14	6	913	3	barchan__
barehanding	18	7	348	3	barehanding
barehead	14	4	660	3	barehead_
baresarks	15	4	343	3	baresarks
barmaids	13	4	594	3	bar_maids
barnyards	15	4	349	3	barnyards
bartends	11	3	679	3	bar_tends
behinds	13	3	528	3	b__ehinds
brands	9	51	1894	3	b_r__ands
breads	9	54	1920	3	b_re_a_ds
brechans	15	4	741	3	b_rechan_s
brigands	12	4	562	3	b_rigands
chargehands	21	5	130	3	chargehands
darshans	12	8	654	3	darshan_s
farmhand	17	4	356	3	farmhand_
farmlands	15	4	386	3	farmlands
forehand	15	3	769	3	forehand_
forelands	13	4	717	3	forelands
garlands	10	3	832	3	gar_lands
jarheads	19	4	479	3	jarhea_ds
marchlands	18	4	324	3	marchlands
marshlands	16	4	276	3	marshlands
overhands	16	22	780	3	overhands
parklands	16	5	472	3	parklands
rehangs	11	3	756	3	__rehangs
relands	8	52	1488	3	__relands
remands	10	49	1488	3	__remands
sarabands	12	4	559	3	sarabands
stagehands	15	5	233	3	stagehands
warheads	15	4	585	3	warhea_ds
wavebands	18	4	335	3	wavebands
yardlands	14	4	358	3	yardlands
yardwands	17	4	268	3	yardwands

Search took 8 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	148641	0.403	443402.0
2	DLD Change Limit	148641	45	7.500	19818.8
3	Display Results	45	45	0.033	1363.6
	(SQL Overall)	178691	45	7.936	22516.5