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

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

49 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
blackfin	19	5	390	(None)
blackfins	20	5	439	1	blackfins
backfit	18	10	821	2	b_ackfit
blacken	15	43	979	2	black_en
blackfish	23	4	383	2	blackfish
blackfly	22	4	301	2	blackfly
blacking	17	42	1360	2	black_ing
backbit	17	12	910	3	b_ackbit
backfill	19	6	506	3	b_ackfill
backfire	19	4	600	3	b_ackfire
backfits	19	10	695	3	b_ackfits
backflip	21	4	309	3	b_ackflip
backing	16	55	2344	3	b_ack_ing
backlit	15	9	1190	3	b_acklit
backspin	18	4	542	3	b_ackspin
black	13	47	1907	3	black___
blackbird	20	4	357	3	blackbird
blackboy	21	4	316	3	blackboy
blackcap	20	4	307	3	blackcap
blacked	16	36	1337	3	black_ed
blackening	19	4	479	3	blackening
blackens	16	38	810	3	blackens
blacker	15	45	1351	3	black_er
blackest	16	26	930	3	blackest
blackface	22	4	342	3	blackface
blackflies	21	4	373	3	blackflies
blackgum	19	4	251	3	blackgum
blackings	18	31	676	3	black_ings
blackish	19	7	671	3	blackish
blackland	18	4	465	3	blackland
blackleg	17	3	423	3	blackleg
blacklist	17	4	612	3	blacklist
blackly	18	3	525	3	black_ly
blackmail	19	4	320	3	blackmail
blackout	16	4	741	3	blackout
blacks	14	49	1495	3	black__s
blacktail	17	4	375	3	blacktail
blacktop	18	4	297	3	blacktop
blain	7	54	2179	3	bla___in
blanking	15	44	1193	3	blank_ing
blocking	17	45	1057	3	block_ing
bloodfin	14	4	339	3	bloodfin
bluefin	12	4	512	3	bl_uefin
bracken	15	40	981	3	brack_en
clacking	17	33	1349	3	clack_ing
flacking	18	43	1179	3	flack_ing
lacking	14	38	2154	3	_lack_ing
slacken	13	39	993	3	slack_en
slacking	15	39	1413	3	slack_ing

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	146162	0.423	422437.4
2	DLD Change Limit	146162	49	7.500	19488.3
3	Display Results	49	49	0.030	1633.3
	(SQL Overall)	178691	49	7.953	22468.4