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

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

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.

97 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
brisk	11	56	1598	(None)
bisk	10	65	2336	1	b_isk
brick	13	46	1815	1	brick
brink	11	61	2200	1	brink
bris	6	55	3961	1	bris_
brisks	12	46	1140	1	brisks
briss	7	58	2427	1	briss
brusk	11	49	1243	1	brusk
frisk	12	53	1237	1	frisk
risk	8	57	2411	1	_risk
abris	7	57	2261	2	abris_
arise	5	64	3643	2	arise
bask	10	51	3142	2	b_ask
bilk	10	58	2443	2	b_ilk
birk	10	63	2687	2	b_irk
birks	11	49	2030	2	birks
birse	7	45	1740	2	birse
bis	5	68	6067	2	b_is_
bise	6	64	3711	2	b_ise
bisks	11	54	1680	2	b_isks
blink	11	57	2014	2	blink
bliss	7	56	1691	2	bliss
boink	11	55	1633	2	boink
bosk	10	58	2573	2	b_osk
braise	8	43	1875	2	braise
brank	11	52	2228	2	brank
bras	6	57	4645	2	bras_
brash	10	62	2156	2	brash
brass	7	54	2802	2	brass
break	11	53	1940	2	break
briar	7	57	1815	2	briar
bribe	9	48	2078	2	bribe
bricks	14	46	1462	2	bricks
bricky	17	48	909	2	bricky
bride	8	64	2554	2	bride
brie	6	58	3790	2	bri_e
brief	10	54	2260	2	brief
brier	7	45	2740	2	brier
bries	7	49	4215	2	bries
brig	7	65	2803	2	bri_g
brigs	8	58	2322	2	brigs
brill	7	48	1995	2	brill
brim	8	56	2937	2	bri_m
brims	9	47	2162	2	brims
brin	6	70	3819	2	bri_n
brine	7	51	3227	2	brine
bring	8	55	2850	2	bring
brinks	12	46	1631	2	brinks
brins	7	55	3397	2	brins
briny	10	47	1966	2	briny
brio	6	54	3249	2	bri_o
brios	7	47	2573	2	brios
brises	8	49	2761	2	brises
brisked	14	42	1000	2	brisked
brisker	13	42	1029	2	brisker
brisket	13	44	1340	2	brisket
briskly	16	16	540	2	briskly
brit	6	63	5015	2	bri_t
brith	10	49	2437	2	brith
brits	7	64	3309	2	brits
britska	13	13	289	2	britska
britt	7	57	3223	2	britt
brock	13	60	1707	2	brock
brook	11	47	1776	2	brook
bros	6	56	3566	2	bros_
brose	7	52	2703	2	brose
brosy	10	61	1538	2	brosy
bruise	8	34	1287	2	bruise
brush	10	59	1747	2	brush
busk	10	54	2922	2	b_usk
crick	13	51	1875	2	crick
cris	6	62	3343	2	cris_
crisp	9	50	1462	2	crisp
disk	9	66	2584	2	_disk
drink	10	68	1638	2	drink
frise	8	53	2245	2	frise
frisks	13	47	926	2	frisks
frisky	16	40	667	2	frisky
grist	6	55	2987	2	grist
iris	4	57	3255	2	iris_
kris	8	64	2361	2	kris_
prick	13	43	1750	2	prick
prink	11	47	1967	2	prink
prise	7	46	3261	2	prise
prism	9	48	2026	2	prism
priss	7	46	2389	2	priss
rick	10	73	3466	2	_rick
rink	8	77	3700	2	_rink
rise	4	59	4524	2	_rise
risks	9	49	1706	2	_risks
risky	12	63	1152	2	_risky
rusk	8	58	2331	2	_rusk
sris	4	54	3415	2	sris_
trick	11	54	2069	2	trick
whisk	15	45	1014	2	whisk
wrick	14	40	1339	2	wrick
wrist	8	48	2756	2	wrist

Search took 5 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	53800	0.626	285448.9
2	DLD Change Limit	53800	97	3.580	15027.9
3	Display Results	97	97	0.106	915.1
	(SQL Overall)	178691	97	4.312	41440.4