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

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

53 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
traffics	16	4	418	(None)
traffic	15	4	473	1	traffic_
raffias	13	23	771	2	_raffias
taffias	13	37	741	2	t_affias
taffies	13	30	1269	2	t_affies
tragics	10	33	808	2	tra_gics
baffies	15	36	1294	3	_baffies
draffier	15	7	432	3	draffier
draffiest	16	4	436	3	draffiest
draffish	18	4	455	3	draffish
draffs	13	61	790	3	draff__s
fanfics	15	3	517	3	_fanfics
graffiti	15	4	298	3	graffiti
graffitis	16	4	271	3	graffitis
graffito	15	4	287	3	graffito
graphics	16	4	565	3	graphics
griffins	15	4	478	3	griffins
haffits	16	3	619	3	_haffits
kaffirs	17	32	555	3	_kaffirs
maffias	15	32	728	3	_maffias
maffick	21	4	352	3	_maffick
mafficks	22	4	317	3	_mafficks
paraffins	17	4	464	3	paraffins
raffia	12	28	770	3	_raffi_a
raffish	16	5	884	3	_raffish
raffles	13	36	1184	3	_raffles
raffs	11	50	1752	3	_raff__s
tactics	11	4	932	3	t_actics
taffia	12	28	690	3	t_affi_a
tafias	9	31	1196	3	t_a_fias
tiffins	13	32	798	3	t_iffins
toffies	13	32	1021	3	t_offies
trafficked	23	5	175	3	trafficked
trafficker	22	5	158	3	trafficker
traffickers	23	5	144	3	traffic~~ker~~s
tragic	9	38	1154	3	tra_gic_
traiks	10	40	1371	3	tra__iks
trails	6	46	2251	3	tra__ils
trains	6	47	2534	3	tra__ins
traits	6	51	2198	3	tra__its
trannies	8	4	1501	3	trannies
transits	8	3	1350	3	transits
travails	11	4	608	3	travails
travois	10	3	788	3	travoi_s
trayfuls	14	4	348	3	trayfuls
trefoils	11	4	530	3	trefoils
triadics	11	4	613	3	triadics
troffers	14	12	543	3	troffers
tropics	11	36	1065	3	tr_opics
truffes	13	5	677	3	truff_es
truffles	14	8	559	3	truffles
waffies	16	36	1144	3	_waffies
zaffirs	22	37	566	3	_zaffirs

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	146162	0.436	409841.7
2	DLD Change Limit	146162	53	7.123	20519.7
3	Display Results	53	53	0.016	3312.5
	(SQL Overall)	178691	53	7.575	23589.6