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

Here are the results of your fuzzy-string dictionary search for “clackers” 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
clackers	16	39	1170	(None)
clacker	15	38	1377	1	clacker_
clickers	16	39	1020	1	clickers
clockers	16	36	981	1	clockers
crackers	16	41	1172	1	crackers
lackers	13	41	2054	1	_lackers
slackers	14	38	1274	1	slackers
backers	15	38	2189	2	_backers
blackens	16	38	810	2	blackens
blacker	15	45	1351	2	blacker_
blockers	16	39	879	2	blockers
cacklers	16	37	1070	2	c_acklers
calkers	13	44	1469	2	c_alkers
cankers	13	44	1875	2	c_ankers
checkers	19	31	784	2	checkers
clabbers	14	35	990	2	clabbers
clacked	16	41	1360	2	clacke_d
clacks	14	45	1634	2	clack__s
claimers	12	29	874	2	claimers
clambers	14	42	1129	2	clambers
clammers	14	35	1069	2	clammers
clampers	14	32	1189	2	clampers
clangers	11	43	1234	2	clangers
clappers	14	33	1083	2	clappers
claquers	19	22	620	2	claquers
clashers	13	42	1399	2	clashers
claspers	12	44	1091	2	claspers
classers	10	41	1183	2	classers
clatters	10	33	1391	2	clatters
clavers	12	43	1490	2	cla_vers
claviers	13	6	710	2	claviers
clawers	12	39	1097	2	cla_wers
clicker	15	41	1188	2	clicker_
clinkers	14	33	983	2	clinkers
clocker	15	39	1087	2	clocker_
clunkers	14	32	756	2	clunkers
coachers	15	43	1230	2	coachers
cockers	15	36	1833	2	c_ockers
cracker	15	31	1417	2	cracker_
dackers	14	34	1704	2	_dackers
flackery	20	29	524	2	flackery
flakers	14	36	1327	2	fla_kers
flankers	15	34	930	2	flankers
flickers	17	33	888	2	flickers
glaciers	11	27	790	2	glaciers
hackers	16	46	1904	2	_hackers
jackers	20	42	1445	2	_jackers
knackers	13	28	684	2	knackers
lacers	8	52	2525	2	_lac_ers
lacker	12	53	2562	2	_lacker_
lackeys	16	45	826	2	_lackeys
lakers	10	52	2515	2	_la_kers
larkers	11	30	1451	2	_larkers
lickers	13	41	1825	2	_lickers
lockers	13	35	1692	2	_lockers
packers	15	38	1889	2	_packers
placers	11	45	1526	2	plac_ers
plackets	16	4	658	2	plackets
pluckers	16	31	656	2	pluckers
rackers	13	43	2045	2	_rackers
sackers	13	38	2022	2	_sackers
slackens	14	36	771	2	slackens
slacker	13	39	1529	2	slacker_
slakers	11	41	1575	2	sla_kers
slickers	14	31	1255	2	slickers
smackers	16	31	871	2	smackers
snackers	14	30	1022	2	snackers
stackers	14	34	1356	2	stackers
tackers	13	43	1962	2	_tackers
trackers	14	35	1285	2	trackers
whackers	20	32	654	2	whackers

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.846	31476.6
3	Display Results	71	71	0.030	2366.7
	(SQL Overall)	178691	71	4.266	41887.2