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

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

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.

74 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
unfancy	15	4	520	(None)
infancy	15	4	617	1	infancy
fancy	13	46	1548	2	__fancy
nancy	10	52	1492	2	_n_ancy
uncanny	12	4	511	2	uncanny
unchancy	18	4	470	2	unchancy
unfence	12	3	919	2	unfence
unfunny	13	4	307	2	unfunny
unhandy	14	4	551	2	unhandy
unmanly	12	3	699	2	unmanly
unsoncy	12	4	551	2	unsoncy
buoyancy	18	4	267	3	buoyancy
chancy	16	40	1086	3	_chancy
enface	11	25	1035	3	enfa_ce
enhance	12	3	969	3	enhance
errancy	12	5	636	3	errancy
fanny	11	48	1604	3	__fanny
farcy	13	52	1709	3	__farcy
infamy	14	3	565	3	infa_my
infant	9	23	1513	3	infan_t
infanta	10	23	725	3	infanta
infante	10	19	1088	3	infante
infantry	14	4	385	3	infantry
infants	10	22	1077	3	infants
infarct	12	4	901	3	infarct
instancy	13	4	657	3	instancy
lunacy	11	3	684	3	lun_a_cy
nance	7	47	2184	3	_n_ance
nanny	8	48	1381	3	_n_anny
nuance	8	5	904	3	_nuance
pliancy	14	3	559	3	pliancy
pungency	16	4	409	3	pungency
tenancy	12	3	750	3	tenancy
truancy	12	4	499	3	truancy
unary	8	3	1599	3	un_a_ry
unban	7	21	1433	3	unban__
unbans	8	19	1262	3	unban_s
unbouncy	15	5	286	3	unbouncy
uncatchy	18	4	256	3	uncatchy
uneasy	9	27	885	3	unea_sy
unfaded	12	31	1173	3	unfaded
unfair	9	3	623	3	unfa_ir
unfairly	14	4	356	3	unfairly
unfaith	13	4	578	3	unfaith
unfaked	15	32	1117	3	unfaked
unfazed	20	29	905	3	unfazed
unfenced	14	3	773	3	unfenced
unfences	13	3	793	3	unfences
unfitly	13	3	557	3	unfitly
unflashy	17	4	186	3	unflashy
unfond	10	14	911	3	unfon_d
unfrock	16	7	463	3	unfrock
unfussy	13	5	231	3	unfussy
ungainly	12	4	442	3	ungainly
unhand	10	4	1038	3	unhan_d
unhands	11	3	777	3	unhands
unhang	10	3	844	3	unhan_g
unhangs	11	3	620	3	unhangs
unhappy	17	4	280	3	unhappy
unhasty	13	4	428	3	unhasty
uniface	12	3	695	3	unifa_ce
unlace	8	22	1517	3	unla_ce
unlatch	12	4	505	3	unlatch
unlay	8	46	1370	3	unla__y
unman	7	27	1542	3	unman__
unmans	8	22	1199	3	unman_s
unpack	14	5	783	3	unpa_ck
unsay	8	32	1284	3	unsa__y
unsonsy	10	4	502	3	unsonsy
untack	12	3	976	3	unta_ck
unwary	12	3	982	3	unwa_ry
urgency	13	4	566	3	urgency
usance	8	5	801	3	u_sance
vacancy	17	4	444	3	vacancy

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	134027	0.406	440125.6
2	DLD Change Limit	134027	74	5.733	23378.2
3	Display Results	74	74	0.033	2242.4
	(SQL Overall)	178691	74	6.172	28951.9