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

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

48 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
trickeries	16	4	715	(None)
crockeries	18	5	712	2	crockeries
rockeries	15	12	897	2	_rockeries
traceries	11	3	1286	2	trac_eries
trickers	14	38	1281	2	tricker__s
trinketries	15	35	432	2	trinketries
archeries	14	4	1122	3	ar_cheries
briberies	13	4	834	3	bri_beries
chickories	21	4	436	3	chickories
crookeries	16	4	614	3	crookeries
flackeries	19	5	543	3	flackeries
fripperies	17	4	359	3	fripperies
grilleries	11	4	559	3	grilleries
grinderies	12	4	585	3	grinderies
groceries	12	4	951	3	groc_eries
hickories	18	4	531	3	_hickories
knackeries	15	4	410	3	knackeries
mockeries	17	12	826	3	_mockeries
prickers	16	37	1067	3	pricker__s
priggeries	14	4	499	3	priggeries
printeries	12	4	1067	3	printeries
quackeries	25	4	432	3	quackeries
ricketier	15	13	458	3	_ricketier
ricketiest	16	4	396	3	_ricketiest
rifleries	12	4	769	3	_rifleries
rocketries	16	4	589	3	_rocketries
rookeries	13	13	817	3	_rookeries
spiceries	13	4	931	3	spic_eries
thieveries	16	4	347	3	thieveries
tickers	13	36	1772	3	t_icker__s
traceried	12	4	714	3	trac_eried
trackers	14	35	1285	3	tracker__s
treacheries	16	4	537	3	treacheries
tricepses	13	5	464	3	tric_epses
tricker	13	46	1552	3	tricker___
trickery	17	29	734	3	tricker__y
trickie	13	26	1103	3	trick__ie_
trickier	14	30	1023	3	trick__ier
trickiest	15	4	902	3	trick__iest
trickles	14	30	1376	3	trick__les
tricklier	15	25	682	3	trick_lier
trickliest	16	4	643	3	trick_liest
tricksier	15	27	524	3	trick_sier
tricksiest	16	4	435	3	trick_siest
tricornes	11	4	623	3	tric_ornes
triskeles	13	4	427	3	triske_les
truckers	14	27	901	3	trucker__s
trumperies	14	4	445	3	trumperies

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	140603	0.420	425454.8
2	DLD Change Limit	140603	48	6.986	20126.4
3	Display Results	48	48	0.013	3692.3
	(SQL Overall)	178691	48	7.419	24085.6