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

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

80 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
groceries	12	4	950	(None)
crockeries	18	5	711	2	crockeries
graperies	12	3	961	2	graperies
grocers	10	35	1125	2	grocer__s
groggeries	13	5	470	2	groggeries
rockeries	15	12	897	2	_rockeries
roperies	10	3	1576	2	_roperies
roseries	8	3	1731	2	_roseries
sorceries	11	4	993	2	sorceries
traceries	11	3	1285	2	traceries
archeries	14	4	1121	3	archeries
arteries	8	3	2146	3	ar_teries
booteries	11	3	1277	3	booteries
boweries	13	3	1229	3	_boweries
braveries	14	3	910	3	braveries
breweries	14	4	758	3	breweries
briberies	13	4	833	3	briberies
brogueries	13	4	481	3	brogueries
broideries	13	4	634	3	broideries
cookeries	15	12	1063	3	cookeries
cooperies	13	11	1331	3	cooperies
coteries	10	4	2270	3	_coteries
croceines	13	4	773	3	croceines
croceins	12	3	810	3	croce_ins
crookeries	16	4	613	3	crookeries
doweries	12	4	1193	3	_doweries
draperies	12	4	919	3	draperies
drolleries	11	4	544	3	drolleries
fooleries	12	4	874	3	fooleries
forgeries	13	3	1000	3	forgeries
galleries	10	3	1170	3	galleries
gaucheries	16	4	453	3	gaucheries
gauderies	11	4	774	3	gauderies
geodesies	11	4	459	3	geodesies
geometries	13	13	925	3	geometries
glories	8	19	1591	3	glo__ries
glycerides	17	4	410	3	glycerides
glycerines	16	4	445	3	glycerines
glycerins	15	4	455	3	glycerins
gomerils	11	4	679	3	g_omerils
gorgerins	11	4	519	3	gorgerins
gramaries	12	12	829	3	gramaries
gramercies	15	4	403	3	gramercies
granaries	10	15	988	3	granaries
greeneries	11	6	707	3	greeneries
greenies	9	3	1267	3	gr_eenies
grilleries	11	4	559	3	grilleries
grinderies	12	4	582	3	grinderies
grocer	9	42	1214	3	grocer___
grocery	13	33	676	3	grocer__y
gropers	10	48	1385	3	groper__s
groupies	11	3	752	3	gro_upies
growers	11	36	1272	3	grower__s
gruyeres	12	4	286	3	gruyer_es
gunneries	10	4	704	3	gunneries
merceries	13	4	1003	3	merceries
mockeries	17	12	825	3	_mockeries
moperies	12	3	1387	3	_moperies
orogenies	10	4	1053	3	orogenies
orreries	8	3	1012	3	or_reries
ozocerites	21	4	272	3	ozocerites
poperies	12	3	1679	3	_poperies
processes	13	3	1023	3	processes
procures	12	3	921	3	procur_es
progenies	12	3	1412	3	progenies
progerias	12	4	862	3	progerias
properties	14	14	1187	3	properties
pruderies	12	4	787	3	pruderies
reveries	11	25	1851	3	_reveries
robberies	13	10	739	3	_robberies
rocketries	16	4	589	3	_rocketries
rogueries	10	4	700	3	_rogueries
rookeries	13	13	817	3	rookeries
rosaries	8	3	1278	3	_rosaries
rotaries	8	3	1569	3	_rotaries
ruderies	9	3	1133	3	_ruderies
spiceries	13	4	931	3	spiceries
traceried	12	4	714	3	traceried
trickeries	16	4	714	3	trickeries
voleries	11	3	1323	3	_voleries

Search took 7 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.173	1032896.0
2	DLD Change Limit	148641	80	6.500	22867.8
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	6.703	26658.4