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

Here are the results of your fuzzy-string dictionary search for “flinted” 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
flinted	11	44	1189	(None)
fainted	11	42	1172	1	fainted
feinted	11	37	962	1	feinted
flirted	11	42	867	1	flirted
flited	10	46	1658	1	fli_ted
flitted	11	40	1164	1	flitted
glinted	9	39	937	1	glinted
linted	7	40	2182	1	_linted
alined	7	52	2140	2	alin_ed
blinded	11	48	1002	2	blinded
blinked	14	40	1001	2	blinked
blunted	10	42	1066	2	blunted
clinged	11	33	1009	2	clinged
clinked	14	40	1164	2	clinked
dinted	8	44	1984	2	_dinted
fainter	10	36	1105	2	fainter
fileted	11	5	909	2	fileted
filiated	12	6	1008	2	filiated
fined	9	49	3050	2	f_in_ed
finked	14	42	1462	2	f_inked
finned	10	41	1460	2	f_inned
fisted	10	42	1870	2	f_isted
fitted	10	47	1666	2	f_itted
flanged	12	38	1084	2	flanged
flanked	15	37	1064	2	flanked
flatted	11	40	1294	2	flatted
flaunted	12	3	460	2	flaunted
fleeted	11	33	1023	2	fleeted
flensed	11	3	661	2	flensed
flicked	17	46	1067	2	flicked
flied	9	65	1943	2	fli__ed
flighted	16	4	697	2	flighted
flinched	17	31	670	2	flinched
flinder	11	31	987	2	flinder
flinger	11	37	1051	2	flinger
flint	8	73	3350	2	flint__
flinthead	16	4	230	2	flinthead
flintier	11	3	639	2	flintier
flints	9	56	1745	2	flint_s
flinty	12	61	1249	2	flint_y
flipped	15	35	851	2	flipped
flirter	10	31	867	2	flirter
flite	8	54	2496	2	fli_te_
flites	9	51	2244	2	fli_tes
flitter	10	34	1390	2	flitter
floated	11	33	1270	2	floated
flouted	11	32	1081	2	flouted
flunked	15	39	841	2	flunked
fluted	10	49	1716	2	fl_uted
flyted	13	37	877	2	fl_yted
foined	10	59	1501	2	foin_ed
foisted	11	32	1060	2	foisted
foliated	12	4	991	2	foliated
fringed	12	36	1152	2	fringed
fritted	11	36	1133	2	fritted
fronted	11	40	1127	2	fronted
hinted	10	43	1832	2	_hinted
jointed	15	37	850	2	jointed
lifted	10	44	1352	2	_lifted
lilted	7	37	1537	2	_lilted
lined	6	49	3464	2	_lin_ed
linked	11	45	1821	2	_linked
lintel	6	40	1399	2	_lintel
linter	6	46	2534	2	_linter
listed	7	43	2283	2	_listed
lunted	7	45	1752	2	_lunted
minted	9	42	2058	2	_minted
painted	10	42	1463	2	painted
planted	10	35	1612	2	planted
plinked	14	39	1089	2	plinked
pointed	10	38	1398	2	pointed
printed	10	40	1637	2	printed
sainted	8	41	1424	2	sainted
slanted	8	35	1474	2	slanted
slinked	12	30	1138	2	slinked
slitted	8	35	1331	2	slitted
splinted	11	36	925	2	splinted
stinted	8	29	1419	2	stinted
tainted	8	35	1242	2	tainted
tinted	7	44	1953	2	_tinted

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.203	33615.7
3	Display Results	80	80	0.033	2424.2
	(SQL Overall)	178691	80	3.609	49512.6