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

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

76 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
quack	20	38	1250	(None)
quacks	21	47	1010	1	quacks
quacky	24	37	696	1	quacky
quark	18	46	1412	1	quark
quick	20	43	1106	1	quick
aback	13	48	1617	2	aback
alack	11	48	2006	2	alack
back	12	55	3576	2	_back
black	13	47	1907	2	black
buck	12	51	2990	2	bu_ck
clack	13	47	2017	2	clack
crack	13	41	2053	2	crack
duck	11	59	2917	2	du_ck
flack	14	45	1941	2	flack
fuck	13	49	2463	2	fu_ck
guaco	8	50	1216	2	guaco
guck	11	49	2253	2	gu_ck
hack	13	51	3454	2	_hack
huck	13	59	2763	2	hu_ck
jack	17	52	2486	2	_jack
knack	10	43	1104	2	knack
kyack	13	46	826	2	kyack
lack	10	58	3768	2	_lack
luck	10	53	2982	2	lu_ck
mack	12	57	3364	2	_mack
muck	12	57	2785	2	mu_ck
pack	12	55	3544	2	_pack
plack	13	50	1784	2	plack
puck	12	49	2794	2	pu_ck
qua	12	48	2197	2	qua__
quacked	23	3	679	2	quacked
quad	14	46	1870	2	qua_d
quads	15	45	1584	2	quads
quaff	20	13	1135	2	quaff
quag	14	48	1594	2	qua_g
quags	15	46	1325	2	quags
quai	13	44	2039	2	qua_i
quaich	20	4	769	2	quaich
quail	14	43	1436	2	quail
quais	14	46	1839	2	quais
quake	18	41	1464	2	quake
quaky	21	43	1074	2	quaky
quale	14	36	1785	2	quale
qualm	16	35	1118	2	qualm
quant	14	36	2481	2	quant
quare	14	39	2054	2	quare
quarks	19	38	1091	2	quarks
quart	14	40	2785	2	quart
quash	17	45	1216	2	quash
quasi	14	40	1502	2	quasi
quass	14	44	1376	2	quass
quate	14	45	2141	2	quate
quay	16	46	1835	2	qua_y
quays	17	46	1204	2	quays
quicks	21	38	930	2	quicks
quirk	18	40	1100	2	quirk
rack	10	62	3488	2	_rack
ruck	10	47	2833	2	ru_ck
sack	10	53	3731	2	_sack
shack	14	53	2175	2	shack
slack	11	50	2176	2	slack
smack	13	46	1545	2	smack
snack	11	47	1806	2	snack
squark	19	43	811	2	squark
squawk	22	38	537	2	squawk
stack	11	44	2169	2	stack
suck	10	61	3173	2	su_ck
tack	10	65	3629	2	_tack
thack	14	49	1517	2	thack
track	11	48	2301	2	track
tuck	10	46	2657	2	tu_ck
wack	13	53	3091	2	_wack
whack	17	48	1302	2	whack
wrack	14	54	1388	2	wrack
yack	13	54	2597	2	_yack
yuck	13	64	2353	2	yu_ck

Search took 2 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	53800	0.093	1921408.6
2	DLD Change Limit	53800	76	1.813	29674.6
3	Display Results	76	76	0.016	4750.0
	(SQL Overall)	178691	76	1.922	92971.4