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

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

36 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
berberines	14	4	563	(None)
berberine	13	4	652	1	berberine_
berberins	13	4	671	1	berberin_s
berberises	14	4	490	1	berberises
bebeerines	14	5	402	2	bebeerines
berberin	12	4	656	2	berberin__
berberis	12	4	660	2	berberi__s
barbarizes	23	4	587	3	barbarizes
barbering	14	22	968	3	barberin_g
barberries	14	4	623	3	barberries
beaneries	11	3	1090	3	beaneri_es
bearberries	15	5	346	3	bearberries
bebeerine	13	4	429	3	bebeerine_
beelines	10	33	1280	3	be__elines
beeriness	11	3	786	3	be__eriness
bergeres	11	8	911	3	berger__es
beriberis	13	4	352	3	beriberi__s
berlines	10	23	1545	3	ber__lines
berries	9	44	2355	3	ber__ri_es
bibberies	12	9	713	3	bibberi_es
bobberies	12	10	789	3	bobberi_es
borderlines	14	4	325	3	borderlines
breweries	14	4	758	3	breweri_es
briberies	13	4	833	3	briberi_es
eserines	8	4	1374	3	_e_serines
ferneries	12	3	904	3	ferneri_es
merceries	13	4	1004	3	merceri_es
mercerises	14	4	619	3	mercerises
mercerizes	23	4	605	3	mercerizes
pelerines	11	3	1184	3	pe_lerines
peregrines	13	4	651	3	peregrines
teredines	10	4	945	3	ter_edines
terrines	8	21	1755	3	ter__rines
veratrines	13	4	726	3	veratrines
wernerites	13	4	494	3	wernerites
zebrines	19	3	588	3	ze_b_rines

Search took 7 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	140603	0.153	1167915.0
2	DLD Change Limit	140603	36	5.860	23993.7
3	Display Results	36	36	0.016	2250.0
	(SQL Overall)	178691	36	6.029	29638.6