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

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

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
backboard	20	4	718	(None)
backboards	21	4	619	1	backboards
blackboard	21	4	425	1	blackboard
buckboard	20	4	423	1	buckboard
packboard	20	4	484	1	packboard
tackboard	18	4	472	1	tackboard
backboned	20	4	548	2	backboned
backload	17	4	683	2	backloa_d
backward	20	4	810	2	back_ward
backyard	20	4	684	2	back_yard
baseboard	14	4	554	2	baseboard
blackboards	22	5	383	2	blackboards
buckboards	21	4	361	2	buckboards
duckboard	19	4	301	2	duckboard
kickboard	17	4	382	2	kickboard
packboards	21	4	444	2	packboards
tackboards	19	4	436	2	tackboards
aboard	9	3	1261	3	_a__board
backbeat	18	4	784	3	backbea_t
backbeats	19	4	576	3	backbeats
backbend	19	4	478	3	backb_end
backbone	18	4	744	3	backbo_ne
backbones	19	4	725	3	backbones
backcourt	19	4	499	3	backcourt
backdoor	17	4	469	3	backdoor_
backhand	20	4	743	3	back_hand
backhoed	20	4	701	3	backho_ed
backland	17	4	810	3	back_land
backloaded	20	4	450	3	backloaded
backloads	18	4	629	3	backloads
backsword	21	4	462	3	backsword
backwards	21	4	746	3	back_wards
backwood	20	4	697	3	backwo_od
backyards	21	4	653	3	back_yards
bankcard	17	7	402	3	bank_card
bargeboard	16	5	299	3	bargeboard
baseboards	15	4	521	3	baseboards
bedboard	14	11	572	3	b_edboard
billboard	14	4	471	3	billboard
blackbird	20	4	357	3	blackb_ird
blackguard	20	6	245	3	blackguard
bodyboard	18	4	330	3	bodyboard
boxboard	20	4	461	3	b_oxboard
callboard	14	4	566	3	callboard
cardboard	15	4	586	3	cardboard
chalkboard	22	5	263	3	chalkboard
corkboard	18	4	477	3	corkboard
dartboard	13	4	425	3	dartboard
dashboard	16	4	380	3	dashboard
duckboards	20	4	272	3	duckboards
fallboard	15	4	505	3	fallboard
garboard	12	4	724	3	ga_rboard
hardboard	16	4	558	3	hardboard
kickboards	18	4	335	3	kickboards
lapboard	13	5	578	3	la_pboard
larboard	11	5	766	3	la_rboard
matchboard	20	5	327	3	matchboard
patchboard	20	5	351	3	patchboard
sailboard	12	4	590	3	sailboard
tagboard	12	4	556	3	ta_gboard
tailboard	12	4	577	3	tailboard
wakeboard	19	4	475	3	wakeboard
wallboard	15	4	502	3	wallboard
washboard	18	4	452	3	washboard

Search took 7 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.420	425454.8
2	DLD Change Limit	148641	64	6.376	23312.6
3	Display Results	64	64	0.030	2133.3
	(SQL Overall)	178691	64	6.826	26178.0