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

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

75 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
piggeries	13	10	789	(None)
priggeries	14	4	499	1	priggeries
wiggeries	14	13	657	1	wiggeries
buggeries	13	4	708	2	buggeries
doggeries	12	4	667	2	doggeries
jaggeries	18	13	697	2	jaggeries
lingeries	10	5	1180	2	lingeries
piggies	11	38	1348	2	pigg__ies
pineries	10	24	1908	2	pi_neries
puggries	12	16	638	2	pugg_ries
toggeries	11	4	621	2	toggeries
waggeries	14	12	746	2	waggeries
beggaries	13	5	623	3	beggaries
bibberies	12	9	712	3	bibberies
biggies	11	38	1352	3	bigg__ies
bigotries	12	8	644	3	bigotries
binderies	12	3	1166	3	binderies
biogenies	12	4	851	3	biogenies
congeries	12	3	1640	3	congeries
diggers	10	44	1338	3	digger__s
dodgeries	12	4	659	3	dodgeries
fineries	11	24	1674	3	fi_neries
fisheries	15	4	864	3	fisheries
forgeries	13	3	1000	3	forgeries
gingelies	11	27	750	3	gingelies
groggeries	13	5	470	3	groggeries
imageries	12	4	678	3	imageries
jaggaries	18	13	574	3	jaggaries
jaggheries	22	4	242	3	jaggheries
jiggered	18	3	420	3	jigger_ed
jiggering	19	3	429	3	jiggering
jiggers	16	40	1017	3	jigger__s
juggleries	19	4	280	3	juggleries
lingerie	9	5	918	3	lingerie_
liveries	11	3	1437	3	li_veries
miseries	10	3	2040	3	mi_series
niggers	9	31	1131	3	nigger__s
niteries	8	3	1837	3	ni_teries
pedleries	12	9	878	3	pedleries
peeries	9	36	2302	3	p__eeries
pierces	11	34	1119	3	pi__erces
pieties	9	4	1922	3	pi__eties
piggery	14	26	618	3	pigger__y
piggie	10	32	1077	3	pigg__ie_
piggier	11	35	1000	3	pigg__ier
piggiest	12	25	966	3	pigg__iest
piggins	11	30	1047	3	pigg__ins
pigmies	12	26	1099	3	pi_g_mies
pigsties	11	3	978	3	pi_gsties
pilgrims	13	4	414	3	pilg_rims
pillories	11	8	955	3	pillories
pingers	10	40	2073	3	pinger__s
piperines	13	16	1067	3	pi_perines
piscaries	13	4	1006	3	piscaries
pizzerias	19	4	216	3	pizzerias
poperies	12	3	1679	3	p_operies
potteries	11	3	1359	3	potteries
printeries	12	4	1063	3	printeries
progenies	12	3	1412	3	progenies
progerias	12	4	862	3	progerias
pruderies	12	4	787	3	pruderies
pufferies	17	4	520	3	pufferies
puggarees	13	17	304	3	puggarees
puggrees	12	19	426	3	pugg_rees
rifleries	12	4	767	3	rifleries
riggers	9	36	1383	3	rigger__s
rogueries	10	4	700	3	rogueries
signories	10	10	785	3	signories
snuggeries	12	9	384	3	snuggeries
spiceries	13	4	931	3	spi_ceries
spinneries	12	4	573	3	spinneries
surgeries	10	3	1136	3	surgeries
thuggeries	15	4	337	3	thuggeries
vineries	11	27	1604	3	vi_neries
wineries	11	23	1653	3	wi_neries

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.170	1051123.5
2	DLD Change Limit	148641	75	6.766	21968.8
3	Display Results	75	75	0.030	2500.0
	(SQL Overall)	178691	75	6.966	25651.9