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

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

74 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
blighties	15	4	622	(None)
blighted	15	4	686	2	blight_ed
blighter	14	6	685	2	blight_er
blighters	15	5	574	2	blighters
blighting	16	3	573	2	blighting
blights	13	31	1021	2	blight__s
eighties	12	7	1080	2	_eighties
flightier	16	4	442	2	flightier
flightiest	17	4	450	2	flightiest
nighties	12	10	1138	2	_nighties
righties	12	7	1157	2	_righties
alighted	13	4	767	3	alight_ed
alighting	14	4	641	3	alighting
alights	11	32	1143	3	alight__s
bhisties	13	3	900	3	bhi_sties
bigamies	13	3	737	3	b_igamies
biggies	11	38	1352	3	b_ig_gies
bighted	14	28	1092	3	b_ight_ed
bighting	15	26	945	3	b_ighting
bights	12	44	1796	3	b_ight__s
bigotries	12	8	644	3	b_igotries
blasties	10	21	1363	3	bl_asties
blight	12	41	1462	3	blight___
blighty	16	35	684	3	blight__y
blintzes	19	4	426	3	bli_ntzes
blites	8	47	2121	3	bli__t_es
blitzes	18	40	870	3	bli__tzes
brighten	14	6	624	3	bright_en
brightens	15	6	537	3	brightens
brighter	14	7	666	3	bright_er
brightest	15	4	566	3	bright_est
brightish	18	6	366	3	brightish
brightness	16	4	457	3	brightness
brights	13	37	1023	3	bright__s
flighted	16	4	697	3	flight_ed
flightily	19	4	335	3	flightily
flightiness	18	4	389	3	flightiness
flighting	17	3	610	3	flighting
flightless	17	7	339	3	flightless
flights	14	33	1098	3	flight__s
ligates	8	23	1838	3	_ligat_es
lighted	12	29	1350	3	_light_ed
lighten	11	28	1152	3	_light_en
lightens	12	25	1000	3	_lightens
lighter	11	31	1344	3	_light_er
lighters	12	31	1139	3	_lighters
lightest	12	14	1035	3	_light_est
lighting	13	28	1183	3	_lighting
lightings	14	27	772	3	_lightings
lightish	15	5	662	3	_lightish
lightless	13	8	607	3	_lightless
lightness	13	10	743	3	_lightness
lights	10	45	1991	3	_light__s
lignites	9	12	961	3	_lignites
mightier	14	3	638	3	_mightier
mightiest	15	4	644	3	_mightiest
naughties	13	4	457	3	naughties
nightie	11	7	965	3	_nightie_
obligates	12	20	785	3	obligat_es
pigsties	11	3	978	3	_pigsties
plighted	15	4	646	3	plight_ed
plighter	14	7	662	3	plight_er
plighters	15	4	553	3	plighters
plighting	16	3	556	3	plighting
plights	13	29	931	3	plight__s
slighted	13	5	739	3	slight_ed
slighter	12	5	782	3	slight_er
slighters	13	4	671	3	slighters
slightest	13	13	694	3	slight_est
slighting	14	3	637	3	slighting
slightness	14	5	480	3	slightness
slights	11	28	1072	3	slight__s
weightier	16	4	331	3	weightier
weightiest	17	4	342	3	weightiest

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	148641	0.406	440125.6
2	DLD Change Limit	148641	74	6.670	22285.0
3	Display Results	74	74	0.033	2242.4
	(SQL Overall)	178691	74	7.109	25135.9