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

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

88 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
clacker	15	38	1377	(None)
blacker	15	45	1351	1	blacker
clacked	16	41	1360	1	clacked
clackers	16	39	1170	1	clackers
clicker	15	41	1188	1	clicker
clocker	15	39	1087	1	clocker
cracker	15	31	1417	1	cracker
lacker	12	53	2562	1	_lacker
slacker	13	39	1529	1	slacker
backer	14	45	2552	2	_backer
blacked	16	36	1337	2	blacked
blacken	15	43	979	2	blacken
blanker	13	46	1202	2	blanker
blocker	15	41	992	2	blocker
cackler	15	38	1257	2	c_ackler
calker	12	49	1708	2	c_alker
canker	12	44	2252	2	c_anker
checker	18	32	953	2	checker
clabber	13	42	1011	2	clabber
clack	13	47	2017	2	clack__
clacks	14	45	1634	2	clack_s
claimer	11	27	988	2	claimer
clamber	13	33	1174	2	clamber
clammer	13	42	1179	2	clammer
clamper	13	40	1299	2	clamper
clanger	10	41	1349	2	clanger
clanked	14	38	1225	2	clanked
clankier	14	32	708	2	clankier
clapper	13	40	1186	2	clapper
claquer	18	28	735	2	claquer
clasher	12	46	1551	2	clasher
clasper	11	38	1186	2	clasper
classer	9	36	1461	2	classer
clatter	9	40	1497	2	clatter
claver	11	38	1697	2	cla_ver
clavier	12	3	917	2	clavier
clawer	11	45	1278	2	cla_wer
clayier	12	4	832	2	clayier
clicked	16	41	1245	2	clicked
clickers	16	39	1020	2	clickers
clinker	13	38	1166	2	clinker
clocked	16	41	1283	2	clocked
clockers	16	36	981	2	clockers
clucked	16	38	1013	2	clucked
clunker	13	41	945	2	clunker
coacher	14	37	1412	2	coacher
cocker	14	43	2039	2	c_ocker
cracked	16	35	1474	2	cracked
crackers	16	41	1172	2	crackers
cranker	13	36	1278	2	cranker
dacker	13	49	2075	2	_dacker
flacked	17	37	1158	2	flacked
flackery	20	29	524	2	flackery
flaker	13	49	1617	2	fla_ker
flanker	14	39	1129	2	flanker
flicker	16	36	1062	2	flicker
glacier	10	39	1129	2	glacier
hacker	15	48	2269	2	_hacker
jacker	19	44	1758	2	_jacker
knacker	12	30	791	2	knacker
lacer	7	58	3375	2	_lac_er
lacier	8	40	2009	2	_lacier
lacked	13	53	2465	2	_lacked
lackers	13	41	2054	2	_lackers
lackey	15	48	1335	2	_lackey
laker	9	54	3287	2	_la_ker
lanker	10	41	2300	2	_lanker
larker	10	45	1924	2	_larker
licker	12	52	2204	2	_licker
locker	12	40	1942	2	_locker
packer	14	42	2340	2	_packer
placer	10	51	1774	2	plac_er
placket	15	4	1287	2	placket
plucker	15	36	824	2	plucker
racker	12	48	2455	2	_racker
sacker	12	51	2484	2	_sacker
slacked	14	38	1545	2	slacked
slacken	13	39	993	2	slacken
slackers	14	38	1274	2	slackers
slaker	10	42	1927	2	sla_ker
slicker	13	33	1453	2	slicker
smacker	15	34	1058	2	smacker
snacker	13	31	1260	2	snacker
stacker	13	44	1626	2	stacker
tacker	12	42	2450	2	_tacker
tracker	13	35	1517	2	tracker
wacker	15	49	2012	2	_wacker
whacker	19	36	850	2	whacker

Search took 4 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	107671	0.126	1418182.5
2	DLD Change Limit	107671	88	3.313	32499.5
3	Display Results	88	88	0.030	2933.3
	(SQL Overall)	178691	88	3.469	51510.8