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

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

80 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
blacklegs	18	4	391	(None)
blackleg	17	3	423	1	blackleg_
backless	16	29	1063	2	b_ackless
backlogs	17	4	663	2	b_acklogs
blackens	16	38	810	2	black_ens
blackings	18	31	676	2	blackings
blacklead	18	6	390	2	blacklead
blackleads	19	9	338	2	blackleads
blackness	17	3	566	2	blackness
jacklegs	22	3	395	2	_jacklegs
backers	15	38	2188	3	b_ack_ers
backings	17	40	1221	3	b_ackings
backlog	16	3	577	3	b_acklog_
backsets	16	3	885	3	b_acksets
barkless	14	31	802	3	b_arkless
beakless	14	29	738	3	bea_kless
blackboys	22	4	333	3	blackboys
blackcaps	21	4	335	3	blackcaps
blacked	16	36	1337	3	black_e_d
blacken	15	43	979	3	black_e_n
blackeners	18	4	412	3	blackeners
blacker	15	45	1351	3	black_e_r
blackest	16	26	930	3	black_est
blackfins	20	5	439	3	blackfins
blackflies	21	4	373	3	blackflies
blackgums	20	4	254	3	blackgums
blackhead	21	8	429	3	blackhead
blackheads	22	6	411	3	blackheads
blacking	17	42	1360	3	blacking_
blackland	18	4	465	3	blackland
blacklands	19	4	412	3	blacklands
blacklist	17	4	612	3	blacklist
blacklists	18	4	418	3	blacklists
blackly	18	3	525	3	blackl__y
blackouts	17	4	515	3	blackouts
blacks	14	49	1495	3	black___s
blacktops	19	4	337	3	blacktops
bladeless	12	3	430	3	bladeless
blameless	13	3	473	3	blameless
blankets	14	35	650	3	blank_ets
blankness	15	4	467	3	blankness
blockages	18	4	406	3	blockages
blockers	16	39	879	3	block_ers
bracelets	13	4	596	3	bracelets
brackens	16	32	792	3	brack_ens
brackets	16	33	1043	3	brack_ets
bractless	13	3	554	3	bractless
bractlets	13	4	475	3	bractlets
brickles	16	28	1028	3	brickle_s
bucklers	16	34	950	3	b_ucklers
buckles	15	34	1609	3	b_uckle_s
cacklers	16	37	1070	3	_cacklers
cackles	15	37	1720	3	_cackle_s
clackers	16	39	1170	3	clack_ers
clickless	17	4	398	3	clickless
crackles	16	41	1127	3	crackle_s
fleckless	18	4	289	3	fleckless
flockless	18	4	316	3	flockless
grackles	15	30	918	3	grackle_s
hacklers	17	37	1030	3	_hacklers
hackles	16	29	1706	3	_hackle_s
jackleg	21	3	503	3	_jackleg_
laceless	10	23	985	3	_laceless
lackers	13	41	2054	3	_lack_ers
lackeys	16	45	826	3	_lack_eys
luckless	14	26	589	3	_luckless
mackles	15	44	1575	3	_mackle_s
placeless	13	3	561	3	placeless
plackets	16	4	658	3	plack_ets
shacklers	18	33	603	3	shacklers
shackles	17	30	1059	3	shackle_s
slackens	14	36	771	3	slack_ens
slackers	14	38	1274	3	slack_ers
slackness	15	3	543	3	slackness
spackles	16	31	994	3	spackle_s
stackless	15	5	593	3	stackless
tacklers	14	30	1077	3	_tacklers
tackles	13	38	1652	3	_tackle_s
tackless	14	41	948	3	_tackless
trackless	15	24	672	3	trackless

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.156	1145455.1
2	DLD Change Limit	148641	80	8.470	17549.1
3	Display Results	80	80	0.046	1739.1
	(SQL Overall)	178691	80	8.672	20605.5