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

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

45 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
unfunny	13	4	307	(None)
funny	11	46	1483	2	__funny
uncanny	12	4	511	2	uncanny
unfancy	15	4	520	2	unfancy
unfussy	13	5	231	2	unfussy
bunny	10	47	1580	3	__bunny
fanny	11	48	1604	3	__fanny
fenny	11	51	1513	3	__fenny
finny	11	47	1675	3	__finny
funky	15	43	1513	3	__funky
gunny	9	44	1366	3	__gunny
infancy	15	4	617	3	infancy
nanny	8	48	1381	3	_n_anny
ninny	8	45	1493	3	_n_inny
punny	10	42	1771	3	__punny
runny	8	46	1348	3	__runny
sunny	8	49	1774	3	__sunny
tunny	8	65	1503	3	__tunny
unbouncy	15	5	286	3	unbouncy
unbulky	16	4	285	3	unbulky
unburnt	9	7	741	3	unburnt
unbusy	11	3	521	3	unbu_sy
unduly	10	3	782	3	undu_ly
unfence	12	3	919	3	unfence
unfitly	13	3	557	3	unfitly
unfond	10	14	911	3	unf_ond
unfound	11	12	739	3	unfound
unfunded	13	3	647	3	unfunded
unfurl	9	3	795	3	unfu_rl
unfurls	10	3	557	3	unfurls
unfused	11	31	951	3	unfused
unguent	8	3	912	3	unguent
unhandy	14	4	551	3	unhandy
unhung	10	3	528	3	unhu_ng
unlucky	16	4	322	3	unlucky
unmanly	12	3	699	3	unmanly
unruly	9	3	808	3	unru_ly
unsoncy	12	4	551	3	unsoncy
unsonsy	10	4	502	3	unsonsy
unsung	7	3	698	3	unsu_ng
unsunk	10	3	633	3	unsu_nk
untune	6	25	1160	3	untu_ne
untuned	8	20	1082	3	untuned
untunes	7	22	1125	3	untunes
untuning	9	3	794	3	untuning

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.393	454684.5
2	DLD Change Limit	134027	45	5.623	23835.5
3	Display Results	45	45	0.016	2812.5
	(SQL Overall)	178691	45	6.032	29623.8