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

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

70 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
suffari	13	4	550	(None)
suffaris	14	4	508	1	suffaris
safari	9	11	1022	2	s_afari
suffer	12	43	1451	2	suffer_
suffers	13	31	1354	2	suffers
affair	12	3	435	3	_affair
buffalo	15	5	372	3	buffalo
buffer	14	45	1268	3	buffer_
buffers	15	33	1079	3	buffers
buffi	13	61	1220	3	buff__i
curari	8	44	1440	3	cu_rari
duffer	13	47	1166	3	duffer_
duffers	14	34	1009	3	duffers
funfair	13	4	203	3	funfair
guffaw	16	4	279	3	guffa_w
guffaws	17	6	227	3	guffaws
luffa	11	40	902	3	luffa__
luffas	12	33	748	3	luffa_s
ourari	6	34	1354	3	ou_rari
puffer	14	46	1073	3	puffer_
puffers	15	34	920	3	puffers
puffery	18	23	511	3	puffery
safaris	10	11	1066	3	s_afaris
sari	4	54	4404	3	s___ari
scuffer	15	32	888	3	scuffer_
scuffers	16	30	749	3	scuffers
shikari	14	4	451	3	shikari
shofar	12	3	631	3	shofar_
shofars	13	3	583	3	shofars
snuffer	13	31	885	3	snuffer_
snuffers	14	32	692	3	snuffers
sofar	8	61	1549	3	s_ofar_
sofars	9	47	1278	3	s_ofars
souari	6	3	1138	3	s_ouari
stuffer	13	34	979	3	stuffer_
stuffers	14	27	738	3	stuffers
subarid	10	3	1065	3	su_barid
subpar	10	4	866	3	subpar_
subpart	11	3	1112	3	subpart
sudaria	8	4	797	3	su_daria
sudary	10	3	870	3	su_dary
suffered	15	3	673	3	suffered
sufferer	14	3	606	3	sufferer
suffering	16	3	729	3	suffering
suffice	15	19	757	3	suffice
suffix	19	3	523	3	suff_ix
sufflate	14	5	618	3	sufflate
suffrage	15	5	452	3	suffrage
suffuse	13	3	544	3	suffuse
sugar	6	3	1291	3	su_gar_
sugars	7	3	1242	3	su_gars
sugary	10	3	901	3	su_gary
sulfa	8	3	1392	3	sulfa__
sulfas	9	3	1156	3	sulfa_s
sulfate	10	3	1165	3	sulfate
sulfur	9	3	791	3	sulfur_
sulfuric	13	4	410	3	sulfuric
sulfurs	10	3	734	3	sulfurs
sulfury	13	4	516	3	sulfury
summary	14	29	735	3	summary
sunfast	10	3	850	3	sunfast
sunward	11	3	765	3	sunward
surface	12	3	865	3	surface
surfer	9	35	1588	3	surfer_
surfers	10	36	1413	3	surfers
uakari	10	4	686	3	_uakari
unfair	9	3	623	3	_unfair
urari	5	46	1996	3	_u_rari
zaffar	21	38	504	3	zaffar_
zaffars	22	32	523	3	zaffars

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.466	383457.1
2	DLD Change Limit	134027	70	6.483	20673.6
3	Display Results	70	70	0.033	2121.2
	(SQL Overall)	178691	70	6.982	25593.1