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

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

59 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
barberries	14	4	622	(None)
bayberries	17	4	408	1	bayberries
bearberries	15	5	345	1	bearberries
baneberries	15	5	339	2	baneberries
barretries	12	4	624	2	barretries
bilberries	14	4	494	2	bilberries
blaeberries	15	7	328	2	blaeberries
boxberries	21	4	380	2	boxberries
hagberries	16	7	423	2	hagberries
waxberries	22	4	312	2	waxberries
amberies	12	25	1467	3	_ambe_ries
arteries	8	3	2146	3	_arte_ries
babbitries	13	4	319	3	babbitries
bakeries	14	3	1219	3	ba_ke_ries
barbarities	15	4	499	3	barbarities
barbarizes	23	4	587	3	barbarizes
barbecues	15	14	447	3	barbe_cues
barbeques	22	10	387	3	barbe_ques
barbered	13	25	954	3	barbe_r_ed
barbering	14	22	968	3	barbe_ring
barberry	15	4	485	3	barberr__y
barbers	11	43	1750	3	barbe_r__s
barbettes	13	4	816	3	barbe_ttes
barbies	11	45	1959	3	barb___ies
barbwires	16	4	364	3	barbwir_es
barometries	15	4	768	3	barometries
barratries	12	4	573	3	barratries
basketries	16	4	504	3	basketries
batteries	11	6	1511	3	batte_ries
berberines	14	4	562	3	berberines
berberins	13	4	671	3	berbe_rins
berberis	12	4	660	3	berbe_ri_s
berberises	14	4	489	3	berberises
berries	9	44	2355	3	___berries
bibberies	12	9	712	3	bibbe_ries
blackberries	22	5	271	3	blackberries
blueberries	15	8	308	3	blueberries
bobberies	12	10	789	3	bobbe_ries
braveries	14	3	910	3	brave_ries
briberies	13	4	833	3	bribe_ries
cowberries	17	4	461	3	cowberries
cranberries	15	5	424	3	cranberries
dauberies	12	4	802	3	daube_ries
deerberries	14	5	307	3	deerberries
dewberries	16	4	353	3	dewberries
dogberries	14	4	386	3	dogberries
hackberries	22	5	297	3	hackberries
inkberries	16	4	288	3	inkberries
mulberries	14	4	407	3	mulberries
naseberries	13	5	268	3	naseberries
parterres	11	4	804	3	parterr_es
raspberries	15	5	269	3	raspberries
razzberries	21	13	206	3	razzberries
shadberries	17	5	271	3	shadberries
soapberries	15	5	274	3	soapberries
sugarberries	15	5	205	3	sugarberries
teaberries	12	4	510	3	teaberries
varletries	13	4	602	3	varletries
wardenries	14	4	443	3	wardenries

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	140603	0.156	1145455.1
2	DLD Change Limit	140603	59	6.906	20359.5
3	Display Results	59	59	0.030	1966.7
	(SQL Overall)	178691	59	7.092	25196.1