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

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

74 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
baneberries	15	5	339	(None)
barberries	14	4	623	2	ba_rberries
bayberries	17	4	409	2	ba_yberries
blaeberries	15	7	329	2	blaeberries
blueberries	15	8	308	2	blueberries
naseberries	13	5	268	2	naseberries
baneberry	16	4	278	3	baneberr__y
bearberries	15	5	346	3	bearberries
bilberries	14	4	494	3	b_ilberries
blackberries	22	5	271	3	blackberries
boxberries	21	4	380	3	b_oxberries
bunchberries	21	5	185	3	bunchberries
candleberries	18	6	164	3	candleberries
cranberries	15	5	425	3	cran_berries
hackberries	22	5	298	3	hackberries
hagberries	16	7	424	3	ha_gberries
inkberries	16	4	288	3	_inkberries
lingberries	14	5	282	3	lingberries
pokeberries	19	6	261	3	pokeberries
raspberries	15	5	269	3	raspberries
razzberries	21	13	206	3	razzberries
waxberries	22	4	313	3	wa_xberries
amberies	12	25	1468	4	_a_mbe_ries
anergies	9	3	1045	4	_an__ergies
babbitries	13	4	319	4	ba_bbitries
bakeries	14	3	1219	4	ba__ke_ries
banderoles	13	4	485	4	ban_deroles
banditries	13	4	534	4	ban_ditries
barometries	15	4	769	4	barometries
barretries	12	4	624	4	ba_rretries
basketries	16	4	504	4	ba_sketries
batteries	11	6	1511	4	ba_tte_ries
beaneries	11	3	1090	4	bean__e_ries
bebeerines	14	5	402	4	b__ebeerines
berries	9	44	2355	4	____berries
bewearies	14	4	701	4	b__ewearies
beworries	14	4	484	4	b__eworries
bibberies	12	9	713	4	b_ibbe_ries
binderies	12	3	1168	4	bin_de_ries
bobberies	12	10	789	4	b_obbe_ries
boysenberries	20	6	112	4	boysenberries
breweries	14	4	758	4	b_rewe_ries
briberies	13	4	833	4	b_ribe_ries
canebrakes	18	4	355	4	caneb_rakes
canneries	11	3	1308	4	can_ne_ries
chinaberries	19	5	246	4	chinaberries
chokeberries	23	5	233	4	chokeberries
cowberries	17	4	462	4	_cowberries
crowberries	18	5	320	4	crowberries
dauberies	12	4	803	4	da_ube_ries
deerberries	14	5	307	4	deerberries
dewberries	16	4	353	4	_dewberries
dingleberries	17	6	143	4	dingleberries
dogberries	14	4	386	4	_dogberries
elderberries	15	6	180	4	elderberries
farkleberries	22	6	124	4	farkleberries
gooseberries	15	6	205	4	gooseberries
knobkerries	16	5	172	4	_knobkerries
loganberries	15	5	177	4	logan_berries
manometries	15	4	725	4	manometries
mulberries	14	4	407	4	_mulberries
naboberies	14	4	326	4	nabobe_ries
papeteries	14	4	655	4	papete_ries
rowanberries	17	6	188	4	rowan_berries
shadberries	17	5	272	4	shadberries
sheepberries	19	5	218	4	sheepberries
snowberries	16	5	283	4	snowberries
soapberries	15	5	275	4	soapberries
tanneries	9	3	1042	4	tan_ne_ries
teaberries	12	4	512	4	_teaberries
twinberries	16	5	298	4	twinberries
winterberries	18	9	200	4	winterberries
wolfberries	19	5	232	4	wolfberries
youngberries	18	5	152	4	youngberries

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.470	380193.6
2	DLD Change Limit	148819	74	8.906	16710.0
3	Display Results	74	74	0.030	2466.7
	(SQL Overall)	178691	74	9.406	18997.6