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

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

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.

67 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
unflattering	16	7	204	(None)
flattering	14	9	874	2	__flattering
uncluttering	15	5	180	2	uncluttering
unfaltering	15	4	326	2	unf_altering
unfettering	15	4	370	2	unf_ettering
unflatteringly	21	6	115	2	unflatteringly
blattering	13	10	871	3	__blattering
clattering	13	10	923	3	__clattering
enfettering	15	4	323	3	enf_ettering
flattening	14	11	510	3	__flattening
flittering	14	8	650	3	__flittering
fluttering	14	10	629	3	__fluttering
nattering	10	22	1221	3	_n__attering
splattering	14	5	454	3	_splattering
unfastening	15	7	278	3	unf_astening
antilittering	14	6	213	4	antilittering
battering	12	27	1514	4	___battering
bespattering	17	5	234	4	bespattering
betattering	14	4	414	4	_betattering
blathering	16	10	758	4	__blathering
chattering	16	10	864	4	__chattering
cluttering	13	10	683	4	__cluttering
faltering	13	22	1111	4	__f_altering
fathering	16	10	1009	4	__f_athering
fattening	13	28	783	4	__f_attening
feathering	17	10	879	4	__feathering
fettering	13	23	1051	4	__f_ettering
flatteries	13	4	741	4	__flatteries
flatteringly	19	5	256	4	__flatteringly
flatting	12	35	1125	4	__flatt__ing
flustering	14	10	593	4	__flustering
frittering	14	10	562	4	__frittering
glittering	12	9	600	4	__glittering
inflating	13	3	1044	4	infla_t__ing
ingathering	16	10	301	4	in_gathering
lathering	13	9	1225	4	___lathering
lettering	10	21	1207	4	___lettering
littering	10	24	1198	4	___littering
mattering	12	23	1405	4	___mattering
nonfattening	16	6	186	4	nonf_attening
outglittering	15	5	103	4	outglittering
pattering	12	23	1442	4	___pattering
plastering	13	3	924	4	__plastering
relettering	12	5	551	4	_relettering
replastering	15	5	341	4	replastering
scattering	13	9	801	4	__scattering
shattering	14	9	828	4	__shattering
slathering	14	10	828	4	__slathering
smattering	13	9	758	4	__smattering
spattering	13	10	779	4	__spattering
spluttering	14	6	336	4	_spluttering
squattering	21	4	380	4	_squattering
tattering	10	22	1232	4	___tattering
unfalteringly	20	6	179	4	unf_alteringly
unfearing	13	3	888	4	unfea___ring
unfitting	13	3	642	4	unf_itt__ing
unflagging	16	4	297	4	unfla__gging
unhatting	13	3	587	4	un_hatt__ing
unlatching	16	4	315	4	un_la_tching
unlimbering	16	5	248	4	un_limbering
unmitering	13	4	500	4	un__mitering
unplaiting	13	4	550	4	unplait__ing
untethering	15	4	368	4	un_tethering
unwavering	17	4	322	4	un_wa_vering
upgathering	18	4	220	4	u_pgathering
uttering	9	16	1308	4	u____ttering
yattering	13	24	1044	4	___yattering

Search took 7 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	124790	0.156	1145455.1
2	DLD Change Limit	124790	67	6.766	18443.7
3	Display Results	67	67	0.046	1456.5
	(SQL Overall)	178691	67	6.968	25644.5