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

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

82 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
bleaks	12	51	1243	(None)
beaks	11	53	2662	1	b_eaks
bleak	11	59	1538	1	bleak_
blears	8	51	1645	1	blears
bleats	8	55	1861	1	bleats
breaks	12	48	1642	1	breaks
leaks	9	59	2391	1	_leaks
beads	8	54	2950	2	b_eads
beak	10	65	3438	2	b_eak_
beaky	14	61	1802	2	b_eaky
beams	9	53	2817	2	b_eams
beans	7	57	3469	2	b_eans
bears	7	57	3904	2	b_ears
beats	7	60	4224	2	b_eats
beaus	7	51	2711	2	b_eaus
becks	13	55	2201	2	b_ecks
belays	11	43	1385	2	belays
beleaps	11	3	805	2	beleaps
berks	11	54	2312	2	b_erks
blabs	9	56	1963	2	bl_abs
blacks	14	49	1495	2	blacks
blahs	10	56	1651	2	bl_ahs
blams	9	50	2385	2	bl_ams
blanks	12	41	1289	2	blanks
blats	7	51	3250	2	bl_ats
blaws	10	56	2046	2	bl_aws
bleach	13	36	1140	2	bleach
bleaker	13	35	1053	2	bleaker
bleakest	14	3	628	2	bleakest
bleakish	17	4	505	2	bleakish
bleakly	16	3	466	2	bleakly
blear	7	59	1868	2	blea_r
bleary	11	51	1255	2	bleary
bleat	7	57	3700	2	blea_t
blebs	9	64	1615	2	ble_bs
bleeds	9	52	1159	2	bleeds
bleeps	10	49	910	2	bleeps
blends	9	60	1288	2	blends
bless	7	59	1781	2	ble_ss
blets	7	53	2494	2	ble_ts
blinks	12	46	1357	2	blinks
bloats	8	52	1576	2	bloats
blocks	14	45	1394	2	blocks
breads	9	54	1920	2	breads
break	11	53	1940	2	break_
breams	10	48	1504	2	breams
breeks	12	53	1079	2	breeks
cleans	8	58	1705	2	cleans
clears	8	41	1656	2	clears
cleats	8	49	1931	2	cleats
cleeks	12	50	1054	2	cleeks
clerks	12	45	884	2	clerks
cloaks	12	44	1126	2	cloaks
creaks	12	43	1596	2	creaks
fleams	11	50	1194	2	fleams
fleas	8	64	2366	2	flea_s
flecks	15	43	1080	2	flecks
freaks	13	47	1306	2	freaks
gleams	9	48	1225	2	gleams
gleans	7	50	1474	2	gleans
gleeks	11	48	967	2	gleeks
leads	6	60	2849	2	_leads
leafs	8	57	2118	2	_leafs
leak	8	62	3371	2	_leak_
leaky	12	52	1772	2	_leaky
leans	5	55	3625	2	_leans
leaps	7	55	2293	2	_leaps
lears	5	59	3873	2	_lears
leas	4	59	5418	2	_lea_s
leeks	9	53	1889	2	_leeks
leks	8	54	2760	2	_le_ks
peaks	11	48	2562	2	_peaks
pleads	9	46	1395	2	pleads
pleas	7	56	2703	2	plea_s
pleats	8	52	1859	2	pleats
sleeks	10	45	1246	2	sleeks
sneaks	10	43	1249	2	sneaks
speaks	12	51	1458	2	speaks
steaks	10	44	1585	2	steaks
teaks	9	42	2290	2	_teaks
tweaks	13	3	596	2	tweaks
wreaks	13	47	1111	2	wreaks

Search took 3 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	82551	0.343	520965.0
2	DLD Change Limit	82551	82	2.280	36206.6
3	Display Results	82	82	0.033	2484.8
	(SQL Overall)	178691	82	2.656	67278.2