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

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

73 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
twinberries	16	5	298	(None)
bilberries	14	4	495	3	_bilberries
chinaberries	19	5	247	3	chinaberries
cranberries	15	5	425	3	cranberries
inkberries	16	4	288	3	__inkberries
lingberries	14	5	282	3	_lingberries
rowanberries	17	6	188	3	rowanberries
teaberries	12	4	513	3	t_eaberries
trinketries	15	35	432	3	trinketries
twinberry	17	4	190	3	twinberr__y
waxberries	22	4	314	3	_waxberries
wineries	11	23	1653	3	_win_e_ries
baneberries	15	5	340	4	baneberries
barberries	14	4	624	4	_barberries
bayberries	17	4	410	4	_bayberries
bearberries	15	5	347	4	bearberries
berries	9	44	2355	4	____berries
bibberies	12	9	713	4	_bibbe_ries
binderies	12	3	1169	4	_binde_ries
blaeberries	15	7	331	4	blaeberries
blueberries	15	8	309	4	blueberries
boxberries	21	4	380	4	_boxberries
briberies	13	4	834	4	bri_be_ries
cowberries	17	4	462	4	_cowberries
crowberries	18	5	321	4	crowberries
deerberries	14	5	308	4	deerberries
dewberries	16	4	354	4	_dewberries
dogberries	14	4	386	4	_dogberries
fineries	11	24	1675	4	_fin_e_ries
grinderies	12	4	585	4	grinde_ries
hackberries	22	5	299	4	hackberries
hagberries	16	7	425	4	_hagberries
interties	9	3	2034	4	__interties
itineraries	11	5	333	4	itin_eraries
joineries	16	4	810	4	join_e_ries
liberties	11	4	921	4	_li_berties
lingeries	10	5	1181	4	_linge_ries
loganberries	15	5	177	4	loganberries
mulberries	14	4	408	4	_mulberries
naseberries	13	5	269	4	naseberries
pineries	10	24	1908	4	_pin_e_ries
pokeberries	19	6	262	4	pokeberries
printeries	12	4	1067	4	printe_ries
raspberries	15	5	269	4	raspberries
razzberries	21	13	206	4	razzberries
shadberries	17	5	273	4	shadberries
shinneries	13	4	572	4	shinne_ries
snowberries	16	5	283	4	snowberries
soapberries	15	5	276	4	soapberries
spinneries	12	4	573	4	spinne_ries
strawberries	17	5	204	4	strawberries
swanneries	13	4	436	4	swanne_ries
tanneries	9	3	1042	4	t_anne_ries
terries	7	34	2563	4	t____erries
thieveries	16	4	347	4	thieve_ries
tilburies	11	4	434	4	t_ilb_uries
timberlines	15	8	328	4	t_imberlines
toiletries	10	4	661	4	toi_letries
trickeries	16	4	715	4	tricke_ries
turneries	9	4	849	4	turn_e_ries
twiners	10	45	963	4	twin_e_r__s
twinkies	15	3	598	4	twin___kies
vineries	11	27	1604	4	_vin_e_ries
wherries	14	17	903	4	_w__herries
wiggeries	14	13	657	4	_wigge_ries
winterberries	18	9	201	4	_win~~ter~~berries
winterier	12	3	834	4	_winte_rier
winteriest	13	4	881	4	_winte_riest
winterizes	22	4	714	4	_winterizes
wintertides	15	4	447	4	_wintertides
wintertimes	16	4	391	4	_wintertimes
wolfberries	19	5	233	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.423	422437.4
2	DLD Change Limit	148819	73	8.936	16653.9
3	Display Results	73	73	0.033	2212.1
	(SQL Overall)	178691	73	9.392	19025.9