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

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

167 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
bunker	12	45	1937	(None)
banker	12	42	2273	1	banker
bucker	14	54	2046	1	bucker
bunked	13	51	1837	1	bunked
bunkers	13	37	1595	1	bunkers
bunter	8	50	2038	1	bunter
burker	12	52	2117	1	burker
busker	12	55	1783	1	busker
dunker	11	36	1646	1	dunker
funker	13	39	1576	1	funker
hunker	13	39	1767	1	hunker
junker	17	42	1365	1	junker
lunker	10	47	1834	1	lunker
punker	12	37	1882	1	punker
backer	14	45	2552	2	backer
baker	11	56	2954	2	b_aker
balker	12	45	1916	2	balker
bander	9	39	2822	2	bander
banger	9	44	2363	2	banger
banked	13	50	2144	2	banked
bankers	13	39	1909	2	bankers
banner	8	44	2150	2	banner
banter	8	48	2533	2	banter
barker	12	48	2286	2	barker
beaker	12	55	2069	2	beaker
bender	9	52	2330	2	bender
bicker	14	48	1917	2	bicker
biker	11	60	2256	2	b_iker
bilker	12	49	1344	2	bilker
binder	9	44	2287	2	binder
biner	7	59	3069	2	bin_er
binger	9	49	2345	2	binger
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
bonder	9	53	2478	2	bonder
boner	7	51	3308	2	bon_er
bonier	8	43	2199	2	bonier
bonked	13	55	1731	2	bonked
bonkers	13	40	1530	2	bonkers
bonzer	17	53	1367	2	bonzer
booker	12	47	1919	2	booker
bosker	12	38	1365	2	bosker
bouncer	11	38	1133	2	bouncer
bounder	10	42	1553	2	bounder
broker	12	43	1424	2	broker
brusker	13	43	785	2	brusker
bubkes	14	46	1262	2	bubkes
bucked	15	51	2106	2	bucked
buckers	15	35	1745	2	buckers
bucket	14	46	2073	2	bucket
buckler	15	41	1203	2	buckler
budder	10	43	1481	2	budder
budger	10	46	1770	2	budger
buffer	14	45	1268	2	buffer
bugger	10	44	1872	2	bugger
bugler	9	47	1772	2	bugler
bulger	9	49	1735	2	bulger
bulked	13	42	1674	2	bulked
bulkier	13	41	1151	2	bulkier
bummer	12	40	1410	2	bummer
bumper	12	37	1434	2	bumper
bundler	10	40	1172	2	bundler
bunged	10	52	1879	2	bunged
bungee	9	63	1977	2	bungee
bungler	10	46	1148	2	bungler
bunk	10	57	3135	2	bunk__
bunkered	15	17	718	2	bunkered
bunko	11	55	1451	2	bunk_o
bunkoed	14	35	666	2	bunkoed
bunkos	12	42	1032	2	bunkos
bunks	11	51	2508	2	bunk_s
bunkum	14	3	598	2	bunkum
bunted	9	52	1918	2	bunted
bunters	9	47	1712	2	bunters
bupkes	14	48	1148	2	bupkes
burger	9	40	2079	2	burger
burier	8	43	2465	2	burier
burke	11	51	2276	2	burke_
burked	13	52	2088	2	burked
burkers	13	37	1662	2	burkers
burkes	12	44	2131	2	burkes
burler	8	47	2383	2	burler
burner	8	38	1920	2	burner
burrer	8	37	1847	2	burrer
busher	11	49	2220	2	busher
busier	8	52	1972	2	busier
busked	13	49	1770	2	busked
buskers	13	34	1409	2	buskers
buster	8	47	2649	2	buster
butler	8	42	2003	2	butler
butter	8	47	2423	2	butter
buyer	10	50	1309	2	bu_yer
buzzer	16	37	911	2	buzzer
canker	12	44	2252	2	canker
clunker	13	41	945	2	clunker
conker	12	47	2155	2	conker
cunner	8	39	1500	2	cunner
danker	11	43	1966	2	danker
debunker	15	4	309	2	debunker
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
flunker	14	38	936	2	flunker
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
lanker	10	41	2300	2	lanker
linker	10	43	2147	2	linker
lunger	7	57	2042	2	lunger
lunier	6	46	1760	2	lunier
lunkers	11	34	1460	2	lunkers
lurker	10	36	1329	2	lurker
mucker	14	38	1639	2	mucker
murker	12	37	1524	2	murker
pinker	12	53	2244	2	pinker
plunker	13	39	1064	2	plunker
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 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	82551	0.143	1249587.4
2	DLD Change Limit	82551	167	2.936	28116.8
3	Display Results	167	167	0.063	2650.8
	(SQL Overall)	178691	167	3.142	56871.7