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

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

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.

62 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
sufferances	19	5	337	(None)
sufferance	18	5	342	1	sufferance_
differences	20	5	491	3	differences
severances	15	4	678	3	s_everances
sufferable	18	4	332	3	sufferable_
sufferings	17	4	323	3	sufferin_gs
suffrages	16	4	438	3	suff_ra_ges
sustenances	13	5	362	3	sustenances
utterances	12	4	508	3	_utterances
affiances	17	4	515	4	_aff_iances
affirmances	21	5	260	4	_affirmances
conferences	18	9	881	4	conferences
cumbrances	18	4	421	4	cu_mbrances
deferences	16	7	787	4	_deferences
difference	19	5	502	4	difference_
differenced	21	5	346	4	differenced
durances	11	5	868	4	du___rances
esperances	14	4	625	4	_esperances
exuberances	22	5	246	4	exuberances
furtherances	20	5	201	4	furtherances
inferences	15	4	1036	4	_inferences
iterances	11	4	891	4	__iterances
nurturances	13	5	243	4	nurturances
offences	16	4	502	4	_offe__nces
outfences	14	5	646	4	outfe__nces
outrances	11	29	1211	4	ou__trances
preferences	18	7	619	4	preferences
pufferies	17	4	520	4	puffer__ies
purtenances	15	5	386	4	purtenances
purveyances	21	5	206	4	purveyances
references	15	8	935	4	_references
seances	9	30	1534	4	s___e_ances
securances	14	4	574	4	s_ecurances
severance	14	4	733	4	s_everance_
subbranches	20	5	280	4	su_bbranches
subframes	16	4	585	4	subf_ra_mes
submergences	19	5	299	4	submergences
subraces	12	3	1303	4	su__bra_ces
substances	14	4	632	4	su_bstances
subtenancies	16	5	301	4	subtenancies
sufferably	21	5	255	4	suffera_bly
suffered	15	3	673	4	suffer___ed
sufferer	14	3	606	4	suffer___er
sufferers	15	5	510	4	suffer__ers
suffering	16	3	729	4	sufferin__g
suffers	13	31	1354	4	suffer____s
suffices	16	20	818	4	suff___ices
sufflates	15	4	603	4	suff_la_tes
suffocates	18	4	325	4	suffoca_tes
suffragans	17	5	147	4	suff_ragans
suffrage	15	5	452	4	suff_ra_ge_
sulfurates	13	4	576	4	sulfura_tes
supernates	12	4	1326	4	su_pernates
superraces	14	4	986	4	su_perraces
suppliances	17	10	266	4	suppliances
surfaces	13	3	867	4	surf__a_ces
survivances	19	5	216	4	survivances
sustenance	12	5	383	4	sustenance_
temperances	17	5	473	4	temperances
tolerances	12	4	599	4	_tolerances
unfences	13	3	793	4	_unfe__nces
utterance	11	4	546	4	_utterance_

Search took 10 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	148819	0.423	422437.4
2	DLD Change Limit	148819	62	8.906	16710.0
3	Display Results	62	62	0.046	1347.8
	(SQL Overall)	178691	62	9.375	19060.4