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

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

123 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
lockers	13	35	1692	(None)
blockers	16	39	879	1	blockers
clockers	16	36	981	1	clockers
cockers	15	36	1833	1	cockers
dockers	14	37	1500	1	dockers
hockers	16	39	1591	1	hockers
lackers	13	41	2054	1	lackers
lickers	13	41	1825	1	lickers
locker	12	40	1942	1	locker_
lockets	13	46	1220	1	lockets
lookers	11	40	1407	1	lookers
mockers	15	38	1294	1	mockers
ockers	12	38	1390	1	_ockers
rockers	13	39	1655	1	rockers
backers	15	38	2188	2	backers
bickers	15	43	1655	2	bickers
blocker	15	41	992	2	blocker_
bonkers	13	40	1530	2	bonkers
bookers	13	40	1661	2	bookers
buckers	15	35	1745	2	buckers
clackers	16	39	1170	2	clackers
clickers	16	39	1020	2	clickers
clocker	15	39	1087	2	clocker_
cocker	14	43	2039	2	cocker_
conkers	13	37	2104	2	conkers
cookers	13	46	1946	2	cookers
corkers	13	41	1885	2	corkers
dackers	14	34	1704	2	dackers
deckers	14	44	1383	2	deckers
dickers	14	41	1766	2	dickers
docker	13	44	1765	2	docker_
dockets	14	44	1224	2	dockets
duckers	14	32	1471	2	duckers
flickers	17	33	888	2	flickers
forkers	14	46	1578	2	forkers
fuckers	16	36	1159	2	fuckers
hackers	16	46	1904	2	hackers
hocker	15	51	1856	2	hocker_
hockeys	19	50	927	2	hockeys
honkers	14	33	1523	2	honkers
hookers	14	49	1651	2	hookers
ickers	12	39	1418	2	_ickers
jackers	20	42	1445	2	jackers
jockeys	23	36	595	2	jockeys
jokers	17	55	1119	2	jo_kers
kickers	12	40	1329	2	kickers
knockers	13	28	573	2	knockers
lacers	8	52	2525	2	lac_ers
lacker	12	53	2562	2	lacker_
lackeys	16	45	826	2	lackeys
lakers	10	52	2515	2	l_akers
larkers	11	30	1451	2	larkers
leakers	11	34	1542	2	leakers
lechers	12	33	1396	2	lechers
licker	12	52	2204	2	licker_
likers	10	46	2091	2	l_ikers
linkers	11	43	1771	2	linkers
loaders	8	34	1343	2	loaders
loafers	10	34	946	2	loafers
loaners	7	39	1362	2	loaners
lobbers	11	37	1394	2	lobbers
locaters	10	27	1007	2	locaters
locked	13	49	2166	2	locke_d
locket	12	39	2247	2	locke_t
locks	11	51	2692	2	lock__s
locksets	14	3	569	2	locksets
lockups	15	3	424	2	lockups
locoes	8	55	1658	2	locoe_s
lodgers	9	51	1383	2	lodgers
lofters	10	39	1290	2	lofters
loggers	9	46	1613	2	loggers
loiters	7	41	1661	2	loiters
lollers	7	27	1379	2	lollers
loners	6	42	2581	2	lo_ners
longers	8	48	1954	2	longers
looker	10	48	1695	2	looker_
loopers	9	39	1403	2	loopers
looters	7	44	1916	2	looters
lopers	8	44	2414	2	lo_pers
loppers	11	30	1410	2	loppers
losers	6	51	2358	2	lo_sers
lotters	7	39	2106	2	lotters
louvers	10	35	910	2	louvers
lovers	9	42	2343	2	lo_vers
lowers	9	46	2492	2	lo_wers
lunkers	11	34	1460	2	lunkers
lurkers	11	39	1008	2	lurkers
mocker	14	33	1544	2	mocker_
mockery	18	37	691	2	mockery
muckers	15	36	1280	2	muckers
neckers	13	42	1046	2	neckers
nickers	13	44	1509	2	nickers
ochers	11	39	1530	2	_ochers
ocker	11	39	1575	2	_ocker_
packers	15	38	1889	2	packers
peckers	15	33	1267	2	peckers
pickers	15	37	1809	2	pickers
pluckers	16	31	655	2	pluckers
pockets	15	46	1225	2	pockets
pokers	12	46	1792	2	po_kers
porkers	13	43	1493	2	porkers
puckers	15	35	1467	2	puckers
rackers	13	43	2045	2	rackers
rocker	12	43	1957	2	rocker_
rockery	16	43	925	2	rockery
rockets	13	46	1536	2	rockets
sackers	13	38	2022	2	sackers
shockers	17	31	946	2	shockers
slackers	14	38	1274	2	slackers
slickers	14	31	1255	2	slickers
soakers	11	41	1495	2	soakers
soccers	11	3	839	2	soccers
sockets	13	40	1298	2	sockets
stockers	14	34	1107	2	stockers
suckers	13	37	1762	2	suckers
tackers	13	43	1962	2	tackers
tickers	13	36	1772	2	tickers
tochers	12	34	1309	2	tochers
tokers	10	48	1889	2	to_kers
tuckers	13	40	1435	2	tuckers
wickers	16	41	1470	2	wickers
workers	14	46	1269	2	workers
yonkers	14	37	982	2	yonkers

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.376	475242.0
2	DLD Change Limit	107671	123	3.250	33129.5
3	Display Results	123	123	0.030	4100.0
	(SQL Overall)	178691	123	3.656	48876.1