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

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

70 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
rifleries	12	4	768	(None)
grilleries	11	4	559	2	grilleries
railleries	10	4	664	2	railleries
riflers	10	35	1219	2	rifler__s
artilleries	11	8	454	3	artilleries
bibberies	12	9	713	3	bibberies
binderies	12	3	1168	3	binderies
briberies	13	4	833	3	bri_beries
butleries	11	7	1007	3	butleries
celeries	10	3	1631	3	_celeries
cutleries	11	7	921	3	cutleries
cycleries	16	4	703	3	cycleries
diableries	13	4	460	3	diableries
drolleries	11	4	544	3	drolleries
faeries	10	41	1899	3	__faeries
fineries	11	24	1674	3	fi_neries
fisheries	15	4	864	3	fisheries
fooleries	12	4	874	3	fooleries
fripperies	17	4	358	3	fripperies
fulleries	12	4	872	3	fulleries
galleries	10	3	1171	3	galleries
grinderies	12	4	583	3	grinderies
helleries	12	26	1168	3	helleries
lingeries	10	5	1181	3	lingeries
liveries	11	3	1437	3	li_veries
millerites	12	4	793	3	millerites
miseries	10	3	2040	3	mi_series
niteries	8	3	1838	3	ni_teries
pedleries	12	9	878	3	pedleries
piggeries	13	10	789	3	piggeries
pillories	11	8	957	3	pillories
pineries	10	24	1908	3	pi_neries
priggeries	14	4	499	3	priggeries
printeries	12	4	1063	3	printeries
pufferies	17	4	520	3	pufferies
referees	11	13	1041	3	ref_erees
refineries	13	4	706	3	refineries
reflexes	18	6	593	3	refle_xes
reflexives	23	4	236	3	reflexives
reflies	10	44	1853	3	refl__ies
refries	10	44	1973	3	ref__ries
replevies	14	6	549	3	replevies
revelries	12	4	692	3	revelries
reveries	11	25	1851	3	r_everies
ribaldries	13	5	231	3	ribaldries
rifflers	14	33	644	3	riffler__s
riflebird	15	5	153	3	riflebird
riflebirds	16	5	133	3	riflebirds
riflemen	13	4	424	3	rifle_men
rifler	9	40	1426	3	rifler___
riflery	13	34	580	3	rifler__y
rifles	9	42	1770	3	rifl___es
riflips	12	3	416	3	rifl__ips
rillettes	9	4	653	3	rillettes
rivalries	12	4	500	3	rivalries
rivieres	11	3	601	3	rivier_es
robberies	13	10	739	3	robberies
rockeries	15	12	897	3	rockeries
rogueries	10	4	700	3	rogueries
rookeries	13	13	817	3	rookeries
roperies	10	3	1576	3	r_operies
roseries	8	3	1731	3	r_oseries
ruderies	9	3	1133	3	r_uderies
sealeries	9	3	1313	3	sealeries
trickeries	16	4	714	3	trickeries
triflers	11	31	1021	3	trifler__s
vineries	11	27	1604	3	vi_neries
voleries	11	3	1323	3	_voleries
wiggeries	14	13	657	3	wiggeries
wineries	11	23	1653	3	wi_neries

Search took 8 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	148641	0.420	425454.8
2	DLD Change Limit	148641	70	7.080	20994.5
3	Display Results	70	70	0.030	2333.3
	(SQL Overall)	178691	70	7.530	23730.5