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

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

60 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
unity	8	49	1849	(None)
unify	11	36	1111	1	unify
unit	4	51	4007	1	unit_
unite	5	48	2838	1	unite
units	5	49	2343	1	units
amity	10	4	1609	2	amity
aunty	8	59	1981	2	aun_ty
city	9	51	2262	2	_city
deity	9	43	1677	2	deity
dunite	7	3	1501	2	dunite
enmity	11	3	748	2	enmity
entity	9	3	1205	2	entity
gunite	7	4	1440	2	gunite
knit	8	57	2814	2	knit_
knits	9	39	1474	2	knits
laity	8	53	1890	2	laity
lenity	9	6	1271	2	lenity
linty	8	71	2656	2	linty
minty	10	63	2390	2	minty
mity	9	55	2821	2	_mity
nifty	11	52	1163	2	_nifty
nit	3	70	6594	2	_nit_
nite	4	59	4358	2	_nite
nits	4	57	4164	2	_nits
nitty	8	54	1831	2	_nitty
nixy	14	57	1451	2	_nixy
nudity	10	3	799	2	nudity
nutty	8	48	1687	2	nutty
pity	9	60	3193	2	_pity
punily	11	3	1177	2	punily
punty	10	60	2161	2	pun_ty
purity	11	41	1491	2	purity
runty	8	61	1904	2	run_ty
sanity	9	3	1620	2	sanity
snit	4	63	4247	2	snit_
snits	5	41	2483	2	snits
ubiety	11	3	591	2	ubiety
unary	8	3	1599	2	unary
uncoy	10	41	1141	2	uncoy
undy	8	50	1516	2	un_dy
unfit	8	45	1856	2	unfit_
unfitly	13	3	557	2	unfitly
unfits	9	39	1029	2	unfits
union	5	45	1979	2	union
unitary	10	3	861	2	unitary
united	7	44	2154	2	united
uniter	6	46	1914	2	uniter
unites	6	50	2485	2	unites
unlay	8	46	1370	2	unlay
unlit	5	50	2546	2	unlit_
unsay	8	32	1284	2	unsay
untidy	10	5	915	2	untidy
untie	5	44	2549	2	untie
until	5	35	1774	2	until
unto	4	58	2428	2	un_to
unwit	8	44	1752	2	unwit_
unwits	9	38	989	2	unwits
uppity	13	3	510	2	uppity
vanity	12	3	1193	2	vanity
whity	14	55	1347	2	whity

Search took 2 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	53800	0.093	1921408.6
2	DLD Change Limit	53800	60	1.453	37026.8
3	Display Results	60	60	0.013	4615.4
	(SQL Overall)	178691	60	1.559	114619.0