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

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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
Check this box to automatically increase the Change Limit after seconds.

96 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
wha	9	64	2207	1	wha_
wham	12	53	2169	1	wham
whap	12	51	1964	1	whap
what	10	54	3407	1	what
aha	6	112	4664	2	aha_
chad	10	55	2550	2	chad
chai	9	59	2990	2	chai
cham	11	55	3231	2	cham
chao	9	57	2731	2	chao
chap	11	49	2849	2	chap
char	9	51	3215	2	char
chat	9	55	4613	2	chat
chaw	12	62	2463	2	chaw
chay	12	49	2487	2	chay
dhak	12	55	1203	2	dhak
dhal	8	67	1928	2	dhal
ghat	8	64	3528	2	ghat
ha	5	102	5994	2	_ha_
had	7	76	5876	2	_had
hae	6	73	6400	2	_hae
hag	7	72	5574	2	_hag
hah	9	106	5522	2	_hah
haj	13	81	4060	2	_haj
ham	8	63	6328	2	_ham
hao	6	72	5112	2	_hao
hap	8	73	6005	2	_hap
has	6	73	7265	2	_has
hat	6	72	8996	2	_hat
haw	9	71	5327	2	_haw
hay	9	73	5877	2	_hay
hwan	10	57	1689	2	hwan
khaf	14	53	1960	2	khaf
khan	11	58	1914	2	khan
khat	11	67	3072	2	khat
phat	9	58	3786	2	phat
sha	6	98	3778	2	sha_
shad	8	62	3091	2	shad
shag	8	64	3056	2	shag
shah	10	56	2778	2	shah
sham	9	64	3636	2	sham
shat	7	64	5660	2	shat
shaw	10	81	3255	2	shaw
shay	10	71	3334	2	shay
thae	7	68	2556	2	thae
than	7	61	2877	2	than
that	7	56	3932	2	that
thaw	10	75	2131	2	thaw
wab	8	70	5183	2	w_ab
wad	7	70	5389	2	w_ad
wae	6	75	5695	2	w_ae
wag	7	64	5175	2	w_ag
wan	6	67	6194	2	w_an
wap	8	65	5337	2	w_ap
war	6	72	6242	2	w_ar
was	6	87	6756	2	w_as
wat	6	73	7892	2	w_at
waw	9	70	4638	2	w_aw
wax	13	70	4118	2	w_ax
way	9	67	5766	2	w_ay
weak	11	71	2630	2	weak
weal	7	58	3868	2	weal
wean	7	57	3435	2	wean
wear	7	58	3672	2	wear
whack	17	48	1302	2	whack
whale	11	55	1743	2	whale
whamo	13	55	1126	2	whamo
whams	13	55	1564	2	whams
whang	12	48	1338	2	whang
whaps	13	51	1516	2	whaps
wharf	14	3	1582	2	wharf
whats	11	77	1899	2	whats
whaup	13	45	888	2	whaup
wheal	11	57	1618	2	wheal
wheat	11	49	2457	2	wheat
whee	10	54	2959	2	whee
when	10	57	2304	2	when
whet	10	51	3378	2	whet
whew	13	76	1878	2	whew
whey	13	50	1871	2	whey
whid	11	54	1887	2	whid
whig	11	55	1642	2	whig
whim	12	62	2053	2	whim
whin	10	52	2569	2	whin
whip	12	55	2184	2	whip
whir	10	55	1928	2	whir
whit	10	48	3417	2	whit
whiz	19	59	1994	2	whiz
who	9	55	2677	2	wh_o
whoa	10	66	1520	2	whoa
whom	12	70	1818	2	whom
whop	12	55	2092	2	whop
whup	12	57	1416	2	whup
why	12	69	2001	2	wh_y
whys	13	70	1166	2	whys
woad	8	55	2394	2	woad
wrap	9	68	2197	2	wrap

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	29872	0.280	638182.1
2	DLD Change Limit	29872	96	0.733	40753.1
3	Display Results	96	96	0.016	6000.0
	(SQL Overall)	178691	96	1.029	173655.0