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

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

82 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
unsonsy	10	4	502	(None)
unsoncy	12	4	551	1	unsoncy
sonsy	8	64	1637	2	__sonsy
unions	6	42	1675	2	unions_
unisons	7	4	842	2	unisons_
unnoisy	10	4	424	2	unnoisy
unsonsie	8	4	452	2	unsonsie
anions	6	41	2303	3	anions_
anyons	9	45	1350	3	anyons_
arsons	6	39	1721	3	arsons_
bisons	8	39	1437	3	bisons_
bosons	8	50	1665	3	bosons_
bunions	9	22	1047	3	bunions_
donsy	9	64	1468	3	__donsy
hysons	12	3	763	3	hysons_
incony	11	3	907	3	incon_y
inions	6	44	1700	3	inions_
masonry	12	4	412	3	masonry
masons	8	39	1651	3	masons_
mesons	8	32	1584	3	mesons_
neons	5	58	1868	3	_neons_
noisy	8	68	1336	3	_n_oisy
noons	5	41	2528	3	_noons_
nosy	7	63	2289	3	_n_o_sy
onions	6	40	1643	3	onions_
oniony	9	36	970	3	onion_y
sonly	8	57	1805	3	__sonly
sonny	8	50	1610	3	__sonny
sons	4	60	4955	3	__sons_
udons	6	54	1146	3	u_dons_
unbans	8	19	1262	3	unbans_
unboned	10	30	1422	3	unboned
unbouncy	15	5	286	3	unbouncy
unbusy	11	3	521	3	un_busy
uncanny	12	4	511	3	uncanny
uncos	7	41	1703	3	unco_s_
uncoy	10	41	1141	3	unco__y
undoes	7	39	1740	3	undoes_
undone	7	9	1425	3	undon_e
uneasy	9	27	885	3	un_easy
unfancy	15	4	520	3	unfancy
unfond	10	14	911	3	unfon_d
unfunny	13	4	307	3	unfunny
unfussy	13	5	231	3	unfussy
ungodly	12	4	447	3	ungodly
unhandy	14	4	551	3	unhandy
unholy	12	3	816	3	unho_ly
unhorse	10	3	858	3	unhorse
unhouse	10	3	892	3	unhouse
union	5	45	1979	3	union__
unionise	8	4	785	3	unionise
unionism	10	4	701	3	unionism
unionist	8	4	1034	3	unionist
unison	6	4	903	3	unison__
unisonal	8	4	537	3	unisonal
unloose	7	9	786	3	unloose
unmanly	12	3	699	3	unmanly
unmans	8	22	1199	3	unmans_
unpens	8	25	1101	3	unpens_
unpins	8	23	1238	3	unpins_
unsay	8	32	1284	3	uns__ay
unsays	9	39	954	3	unsays_
unsent	6	38	2096	3	unsen_t
unsets	6	41	1616	3	unsets_
unsews	9	37	936	3	unsews_
unsexy	16	29	690	3	uns_exy
unshowy	16	4	417	3	unshowy
unsnag	7	3	639	3	uns_nag
unsnap	8	3	620	3	uns_nap
unsober	9	6	762	3	unsober
unsold	7	14	1051	3	unso_ld
unsolid	8	13	837	3	unsolid
unsound	8	15	843	3	unsound
unsoundly	13	4	328	3	unsoundly
unsowed	11	25	1105	3	unsowed
unsown	9	32	843	3	unso_wn
unstoned	9	3	1104	3	unstoned
unstops	9	3	698	3	unstops_
unsung	7	3	698	3	unsun_g
unsunk	10	3	633	3	unsun_k
unwon	8	45	1234	3	unwon__
unzoned	17	23	1065	3	unzoned

Search took 8 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.186	960704.3
2	DLD Change Limit	134027	82	7.376	18170.7
3	Display Results	82	82	0.033	2484.8
	(SQL Overall)	178691	82	7.595	23527.5