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

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

82 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
larboards	12	4	698	(None)
garboards	13	4	636	1	garboards
lapboards	14	10	537	1	lapboards
larboard	11	5	766	1	larboard_
cardboards	16	4	533	2	cardboards
clapboards	17	11	367	2	clapboards
dartboards	14	4	388	2	dartboards
garboard	12	4	724	2	garboard_
hardboards	17	4	516	2	hardboards
lapboard	13	5	578	2	lapboard_
leeboards	12	4	479	2	leeboards
starboards	13	6	530	2	starboards
tagboards	13	4	513	2	tagboards
aboard	9	3	1261	3	_a_board_
arbores	9	40	1603	3	_arbo_res
arbors	8	47	1788	3	_arbo_r_s
arbours	9	39	1004	3	_arbour_s
backboards	21	4	619	3	backboards
bargeboards	17	5	264	3	bargeboards
barnyards	15	4	349	3	barnyards
baseboards	15	4	521	3	baseboards
bedboards	15	11	487	3	bedboards
blackboards	22	5	383	3	blackboards
boards	9	46	1693	3	___boards
boxboards	21	4	426	3	boxboards
callboards	15	4	497	3	callboards
carbarns	12	3	856	3	carb_arns
carbonaras	14	4	445	3	carbonaras
carboras	12	3	1158	3	carbo_ras
cardboard	15	4	586	3	cardboard_
carloads	11	3	839	3	carloa_ds
clapboard	16	8	395	3	clapboard_
clipboards	17	10	301	3	clipboards
corkboards	19	4	411	3	corkboards
cupboards	16	4	381	3	cupboards
darbars	10	5	1009	3	darb_ar_s
dartboard	13	4	425	3	dartboard_
dashboards	17	4	348	3	dashboards
fallboards	16	4	443	3	fallboards
farmyards	18	4	281	3	farmyards
fireboards	16	4	543	3	fireboards
flashboards	20	5	247	3	flashboards
floorboards	17	9	190	3	floorboards
gabbards	14	4	575	3	ga_bbards
harbors	12	4	1241	3	harbo_r_s
harbours	13	4	692	3	harbour_s
hardboard	16	4	558	3	hardboard_
headboards	17	4	433	3	headboards
inboards	11	4	584	3	_inboards
keyboards	19	4	396	3	keyboards
labors	8	40	1641	3	la_bo_r_s
labours	9	34	989	3	la_bour_s
labroids	11	5	584	3	labro_ids
laggards	11	30	705	3	la_ggards
landwards	14	4	550	3	landwards
laniards	9	6	731	3	la_niards
lanyards	12	6	639	3	la_nyards
leaderboards	16	5	205	3	leaderboards
leeboard	11	4	543	3	leeboard_
linerboards	14	5	250	3	linerboards
mopboards	16	4	375	3	mopboards
outboards	12	4	621	3	outboards
packboards	21	4	444	3	packboards
paperboards	18	6	365	3	paperboards
pegboards	15	4	402	3	pegboards
preboards	14	4	642	3	preboards
reboards	11	3	877	3	_reboards
rubboards	14	4	328	3	rubboards
sailboards	13	4	548	3	sailboards
seaboards	12	4	644	3	seaboards
skyboards	19	4	377	3	skyboards
starboard	12	7	584	3	starboard_
surfboards	16	4	368	3	surfboards
tabards	10	3	1038	3	ta_b_ards
tackboards	19	4	436	3	tackboards
tagboard	12	4	556	3	tagboard_
tailboards	13	4	508	3	tailboards
teaboards	12	4	539	3	teaboards
wakeboards	20	4	449	3	wakeboards
wallboards	16	4	445	3	wallboards
warlords	12	4	530	3	warlo_rds
washboards	19	4	409	3	washboards

Search took 9 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	82	7.626	19491.3
3	Display Results	82	82	0.046	1782.6
	(SQL Overall)	178691	82	8.092	22082.4