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

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

78 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
blaeberries	15	7	329	(None)
blueberries	15	8	308	1	blueberries
baneberries	15	5	339	2	baneberries
barberries	14	4	623	2	b_arberries
bayberries	17	4	409	2	b_ayberries
bearberries	15	5	346	2	bearberries
blackberries	22	5	271	2	blackberries
bilberries	14	4	494	3	b_ilberries
blaeberry	16	4	264	3	blaeberr__y
boxberries	21	4	380	3	b_oxberries
cranberries	15	5	425	3	cranberries
elderberries	15	6	180	3	elderberries
hagberries	16	7	424	3	_hagberries
naseberries	13	5	268	3	naseberries
pokeberries	19	6	261	3	pokeberries
shadberries	17	5	272	3	shadberries
soapberries	15	5	275	3	soapberries
teaberries	12	4	512	3	tea_berries
waxberries	22	4	313	3	_waxberries
amberies	12	25	1468	4	__ambe_ries
babbitries	13	4	319	4	b_abbitries
bakeries	14	3	1219	4	b_a_ke_ries
barretries	12	4	624	4	b_arretries
basketries	16	4	504	4	b_asketries
batteries	11	6	1511	4	b_atte_ries
beaneries	11	3	1090	4	bea_ne_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
blabbered	13	18	459	4	blabbe_r_ed
blabbering	14	10	436	4	blabbe_ring
blabbers	11	30	815	4	blabbe_r__s
blazonries	21	5	312	4	bla_zonries
bloomeries	14	4	610	4	bloome_ries
bluebeards	15	4	229	4	bluebear_ds
blueberry	16	4	277	4	blueberr__y
bobberies	12	10	789	4	b_obbe_ries
boysenberries	20	6	112	4	boysenberries
brasseries	12	4	687	4	brasse_ries
braveries	14	3	910	4	bra_ve_ries
breweries	14	4	758	4	b_rewe_ries
briberies	13	4	833	4	b_ribe_ries
bunchberries	21	5	185	4	bunchberries
chokeberries	23	5	233	4	chokeberries
cloudberries	17	5	180	4	cloudberries
coralberries	16	5	314	4	coralberries
cowberries	17	4	462	4	_cowberries
crowberries	18	5	320	4	crowberries
dauberies	12	4	803	4	_daube_ries
deerberries	14	5	307	4	deerberries
dewberries	16	4	353	4	_dewberries
dogberries	14	4	386	4	_dogberries
flackeries	19	5	542	4	flacke_ries
flaneries	12	4	956	4	fla_ne_ries
flatteries	13	4	741	4	flatte_ries
glazieries	20	4	357	4	glazie_ries
gooseberries	15	6	205	4	gooseberries
hackberries	22	5	298	4	hackberries
inkberries	16	4	288	4	_inkberries
lambencies	16	4	380	4	_lambencies
liberties	11	4	920	4	_l_iberties
lingberries	14	5	282	4	lingberries
loganberries	15	5	177	4	loganberries
mulberries	14	4	407	4	_mulberries
plumberies	16	4	512	4	plumbe_ries
raspberries	15	5	269	4	raspberries
razzberries	21	13	206	4	razzberries
rowanberries	17	6	188	4	rowanberries
sheepberries	19	5	218	4	sheepberries
silverberries	18	6	138	4	silverberries
slaveries	12	4	968	4	sla_ve_ries
snowberries	16	5	283	4	snowberries
strawberries	17	5	204	4	strawberries
sugarberries	15	5	205	4	sugarberries
twinberries	16	5	298	4	twinberries
wolfberries	19	5	232	4	wolfberries

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.423	422437.4
2	DLD Change Limit	148819	78	8.890	16740.0
3	Display Results	78	78	0.046	1695.7
	(SQL Overall)	178691	78	9.359	19093.0