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

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

58 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
blacksnakes	18	5	253	(None)
blacksnake	17	5	249	1	blacksnake_
backspaces	22	4	471	3	b_ackspaces
backstages	19	4	501	3	b_ackstages
blackfaces	23	4	356	3	black_faces
backdates	18	4	815	4	b_ack_dates
backsaws	19	4	680	4	b_acks_a_ws
backseats	17	4	667	4	b_acksea_ts
backshores	21	4	532	4	b_ackshores
backsides	18	8	769	4	b_acks_ides
backslaps	19	4	525	4	b_acksla_ps
backslashes	22	5	344	4	b_ackslashes
backslides	19	4	526	4	b_ackslides
backspace	21	4	508	4	b_ackspace_
backspaced	23	4	346	4	b_ackspaced
backstabs	19	4	547	4	b_acksta_bs
backstage	18	4	542	4	b_ackstage_
backstairs	18	4	447	4	b_ackstairs
backstamps	22	4	325	4	b_ackstamps
backstays	20	4	565	4	b_acksta_ys
backstrokes	18	7	306	4	b_ackstrokes
blackballs	20	4	396	4	black_balls
blackboards	22	5	383	4	blackboards
blackbodies	22	5	249	4	blackbodies
blackbucks	21	5	264	4	blackbuck_s
blackcaps	21	4	335	4	black_ca_ps
blackcocks	18	5	260	4	blackcock_s
blackdamps	23	5	218	4	black_damps
blackened	18	4	527	4	blacken__ed
blackener	17	5	497	4	blacken__er
blackeners	18	4	412	4	blacken_ers
blackenings	20	4	256	4	blackenings
blackens	16	38	810	4	blacken___s
blackface	22	4	342	4	black_face_
blackfishes	25	4	350	4	blackfishes
blackflies	21	4	373	4	black_flies
blackguards	21	6	228	4	blackguards
blackhander	23	6	302	4	blackhander
blackhanders	24	6	240	4	blackhanders
blackheads	22	6	411	4	blackhea_ds
blackhearts	22	5	213	4	blackhearts
blackings	18	31	676	4	blackin__gs
blackjacked	28	5	207	4	blackjacked
blackjacks	26	5	312	4	black_jacks
blacklands	19	4	412	4	black_lands
blackleads	19	9	338	4	blacklea_ds
blackmails	20	4	309	4	black_mails
blackness	17	3	566	4	black_n_ess
blacknesses	19	4	499	4	blacknesses
blacksmiths	24	7	214	4	blacksmiths
blacktails	18	4	368	4	black_tails
blackwater	21	10	397	4	black_water
blackwaters	22	10	314	4	black_waters
blockades	18	4	411	4	block__ades
blockages	18	4	406	4	block__ages
bullsnakes	16	5	208	4	b_ullsnakes
jackanapes	25	5	183	4	_jackanapes
jacksnipes	25	5	196	4	_jacksnipes

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.406	440125.6
2	DLD Change Limit	148819	58	9.296	16008.9
3	Display Results	58	58	0.030	1933.3
	(SQL Overall)	178691	58	9.732	18361.2