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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

184 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
knockers	13	28	573	(None)
knackers	13	28	684	1	knackers
knickers	13	30	672	1	knickers
knocker	12	29	639	1	knocker_
blockers	16	39	879	2	blockers
clockers	16	36	981	2	clockers
cockers	15	36	1833	2	_cockers
dockers	14	37	1500	2	_dockers
hockers	16	39	1591	2	_hockers
kickers	12	40	1329	2	k_ickers
knacker	12	30	791	2	knacker_
knackery	16	28	366	2	knackery
knocked	13	23	630	2	knocke_d
knockless	14	4	244	2	knockless
knocks	11	39	744	2	knock__s
knollers	12	25	514	2	knollers
knotters	12	27	615	2	knotters
knowers	14	3	635	2	kno_wers
knucklers	14	8	304	2	knucklers
lockers	13	35	1692	2	_lockers
mockers	15	38	1294	2	_mockers
neckers	13	42	1046	2	_neckers
nickers	13	44	1509	2	_nickers
ockers	12	38	1390	2	__ockers
rockers	13	39	1655	2	_rockers
shockers	17	31	946	2	shockers
snackers	14	30	1022	2	snackers
snickers	14	30	1096	2	snickers
snookers	12	39	865	2	snookers
stockers	14	34	1107	2	stockers
backers	15	38	2188	3	_backers
bickers	15	43	1655	3	_bickers
blocker	15	41	992	3	blocker_
bonkers	13	40	1530	3	_bonkers
bookers	13	40	1661	3	_bookers
brockets	16	32	812	3	brockets
brokers	13	31	1191	3	bro_kers
buckers	15	35	1745	3	_buckers
checkers	19	31	784	3	checkers
chokers	16	43	1152	3	cho_kers
clackers	16	39	1170	3	clackers
clickers	16	39	1020	3	clickers
clocker	15	39	1087	3	clocker_
cocker	14	43	2039	3	_cocker_
conkers	13	37	2104	3	_conkers
cookers	13	46	1946	3	_cookers
corkers	13	41	1885	3	_corkers
crackers	16	41	1172	3	crackers
croakers	14	28	852	3	croakers
crockery	19	35	660	3	crockery
crockets	16	33	954	3	crockets
dackers	14	34	1704	3	_dackers
deckers	14	44	1383	3	_deckers
dickers	14	41	1766	3	_dickers
docker	13	44	1765	3	_docker_
dockets	14	44	1224	3	_dockets
duckers	14	32	1471	3	_duckers
encoders	11	3	751	3	encoders
evokers	14	38	679	3	evo_kers
flickers	17	33	888	3	flickers
forkers	14	46	1578	3	_forkers
fuckers	16	36	1159	3	_fuckers
grocers	10	35	1125	3	groc_ers
hackers	16	46	1904	3	_hackers
havockers	21	4	212	3	havockers
hocker	15	51	1856	3	_hocker_
hockeys	19	50	927	3	_hockeys
honkers	14	33	1523	3	_honkers
hookers	14	49	1651	3	_hookers
ickers	12	39	1418	3	__ickers
inchers	12	39	1252	3	in_chers
incomers	12	6	859	3	incomers
inkers	10	40	1883	3	in__kers
invokers	15	3	467	3	invokers
jackers	20	42	1445	3	_jackers
jockeys	23	36	595	3	_jockeys
jokers	17	55	1119	3	_jo_kers
kayakers	14	6	361	3	kayakers
kicker	11	41	1618	3	k_icker_
knacked	13	28	779	3	knacke_d
knackered	15	4	368	3	knackered
knackeries	15	4	410	3	knackeries
knacks	11	42	854	3	knack__s
knappers	16	31	564	3	knappers
kneaders	13	8	471	3	kneaders
kneelers	12	22	621	3	kneelers
knifers	14	53	708	3	kn_ifers
knitters	12	33	662	3	knitters
knock	10	48	796	3	knock___
knocking	14	24	594	3	knocking
knockoff	19	5	142	3	knockoff
knockoffs	20	5	100	3	knockoffs
knockout	13	4	389	3	knockout
knockouts	14	4	194	3	knockouts
knockwurst	18	5	95	3	knockwurst
knoller	11	28	591	3	knoller_
knotless	12	6	457	3	knotless
knotter	11	31	764	3	knotter_
knower	13	3	708	3	kno_wer_
knuckler	13	8	362	3	knuckler_
knuckles	13	8	445	3	knuckles
koshers	14	48	1180	3	k_oshers
lackers	13	41	2054	3	_lackers
lickers	13	41	1825	3	_lickers
locker	12	40	1942	3	_locker_
lockets	13	46	1220	3	_lockets
lookers	11	40	1407	3	_lookers
mocker	14	33	1544	3	_mocker_
mockery	18	37	691	3	_mockery
monickers	17	4	508	3	monickers
monikers	14	3	741	3	monikers
moochers	15	36	912	3	moochers
muckers	15	36	1280	3	_muckers
necker	12	40	1279	3	_necker_
nickels	13	33	865	3	_nickels
nicker	12	38	1870	3	_nicker_
nocked	13	46	1738	3	_nocke_d
nocks	11	51	2101	3	_nock__s
nodders	9	44	1026	3	_nodders
noosers	7	49	1392	3	_noosers
noshers	10	36	1433	3	_noshers
notchers	13	27	942	3	_notchers
noters	6	40	2100	3	_no_ters
ochers	11	39	1530	3	__ochers
ocker	11	39	1575	3	__ocker_
onlookers	13	4	310	3	onlookers
packers	15	38	1889	3	_packers
peckers	15	33	1267	3	_peckers
pickers	15	37	1809	3	_pickers
pluckers	16	31	655	3	pluckers
pockets	15	46	1225	3	_pockets
pokers	12	46	1792	3	_po_kers
porkers	13	43	1493	3	_porkers
prickers	16	37	1067	3	prickers
puckers	15	35	1467	3	_puckers
rackers	13	43	2045	3	_rackers
rocker	12	43	1957	3	_rocker_
rockery	16	43	925	3	_rockery
rockets	13	46	1536	3	_rockets
sackers	13	38	2022	3	_sackers
shickers	17	30	1282	3	shickers
shocker	16	34	1143	3	shocker_
shuckers	17	38	813	3	shuckers
slackers	14	38	1274	3	slackers
slickers	14	31	1255	3	slickers
smackers	16	31	871	3	smackers
smokers	13	38	932	3	smo_kers
snacker	13	31	1260	3	snacker_
sneakers	12	30	864	3	sneakers
snicker	13	30	1267	3	snicker_
snickery	17	29	554	3	snickery
snooker	11	39	1030	3	snooker_
snoopers	10	31	984	3	snoopers
snoozers	17	29	694	3	snoozers
snorers	7	43	1380	3	sno_rers
snorkels	12	3	441	3	snorkels
snorters	8	34	1058	3	snorters
soakers	11	41	1495	3	_soakers
soccers	11	3	839	3	_soccers
sockets	13	40	1298	3	_sockets
stackers	14	34	1356	3	stackers
stickers	14	29	1303	3	stickers
stocker	13	37	1308	3	stocker_
stokers	11	45	1518	3	sto_kers
stookers	12	44	979	3	stookers
suckers	13	37	1762	3	_suckers
tackers	13	43	1962	3	_tackers
tickers	13	36	1772	3	_tickers
tochers	12	34	1309	3	_tochers
tokers	10	48	1889	3	_to_kers
trackers	14	35	1285	3	trackers
trickers	14	38	1281	3	trickers
truckers	14	27	901	3	truckers
tuckers	13	40	1435	3	_tuckers
uncovers	13	3	657	3	uncovers
unmakers	14	25	665	3	unmakers
unpackers	17	20	381	3	unpackers
unpuckers	17	24	312	3	unpuckers
whackers	20	32	654	3	whackers
whickers	20	29	798	3	whickers
wickers	16	41	1470	3	_wickers
workers	14	46	1269	3	_workers
wreckers	17	31	597	3	wreckers
yonkers	14	37	982	3	_yonkers

Search took 7 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	146162	0.423	422437.4
2	DLD Change Limit	146162	184	6.296	23215.1
3	Display Results	184	184	0.076	2421.1
	(SQL Overall)	178691	184	6.795	26297.4