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

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

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.

74 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
patchboards	21	5	315	(None)
matchboards	21	5	289	1	matchboards
patchboard	20	5	351	1	patchboard_
matchboard	20	5	327	2	matchboard_
packboards	21	4	444	2	pa_ckboards
punchboards	21	6	209	2	punchboards
backboards	21	4	619	3	ba_ckboards
catchwords	21	4	338	3	catchwo_rds
dashboards	17	4	348	3	da_shboards
packboard	20	4	484	3	pa_ckboard_
paperboards	18	6	365	3	paperboards
pasteboards	16	5	318	3	pasteboards
patchworks	24	4	355	3	patchwo_rks
punchboard	20	6	224	3	punchboard_
scratchboards	23	6	82	3	scratchboards
switchboards	23	5	170	3	switchboards
tackboards	19	4	436	3	ta_ckboards
washboards	19	4	409	3	wa_shboards
watchbands	21	5	282	3	watchb_ands
watchwords	22	5	329	3	watchwo_rds
backboard	20	4	718	4	ba_ckboard_
bargeboards	17	5	264	4	bargeboards
baseboards	15	4	521	4	ba_seboards
blackboards	22	5	383	4	blackboards
buckboards	21	4	361	4	_buckboards
callboards	15	4	497	4	ca_llboards
cardboards	16	4	533	4	ca_rdboards
catchword	20	6	393	4	catchwo_rd_
dartboards	14	4	388	4	da_rtboards
dashboard	16	4	380	4	da_shboard_
duckboards	20	4	272	4	_duckboards
fallboards	16	4	443	4	fa_llboards
flashboards	20	5	247	4	flashboards
garboards	13	4	636	4	ga__rboards
hardboards	17	4	516	4	ha_rdboards
hatchbacks	26	8	308	4	hatchb_acks
kickboards	18	4	335	4	_kickboards
lapboards	14	10	537	4	la__pboards
larboards	12	4	698	4	la__rboards
matchbooks	23	5	232	4	matchbo_oks
matchboxes	26	5	255	4	matchbo_xes
matchmarks	23	5	262	4	match_marks
matchwoods	21	7	323	4	matchwo_ods
outboards	12	4	621	4	out__boards
paddleboards	19	6	161	4	paddleboards
paperboard	17	6	411	4	paperboard_
particleboards	21	7	82	4	particleboards
pasteboard	15	5	350	4	pasteboard_
patchers	15	34	1330	4	patch__er_s
patchoulis	17	5	253	4	patch_oulis
patchwork	23	4	389	4	patchwo_r_k
pegboards	15	4	402	4	p__egboards
pilchards	17	4	392	4	pilch__ards
pitchforks	24	5	237	4	pitchfo_rks
plasterboards	18	8	173	4	plasterboards
pochards	16	4	685	4	p_och__ards
potshards	15	4	405	4	potsh__ards
preboards	14	4	642	4	p__reboards
pressboards	16	5	224	4	pressboards
sailboards	13	4	548	4	sa_ilboards
scratchboard	22	6	87	4	scratchboard_
skateboards	18	5	342	4	skat_eboards
splashboards	20	5	114	4	splashboards
starboards	13	6	530	4	_starboards
switchboard	22	5	194	4	switchboard_
tackboard	18	4	472	4	ta_ckboard_
tagboards	13	4	513	4	__tagboards
tailboards	13	4	508	4	ta_ilboards
teaboards	12	4	539	4	__teaboards
wakeboards	20	4	449	4	wa_keboards
wallboards	16	4	445	4	wa_llboards
washboard	18	4	452	4	wa_shboard_
watchband	20	4	322	4	watchb_and_
watchword	21	4	355	4	watchwo_rd_

Search took 10 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	148819	0.153	1167915.0
2	DLD Change Limit	148819	74	9.596	15508.4
3	Display Results	74	74	0.030	2466.7
	(SQL Overall)	178691	74	9.779	18272.9