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

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

87 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
slackers	14	38	1274	(None)
clackers	16	39	1170	1	clackers
lackers	13	41	2054	1	_lackers
sackers	13	38	2022	1	s_ackers
slackens	14	36	771	1	slackens
slacker	13	39	1529	1	slacker_
slakers	11	41	1575	1	sla_kers
slickers	14	31	1255	1	slickers
smackers	16	31	871	1	smackers
snackers	14	30	1022	1	snackers
stackers	14	34	1356	1	stackers
backers	15	38	2189	2	_backers
blackens	16	38	810	2	blackens
blacker	15	45	1351	2	blacker_
blockers	16	39	879	2	blockers
clacker	15	38	1377	2	clacker_
clickers	16	39	1020	2	clickers
clockers	16	36	981	2	clockers
crackers	16	41	1172	2	crackers
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
sacker	12	51	2484	2	s_acker_
sakers	10	41	2543	2	s_a_kers
shacklers	18	33	603	2	shacklers
shakers	14	40	1556	2	sha_kers
sharkers	15	40	1105	2	sharkers
shickers	17	30	1282	2	shickers
shockers	17	31	946	2	shockers
shuckers	17	38	813	2	shuckers
skankers	11	31	648	2	skankers
slabbers	12	36	1012	2	slabbers
slacked	14	38	1545	2	slacke_d
slacken	13	39	993	2	slacke_n
slackeners	16	4	342	2	slackeners
slackest	14	28	940	2	slackest
slackness	15	3	543	2	slackness
slacks	12	44	1653	2	slack__s
slaker	10	42	1927	2	sla_ker_
slakes	10	40	2188	2	sla_ke_s
slammers	12	35	1122	2	slammers
slanders	9	40	1402	2	slanders
slappers	12	37	1095	2	slappers
slashers	11	33	1361	2	slashers
slaters	7	31	2373	2	sla_ters
slathers	11	39	1478	2	slathers
slavers	10	37	1650	2	sla_vers
slayers	10	45	1332	2	sla_yers
sleekers	12	37	799	2	sleekers
slicers	9	41	1492	2	slic_ers
slickens	14	31	726	2	slickens
slicker	13	33	1453	2	slicker_
smacker	15	34	1058	2	smacker_
snacker	13	31	1260	2	snacker_
snickers	14	30	1096	2	snickers
soakers	11	41	1495	2	soa_kers
solacers	10	26	889	2	solac_ers
spacers	11	38	1387	2	spac_ers
spankers	14	36	986	2	spankers
sparkers	14	41	1131	2	sparkers
stacker	13	44	1626	2	stacker_
stalkers	12	36	985	2	stalkers
starkers	12	37	1239	2	starkers
stickers	14	29	1303	2	stickers
stockers	14	34	1107	2	stockers
suckers	13	37	1762	2	s_uckers
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.373	479064.3
2	DLD Change Limit	121059	87	3.940	30725.6
3	Display Results	87	87	0.030	2900.0
	(SQL Overall)	178691	87	4.343	41144.6