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

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

45 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
dogberry	15	4	286	(None)
boxberry	22	4	265	2	boxberry
cowberry	18	4	334	2	cowberry
dewberry	17	4	240	2	dewberry
doggery	13	44	826	2	dogge_ry
hagberry	17	4	290	2	hagberry
barberry	15	4	486	3	barberry
bayberry	18	4	296	3	bayberry
berry	10	45	2177	3	___berry
bilberry	15	4	328	3	bilberry
bobbery	13	43	835	3	bobbe_ry
crowberry	19	4	237	3	crowberry
daubery	13	39	621	3	daube_ry
deerberry	15	5	220	3	deerberry
derry	9	47	2137	3	d___erry
dobber	11	40	1542	3	dobbe_r_
dobbers	12	35	1325	3	dobbe_rs
doddery	13	51	685	3	dodde_ry
dodgery	13	62	778	3	dodge_ry
dogberries	14	4	386	3	dogberries
dogear	8	3	819	3	dog_ear_
dogears	9	3	751	3	dog_ears
dogey	10	57	1951	3	dog_e__y
doggedly	15	4	310	3	doggedly
dogger	9	52	1678	3	dogge_r_
doggerel	11	4	345	3	doggerel
doggers	10	44	1343	3	dogge_rs
dowery	13	43	1166	3	do_we_ry
inkberry	17	4	216	3	inkberry
jobbery	21	36	601	3	jobbe_ry
lingberry	15	4	231	3	lingberry
loganberry	16	5	128	3	loganberry
mulberry	15	4	256	3	mulberry
pokeberry	20	5	196	3	pokeberry
robbery	14	34	828	3	robbe_ry
roguery	11	3	489	3	rogue_ry
snowberry	17	4	250	3	snowberry
soapberry	16	4	201	3	soapberry
soberly	12	3	694	3	so_berly
somberly	15	4	405	3	somberly
teaberry	13	4	329	3	teaberry
toggery	12	50	592	3	togge_ry
waxberry	23	4	205	3	waxberry
wolfberry	20	5	167	3	wolfberry
youngberry	19	5	103	3	youngberry

Search took 9 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	146162	0.436	409841.7
2	DLD Change Limit	146162	45	7.813	18707.5
3	Display Results	45	45	0.016	2812.5
	(SQL Overall)	178691	45	8.265	21620.2