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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

80 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
funkier	14	34	998	(None)
funker	13	39	1576	1	funk_er
funnier	10	32	1017	1	funnier
gunkier	12	36	955	1	gunkier
hunkier	14	45	1214	1	hunkier
junkier	18	33	949	1	junkier
punkier	13	35	1279	1	punkier
bulkier	13	41	1151	2	bulkier
bunker	12	45	1937	2	bunk_er
chunkier	17	39	588	2	chunkier
clunkier	14	34	579	2	clunkier
dinkier	12	34	1150	2	dinkier
duckier	14	39	1179	2	duckier
dungier	9	36	858	2	dungier
dunker	11	36	1646	2	dunk_er
duskier	12	40	943	2	duskier
fancier	12	34	1206	2	fancier
fennier	10	33	925	2	fennier
finnier	10	31	995	2	finnier
flakier	14	39	1020	2	flakier
flukier	14	39	785	2	flukier
flunker	14	38	936	2	flunk_er
flunkie	14	3	451	2	flunkie_
flunkies	15	3	639	2	flunkies
folkier	14	35	904	2	folkier
forkier	14	43	1159	2	forkier
fubsier	12	36	776	2	fubsier
fucker	15	34	1442	2	fuck_er
fuggier	12	34	896	2	fuggier
fumier	11	3	1090	2	fu_mier
funder	10	40	1608	2	fun_der
funked	14	42	1411	2	funk_ed
funkers	14	37	1206	2	funk_ers
funkia	13	3	634	2	funki_a
funkias	14	3	538	2	funkias
funkiest	15	28	1097	2	funkiest
funkily	17	3	651	2	funkily
funking	15	40	1302	2	funking
funner	9	34	1410	2	fun_ner
funnies	10	41	1360	2	funnies
furrier	10	35	1366	2	furrier
furzier	19	31	810	2	furzier
fussier	10	36	1067	2	fussier
fustier	10	42	1393	2	fustier
fuzzier	18	25	652	2	fuzzier
hinkier	14	36	1079	2	hinkier
hulkier	14	32	897	2	hulkier
hunker	13	39	1767	2	hunk_er
hunkie	13	38	1238	2	hunkie_
hunkies	14	32	1450	2	hunkies
huskier	14	36	976	2	huskier
inkier	10	40	1378	2	_inkier
junker	17	42	1365	2	junk_er
junkie	17	33	960	2	junkie_
junkies	18	37	1169	2	junkies
kinkier	10	31	943	2	kinkier
lankier	11	37	1163	2	lankier
luckier	13	38	1153	2	luckier
lunier	6	46	1760	2	lun_ier
lunker	10	47	1834	2	lunk_er
muckier	15	34	1148	2	muckier
murkier	13	31	1027	2	murkier
muskier	13	43	1273	2	muskier
plunkier	14	30	532	2	plunkier
punier	8	45	1922	2	pun_ier
punker	12	37	1882	2	punk_er
punkie	12	35	1361	2	punkie_
punkies	13	42	1680	2	punkies
punnier	9	35	1126	2	punnier
quakier	20	23	920	2	quakier
runnier	7	40	1011	2	runnier
runtier	7	35	1285	2	runtier
skunkier	11	17	428	2	skunkier
spunkier	14	23	582	2	spunkier
suckier	13	36	1397	2	suckier
sulkier	11	38	1196	2	sulkier
sunnier	7	34	1215	2	sunnier
wonkier	14	3	742	2	wonkier
yuckier	16	35	853	2	yuckier
yukkier	13	26	389	2	yukkier

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.373	479064.3
2	DLD Change Limit	107671	80	3.266	32967.2
3	Display Results	80	80	0.030	2666.7
	(SQL Overall)	178691	80	3.669	48702.9