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

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

61 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
pokeberries	19	6	261	(None)
chokeberries	23	5	233	2	chokeberries
baneberries	15	5	339	3	baneberries
blaeberries	15	7	329	3	blaeberries
blueberries	15	8	308	3	blueberries
boxberries	21	4	380	3	bo_xberries
cowberries	17	4	462	3	co_wberries
dogberries	14	4	386	3	do_gberries
gooseberries	15	6	205	3	gooseberries
inkberries	16	4	288	3	ink_berries
naseberries	13	5	268	3	naseberries
pokeberry	20	5	196	3	pokeberr__y
soapberries	15	5	275	3	soapberries
wolfberries	19	5	232	3	wolfberries
barberries	14	4	623	4	_barberries
bayberries	17	4	409	4	_bayberries
bearberries	15	5	346	4	bearberries
berries	9	44	2355	4	____berries
bilberries	14	4	494	4	_bilberries
bobberies	12	10	789	4	bo_bbe_ries
boysenberries	20	6	112	4	boysenberries
chokecherries	27	6	114	4	chokecherries
cloudberries	17	5	180	4	cloudberries
coralberries	16	5	314	4	coralberries
cranberries	15	5	425	4	cranberries
crowberries	18	5	320	4	crowberries
deerberries	14	5	307	4	deerberries
dewberries	16	4	353	4	_dewberries
elderberries	15	6	180	4	elderberries
farkleberries	22	6	124	4	farkleberries
hackberries	22	5	298	4	hackberries
hagberries	16	7	424	4	_hagberries
huckleberries	24	6	118	4	huckleberries
jobberies	20	11	542	4	jo_bbe_ries
kerries	11	33	1791	4	__k__erries
lingberries	14	5	282	4	lingberries
loganberries	15	5	177	4	loganberries
mulberries	14	4	407	4	_mulberries
papeteries	14	4	655	4	papete_ries
peeries	9	36	2302	4	p__e_e_ries
perries	9	32	2660	4	p____erries
pikeperches	24	5	70	4	pikeperches
plumberies	16	4	512	4	plumbe_ries
poetries	10	3	1558	4	po___etries
poperies	12	3	1679	4	po__pe_ries
potbellies	14	4	339	4	po_tbellies
potteries	11	3	1359	4	po_tte_ries
poverties	14	3	951	4	po__verties
puberties	13	4	660	4	p__uberties
raspberries	15	5	269	4	raspberries
razzberries	21	13	206	4	razzberries
robberies	13	10	739	4	ro_bbe_ries
rowanberries	17	6	188	4	rowanberries
shadberries	17	5	272	4	shadberries
sheepberries	19	5	218	4	sheepberries
skerries	12	16	867	4	_sk__erries
snowberries	16	5	283	4	snowberries
teaberries	12	4	512	4	_teaberries
twinberries	16	5	298	4	twinberries
waxberries	22	4	313	4	_waxberries
youngberries	18	5	152	4	youngberries

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	148819	0.486	367677.0
2	DLD Change Limit	148819	61	8.186	18179.7
3	Display Results	61	61	0.033	1848.5
	(SQL Overall)	178691	61	8.705	20527.4