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

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

65 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
flitting	12	30	1088	(None)
fitting	11	35	1656	1	f_itting
flatting	12	35	1125	1	flatting
flinting	12	34	1234	1	flinting
flirting	12	31	901	1	flirting
fliting	11	35	1461	1	fli_ting
fritting	12	35	1070	1	fritting
slitting	9	30	1258	1	slitting
bitting	10	37	1729	2	_bitting
blatting	11	41	1165	2	blatting
blitzing	20	3	590	2	blitzing
blotting	11	39	1043	2	blotting
clotting	11	31	1064	2	clotting
emitting	11	24	1035	2	emitting
fainting	12	33	1216	2	fainting
faithing	15	3	715	2	faithing
fatting	11	38	1870	2	f_atting
feinting	12	34	1083	2	feinting
fetting	11	35	1787	2	f_etting
fileting	12	3	930	2	fileting
filiating	13	3	924	2	filiating
fisting	11	38	1812	2	f_isting
fittings	12	31	820	2	f_ittings
flatling	12	34	1001	2	flatling
fleeting	12	29	1032	2	fleeting
flicking	18	41	1004	2	flicking
flighting	17	3	610	2	flighting
flinging	13	33	1005	2	flinging
flipping	16	30	766	2	flipping
flitching	18	26	534	2	flitching
flittering	14	8	650	2	flittering
floating	12	31	1188	2	floating
flouting	12	26	1047	2	flouting
fluting	11	38	1509	2	fl_uting
flyting	14	37	855	2	fl_yting
foisting	12	29	1050	2	foisting
foliating	13	3	925	2	foliating
fretting	12	27	1152	2	fretting
gitting	9	32	1570	2	_gitting
glinting	10	32	1005	2	glinting
glitzing	19	3	497	2	glitzing
glutting	10	24	764	2	glutting
gritting	10	30	998	2	gritting
hitting	11	30	1727	2	_hitting
kitting	12	32	1444	2	_kitting
knitting	13	25	702	2	knitting
letting	8	32	1853	2	_letting
lifting	11	33	1327	2	_lifting
lilting	8	35	1538	2	_lilting
linting	8	38	2098	2	_linting
listing	8	40	2059	2	_listing
lotting	8	29	1775	2	_lotting
omitting	11	21	774	2	omitting
pitting	10	36	1887	2	_pitting
platting	11	48	1303	2	platting
plotting	11	30	1101	2	plotting
quitting	18	22	883	2	quitting
shitting	12	32	1266	2	shitting
sitting	8	35	1963	2	_sitting
slatting	9	40	1423	2	slatting
slotting	9	26	1261	2	slotting
spitting	11	30	1232	2	spitting
splitting	12	3	656	2	splitting
twitting	12	30	722	2	twitting
witting	11	34	1706	2	_witting

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	121059	0.390	458182.1
2	DLD Change Limit	121059	65	3.533	34265.2
3	Display Results	65	65	0.013	5000.0
	(SQL Overall)	178691	65	3.936	45399.1