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

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

154 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
lunker	10	47	1834	(None)
bunker	12	45	1937	1	bunker
clunker	13	41	945	1	clunker
dunker	11	36	1646	1	dunker
flunker	14	38	936	1	flunker
funker	13	39	1576	1	funker
hunker	13	39	1767	1	hunker
junker	17	42	1365	1	junker
lanker	10	41	2300	1	lanker
linker	10	43	2147	1	linker
lunger	7	57	2042	1	lunger
lunier	6	46	1760	1	lunier
lunkers	11	34	1460	1	lunkers
lurker	10	36	1329	1	lurker
plunker	13	39	1064	1	plunker
punker	12	37	1882	1	punker
banker	12	42	2273	2	banker
blanker	13	46	1202	2	blanker
blinker	13	41	1021	2	blinker
blunder	10	38	1314	2	blunder
blunger	10	41	1201	2	blunger
blunter	9	45	1203	2	blunter
bucker	14	54	2046	2	bucker
bunked	13	51	1837	2	bunked
bunkers	13	37	1595	2	bunkers
bunter	8	50	2038	2	bunter
burker	12	52	2117	2	burker
busker	12	55	1783	2	busker
canker	12	44	2252	2	canker
clinker	13	38	1166	2	clinker
clunked	14	43	957	2	clunked
clunkers	14	32	755	2	clunkers
clunkier	14	34	579	2	clunkier
conker	12	47	2155	2	conker
cunner	8	39	1500	2	cunner
danker	11	43	1966	2	danker
drunker	12	32	663	2	drunker
ducker	13	43	1799	2	ducker
duiker	11	41	1059	2	duiker
dunked	12	43	1528	2	dunked
dunkers	12	35	1219	2	dunkers
dunner	7	39	1382	2	dunner
flanker	14	39	1129	2	flanker
flunked	15	39	841	2	flunked
flunkers	15	34	753	2	flunkers
flunkey	17	40	579	2	flunkey
fucker	15	34	1442	2	fucker
funder	10	40	1608	2	funder
funked	14	42	1411	2	funked
funkers	14	37	1206	2	funkers
funkier	14	34	998	2	funkier
funner	9	34	1410	2	funner
gunkier	12	36	955	2	gunkier
gunner	7	38	1398	2	gunner
hanker	13	46	2209	2	hanker
honker	13	41	1746	2	honker
hunger	10	40	1520	2	hunger
hunkers	14	33	1433	2	hunkers
hunkey	16	42	1088	2	hunkey
hunkier	14	45	1214	2	hunkier
hunter	9	48	1777	2	hunter
husker	13	42	1270	2	husker
inker	9	44	2109	2	_inker
jinker	17	40	1354	2	jinker
junked	18	43	1169	2	junked
junkers	18	40	1086	2	junkers
junket	17	38	1502	2	junket
junkier	18	33	949	2	junkier
lacker	12	53	2562	2	lacker
laker	9	54	3287	2	l_aker
lancer	8	43	1997	2	lancer
lander	7	40	2848	2	lander
lankier	11	37	1163	2	lankier
lanner	6	49	2060	2	lanner
larker	10	45	1924	2	larker
launder	8	30	914	2	launder
leaker	10	46	2007	2	leaker
lender	7	39	2127	2	lender
licker	12	52	2204	2	licker
liker	9	56	2706	2	l_iker
liner	5	59	3892	2	lin_er
linger	7	52	2600	2	linger
linier	6	44	2379	2	linier
linked	11	45	1821	2	linked
linkers	11	43	1771	2	linkers
linter	6	46	2534	2	linter
locker	12	40	1942	2	locker
loner	5	54	3104	2	lon_er
longer	7	58	2320	2	longer
looker	10	48	1695	2	looker
lounger	8	46	1021	2	lounger
lubber	10	42	1462	2	lubber
lucked	13	51	1802	2	lucked
luckier	13	38	1153	2	luckier
luger	6	53	2208	2	lu_ger
lugger	8	39	1655	2	lugger
luller	6	34	1548	2	luller
lumber	10	38	1777	2	lumber
lumper	10	38	1665	2	lumper
lunar	5	70	1731	2	lun_ar
luncher	12	31	1141	2	luncher
lune	4	71	4049	2	lun_e_
lunes	5	53	3777	2	lun_es
lunet	5	68	3542	2	lun_et
lunge	6	53	2380	2	lunge_
lunged	8	54	1827	2	lunged
lungee	7	51	1981	2	lungee
lungers	8	38	1709	2	lungers
lunges	7	61	2342	2	lunges
lunies	6	47	2301	2	lunies
lunk	8	60	3072	2	lunk__
lunks	9	48	2245	2	lunk_s
lunted	7	45	1752	2	lunted
lurer	5	46	2531	2	lu_rer
lurked	11	45	1197	2	lurked
lurkers	11	39	1008	2	lurkers
lusher	9	38	1876	2	lusher
luster	6	40	2367	2	luster
mucker	14	38	1639	2	mucker
murker	12	37	1524	2	murker
pinker	12	53	2244	2	pinker
plinker	13	40	1096	2	plinker
plucker	15	36	824	2	plucker
plunder	10	38	1049	2	plunder
plunger	10	42	1123	2	plunger
plunked	14	42	959	2	plunked
plunkers	14	32	832	2	plunkers
plunkier	14	30	532	2	plunkier
pucker	14	38	1763	2	pucker
punier	8	45	1922	2	punier
punkers	13	37	1485	2	punkers
punkey	15	40	1117	2	punkey
punkier	13	35	1279	2	punkier
punner	8	49	1815	2	punner
punter	8	43	2002	2	punter
quaker	19	38	1162	2	quaker
ranker	10	50	2190	2	ranker
runner	6	38	1446	2	runner
sinker	10	36	2090	2	sinker
sucker	12	41	2066	2	sucker
sulker	10	40	1592	2	sulker
sunder	7	40	1982	2	sunder
sunken	10	35	1178	2	sunken
sunket	10	37	2136	2	sunket
tanker	10	45	2112	2	tanker
tinker	10	36	1992	2	tinker
tucker	12	43	1695	2	tucker
tuner	5	60	2268	2	tun_er
tusker	10	42	1219	2	tusker
under	6	46	2421	2	_under
wanker	13	42	1997	2	wanker
winker	13	42	2029	2	winker
yonker	13	41	1085	2	yonker
younker	14	31	645	2	younker

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.123	1452772.4
2	DLD Change Limit	82551	154	2.500	33020.4
3	Display Results	154	154	0.046	3347.8
	(SQL Overall)	178691	154	2.669	66950.5