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

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

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
infightings	19	5	210	(None)
infighting	18	4	441	1	infighting_
fightings	17	27	650	2	__fightings
fighting	16	27	1008	3	__fighting_
gunfighting	20	5	177	3	gunfighting_
indigotins	12	4	384	3	indigotin_s
infighters	17	4	332	3	infight_ers
infights	15	4	557	3	infight___s
knighting	18	4	444	3	kn_ighting_
lightings	14	27	772	3	__lightings
refighting	18	4	520	3	refighting_
sightings	14	25	653	3	__sightings
unsighting	15	8	444	3	unsighting_
affrighting	22	5	201	4	affrighting_
alighting	14	4	641	4	_alighting_
bedighting	18	4	417	4	bedighting_
bighting	15	26	945	4	__bighting_
blighting	16	3	573	4	_blighting_
bullfightings	23	6	95	4	bullfightings
cockfightings	29	6	86	4	cockfightings
daylightings	21	8	101	4	daylightings
delighting	16	4	499	4	delighting_
dighting	14	25	1084	4	__dighting_
dogfighting	21	5	150	4	dogfighting_
enlightens	14	4	374	4	enlighten_s
fagotings	14	4	315	4	__fagotings
fishings	15	30	769	4	__fish_ings
fittings	12	31	820	4	__fi_ttings
flighting	17	3	610	4	_flighting_
freighting	18	4	454	4	freighting_
frighting	17	3	602	4	_frighting_
highting	16	25	972	4	__highting_
inciting	11	3	1253	4	inci__ting_
indagating	13	4	526	4	indagating_
indicating	14	4	969	4	indicating_
indicting	13	3	961	4	indi_cting_
indigotin	11	4	419	4	indigotin__
inditing	10	3	1211	4	indi__ting_
infecting	15	10	967	4	inf_ecting_
infesting	13	10	951	4	inf_esting_
infight	14	3	745	4	infight____
infighter	16	4	427	4	infight__er
infinities	13	6	944	4	infiniti_es
infinitives	17	4	468	4	infinitives
infirming	15	4	516	4	infi_rming_
infixations	21	4	669	4	infixations
infixing	19	3	610	4	infi__xing_
inflating	13	3	1044	4	inf_lating_
inflecting	16	4	631	4	inflecting_
inflicting	16	4	572	4	inflicting_
infracting	16	4	735	4	infracting_
ingoting	10	3	986	4	in__goting_
inhibiting	16	4	511	4	inhibiting_
inrushings	14	7	230	4	inrush_ings
insights	12	4	549	4	insight___s
insisting	10	3	882	4	insi_sting_
instigating	13	4	715	4	instigating_
intimating	13	4	1082	4	intimating_
inveighing	18	4	273	4	inveigh_ing_
inviting	12	3	973	4	invi__ting_
irrigating	12	4	595	4	irrigating_
knittings	14	27	345	4	kn_i_ttings
lighting	13	28	1183	4	__lighting_
lightnings	15	26	380	4	__lightnings
mislighting	18	4	341	4	mislighting_
neighing	13	5	552	4	_neigh_ing_
nigglings	12	21	373	4	_n_igglings
nighing	12	34	1006	4	_n_igh_ing_
nighties	12	10	1138	4	_n_ighti_es
outfighting	19	4	331	4	outfighting_
plighting	16	3	556	4	_plighting_
prizefightings	33	12	81	4	prizefightings
relighting	15	4	585	4	relighting_
resighting	15	4	607	4	resighting_
righting	13	26	1085	4	__righting_
sighting	13	31	1086	4	__sighting_
slighting	14	3	637	4	_slighting_
unfitting	13	3	642	4	unfi_tting_
unweighting	19	5	230	4	unweighting_
uplighting	17	4	336	4	uplighting_
uprighting	17	4	346	4	uprighting_
weighting	17	4	478	4	_weighting_

Search took 9 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.403	443402.0
2	DLD Change Limit	148819	82	8.110	18350.1
3	Display Results	82	82	0.046	1782.6
	(SQL Overall)	178691	82	8.559	20877.6