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

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

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

171 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
cocker	14	43	2039	(None)
clocker	15	39	1087	1	clocker
cocked	15	50	2256	1	cocked
cockers	15	36	1833	1	cockers
cockier	15	40	1362	1	cockier
conker	12	47	2155	1	conker
cooker	12	47	2245	1	cooker
corker	12	47	2085	1	corker
docker	13	44	1765	1	docker
hocker	15	51	1856	1	hocker
locker	12	40	1942	1	locker
mocker	14	33	1544	1	mocker
ocker	11	39	1575	1	_ocker
rocker	12	43	1957	1	rocker
backer	14	45	2552	2	backer
bicker	14	48	1917	2	bicker
blocker	15	41	992	2	blocker
booker	12	47	1919	2	booker
bosker	12	38	1365	2	bosker
bucker	14	54	2046	2	bucker
cackler	15	38	1257	2	cackler
calker	12	49	1708	2	calker
canker	12	44	2252	2	canker
checker	18	32	953	2	checker
chocked	19	44	1161	2	chocked
choker	15	43	1437	2	choker
clacker	15	38	1377	2	clacker
clicker	15	41	1188	2	clicker
clocked	16	41	1283	2	clocked
clockers	16	36	981	2	clockers
coacher	14	37	1411	2	coacher
coaler	8	41	2170	2	coaler
coater	8	43	2955	2	coater
coaxer	15	39	1278	2	coaxer
cobber	12	41	1684	2	cobber
cock	12	63	3290	2	cock__
cockered	17	7	1021	2	cockered
cockerel	16	10	711	2	cockerel
cockeye	18	6	722	2	cockeye
cockle	14	39	1357	2	cockle
cockled	16	37	1082	2	cockled
cockles	15	34	1464	2	cockles
cockney	18	3	587	2	cockney
cocks	13	52	2716	2	cock_s
cockup	16	3	571	2	cockup
cocky	16	42	1593	2	cock_y
codder	10	44	1633	2	codder
coder	8	61	3421	2	co_der
codger	10	58	1484	2	codger
coffer	14	41	1286	2	coffer
coiler	8	44	2159	2	coiler
coiner	8	43	2378	2	coiner
coke	10	70	3838	2	co_ke_
coked	12	47	3069	2	co_ked
cokes	11	55	3719	2	co_kes
colder	9	51	2183	2	colder
colter	8	46	2509	2	colter
comaker	15	34	1060	2	comaker
comber	12	51	1850	2	comber
comer	9	58	3269	2	co_mer
confer	11	40	1868	2	confer
conger	9	50	2427	2	conger
conked	13	50	1911	2	conked
conkers	13	37	2104	2	conkers
conner	8	44	2396	2	conner
cooer	7	48	3101	2	co_oer
cooked	13	59	2136	2	cooked
cookers	13	46	1946	2	cookers
cookery	16	42	1039	2	cookery
cookey	15	54	1433	2	cookey
cooler	8	48	2471	2	cooler
cooper	10	42	2112	2	cooper
cooter	8	51	2861	2	cooter
coper	9	53	3609	2	co_per
copier	10	37	2289	2	copier
copper	12	43	2189	2	copper
copter	10	98	2201	2	copter
corder	9	43	2287	2	corder
corer	7	55	3887	2	co_rer
corked	13	50	2078	2	corked
corkers	13	41	1885	2	corkers
corkier	13	31	1430	2	corkier
corner	8	46	2562	2	corner
cosher	11	48	1990	2	cosher
cosier	8	44	2375	2	cosier
coster	8	43	3129	2	coster
cotter	8	49	2667	2	cotter
coucher	14	45	1585	2	coucher
couter	8	49	3020	2	couter
cover	10	54	3077	2	co_ver
cower	10	45	3177	2	co_wer
cowier	11	36	1616	2	cowier
coyer	10	52	2284	2	co_yer
cozier	17	33	1514	2	cozier
cracker	15	31	1417	2	cracker
croaker	13	30	1068	2	croaker
crocked	16	40	1443	2	crocked
crockery	19	35	660	2	crockery
crocket	15	46	1567	2	crocket
crooker	13	41	1109	2	crooker
cycler	13	3	591	2	cycler
dacker	13	49	2075	2	dacker
decker	13	52	1599	2	decker
dicker	13	45	2140	2	dicker
docked	14	50	1833	2	docked
dockers	14	37	1500	2	dockers
docket	13	47	2117	2	docket
ducker	13	43	1799	2	ducker
forker	13	47	1790	2	forker
fucker	15	34	1442	2	fucker
hacker	15	48	2269	2	hacker
hocked	16	55	2130	2	hocked
hockers	16	39	1591	2	hockers
hockey	18	48	1315	2	hockey
honker	13	41	1746	2	honker
hooker	13	48	2017	2	hooker
icker	11	40	1844	2	_icker
jacker	19	44	1758	2	jacker
jockey	22	40	803	2	jockey
joker	16	57	1589	2	jo_ker
kicker	11	41	1618	2	kicker
knocker	12	29	639	2	knocker
lacker	12	53	2562	2	lacker
licker	12	52	2204	2	licker
locked	13	49	2166	2	locked
lockers	13	35	1692	2	lockers
locket	12	39	2247	2	locket
looker	10	48	1695	2	looker
mocked	15	47	1661	2	mocked
mockers	15	38	1294	2	mockers
mockery	18	37	691	2	mockery
mucker	14	38	1639	2	mucker
necker	12	40	1279	2	necker
nicker	12	38	1870	2	nicker
nocked	13	46	1738	2	nocked
ocher	10	45	1610	2	_ocher
ockers	12	38	1390	2	_ockers
packer	14	42	2340	2	packer
pecker	14	46	1536	2	pecker
picker	14	44	2217	2	picker
pocked	15	48	1898	2	pocked
pocket	14	46	2262	2	pocket
pockier	15	39	1160	2	pockier
poker	11	51	2288	2	po_ker
porker	12	49	1754	2	porker
pucker	14	38	1763	2	pucker
racker	12	48	2455	2	racker
rocked	13	50	2232	2	rocked
rockers	13	39	1655	2	rockers
rockery	16	43	925	2	rockery
rocket	12	54	2528	2	rocket
rockier	13	49	1188	2	rockier
sacker	12	51	2484	2	sacker
shocker	16	34	1142	2	shocker
sicker	12	40	2390	2	sicker
soaker	10	57	1753	2	soaker
soccer	10	3	854	2	soccer
socked	13	47	2150	2	socked
socket	12	39	2352	2	socket
stocker	13	37	1308	2	stocker
sucker	12	41	2066	2	sucker
tacker	12	42	2450	2	tacker
ticker	12	43	2150	2	ticker
tocher	11	40	1491	2	tocher
toker	9	59	2491	2	to_ker
tucker	12	43	1695	2	tucker
wacker	15	49	2012	2	wacker
wicker	15	45	1867	2	wicker
worker	13	47	1511	2	worker
yocked	16	41	1442	2	yocked
yonker	13	41	1085	2	yonker

Search took 3 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	82551	0.126	1418182.5
2	DLD Change Limit	82551	171	2.483	33246.5
3	Display Results	171	171	0.046	3717.4
	(SQL Overall)	178691	171	2.655	67303.6