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

Here are the results of your fuzzy-string dictionary search for “trickers” with Change Limit: [1] [2] [3]

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.

71 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
trickers	14	38	1281	(None)
prickers	16	37	1067	1	prickers
tickers	13	36	1772	1	t_ickers
trackers	14	35	1285	1	trackers
tricker	13	46	1552	1	tricker_
trickery	17	29	734	1	trickery
truckers	14	27	901	1	truckers
bickers	15	43	1655	2	_bickers
clickers	16	39	1020	2	clickers
crackers	16	41	1172	2	crackers
crickets	16	41	812	2	crickets
dickers	14	41	1766	2	_dickers
drinkers	13	27	782	2	drinkers
flickers	17	33	888	2	flickers
friskers	15	33	737	2	friskers
ickers	12	39	1418	2	__ickers
kickers	12	40	1329	2	_kickers
knickers	13	30	672	2	knickers
lickers	13	41	1825	2	_lickers
nickers	13	44	1509	2	_nickers
pickers	15	37	1809	2	_pickers
pricers	11	39	1506	2	pric_ers
pricker	15	40	1341	2	pricker_
prickets	16	32	908	2	prickets
prinkers	14	30	1038	2	prinkers
rackers	13	43	2045	2	_rackers
ricers	8	41	2099	2	_ric_ers
rickets	13	49	1509	2	_rickets
rickeys	16	54	898	2	_rickeys
riskers	11	40	1199	2	_riskers
rockers	13	39	1655	2	_rockers
shickers	17	30	1282	2	shickers
slickers	14	31	1255	2	slickers
snickers	14	30	1096	2	snickers
stickers	14	29	1303	2	stickers
strikers	12	36	1129	2	stri_kers
tackers	13	43	1962	2	t_ackers
thickens	17	26	641	2	thickens
thicker	16	36	1102	2	thicker_
thickets	17	28	708	2	thickets
thinkers	15	30	870	2	thinkers
ticker	12	43	2150	2	t_icker_
tickets	13	41	1368	2	t_ickets
ticklers	14	33	930	2	t_icklers
tinkers	11	35	1714	2	t_inkers
tracers	9	49	1784	2	trac_ers
tracker	13	35	1517	2	tracker_
trekkers	11	3	380	2	trekkers
triceps	11	26	734	2	tric_eps
trices	8	48	2633	2	tric_e_s
tricked	14	40	1616	2	tricke_d
trickeries	16	4	714	2	trickeries
trickier	14	30	1023	2	trickier_
trickles	14	30	1376	2	trickles
tricks	12	53	1901	2	trick__s
tricksters	16	26	476	2	tricksters
triers	6	43	2152	2	tri__ers
triflers	11	31	1021	2	triflers
triggers	10	25	784	2	triggers
trikes	10	54	1949	2	tri_ke_s
trillers	8	36	1349	2	trillers
trimers	9	46	1514	2	tri_mers
trimmers	12	28	891	2	trimmers
trinkets	12	3	714	2	trinkets
trippers	12	32	1016	2	trippers
trucker	13	40	1073	2	trucker_
trucklers	15	29	558	2	trucklers
tuckers	13	40	1435	2	t_uckers
whickers	20	29	798	2	whickers
wickers	16	41	1470	2	_wickers
wreckers	17	31	597	2	wreckers

Search took 5 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	121059	0.390	458182.1
2	DLD Change Limit	121059	71	3.656	33112.4
3	Display Results	71	71	0.030	2366.7
	(SQL Overall)	178691	71	4.076	43839.8