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

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

48 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
flitch	14	92	817	(None)
fitch	13	48	1687	1	f_itch
fletch	14	38	819	1	fletch
flinch	14	40	1010	1	flinch
glitch	12	28	635	1	glitch
aitch	10	52	1616	2	_aitch
bitch	12	50	1776	2	_bitch
blotch	13	19	714	2	blotch
clinch	13	39	1035	2	clinch
clutch	13	36	775	2	clutch
ditch	11	50	1509	2	_ditch
faith	11	56	2085	2	fait_h
fetch	13	49	1347	2	f_etch
fetich	14	7	969	2	fetich
filch	13	48	1332	2	f_ilch
filth	11	50	1582	2	filt_h
finch	13	54	1697	2	f_inch
fitchy	17	43	762	2	f_itchy
fleech	14	36	734	2	fleech
flench	14	40	1081	2	flench
flic	9	62	2373	2	fli_c_
flick	14	50	1721	2	fli_ck
flics	10	54	1836	2	fli_cs
flit	7	65	3927	2	flit__
flitched	17	25	629	2	flitched
flitches	16	38	846	2	flitches
flite	8	54	2496	2	flit_e
flited	10	46	1658	2	flited
flites	9	51	2244	2	flites
flits	8	56	2522	2	flit_s
flysch	17	3	289	2	flysch
frith	11	59	2203	2	frit_h
glitchy	16	28	308	2	glitchy
hitch	13	45	1547	2	_hitch
itch	9	56	1917	2	__itch
klatch	15	44	593	2	klatch
latch	10	46	2046	2	_latch
letch	10	52	1580	2	_letch
lich	9	62	3084	2	_li_ch
litchi	11	3	789	2	_litchi
pitch	12	50	1841	2	_pitch
quitch	20	3	641	2	quitch
slatch	11	45	1053	2	slatch
snitch	11	35	794	2	snitch
stitch	11	41	910	2	stitch
switch	14	45	891	2	switch
twitch	14	40	616	2	twitch
witch	13	45	1756	2	_witch

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.326	548131.9
2	DLD Change Limit	82551	48	2.673	30883.3
3	Display Results	48	48	0.016	3000.0
	(SQL Overall)	178691	48	3.015	59267.3