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

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

56 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
lighterages	16	5	241	(None)
lighterage	15	5	254	1	lighterage_
lightered	14	4	628	3	lighter__ed
lighters	12	31	1139	3	lighter___s
lightfaces	19	7	309	3	light_faces
lightplanes	17	5	239	3	lightplanes
literates	9	14	1565	3	li__terates
aliterates	10	15	1077	4	ali__terates
blighters	15	5	574	4	blighter___s
fighters	15	26	940	4	fighter___s
fosterages	14	4	477	4	_fosterages
gheraoes	12	4	482	4	__gh_eraoes
illiterates	11	11	565	4	illiterates
interage	9	3	1449	4	_i_nterage_
iterates	8	13	1782	4	_i__terates
layerages	13	4	530	4	l__ayerages
leverages	13	6	566	4	l__everages
liberates	11	10	1295	4	li__berates
lienteries	10	4	757	4	lienter_ies
ligatures	10	4	493	4	ligatur__es
lightened	14	4	602	4	lighte__ned
lightener	13	4	569	4	lighte__ner
lighteners	14	4	498	4	lighte_ners
lightens	12	25	1000	4	lighte___ns
lighter	11	31	1344	4	lighter____
lightering	15	24	611	4	lighter_ing
lightface	18	6	306	4	light_face_
lightfaced	20	7	225	4	light_faced
lighthearted	20	6	171	4	lighthearted
lighthouses	18	5	297	4	lighthouses
lightings	14	27	772	4	light_ing_s
lightnesses	15	4	614	4	lightnesses
lightninged	17	5	137	4	lightninged
lightnings	15	26	380	4	lightning_s
lightplane	16	5	247	4	lightplane_
lightwave	19	5	290	4	light_wave_
lineages	9	7	918	4	li__ne_ages
literacies	12	4	880	4	li__teracies
literals	8	3	1229	4	li__tera_ls
literate	8	12	1689	4	li__terate_
literatus	9	14	682	4	li__teratus
litharges	13	4	414	4	lith_ar_ges
litterbags	13	5	242	4	li_tterbag_s
littermates	13	5	286	4	li_ttermates
meterages	12	4	818	4	__meterages
nightmares	16	5	356	4	night_mares
nightshades	19	5	191	4	nightshades
pilferages	16	4	262	4	pi_lferages
plighters	15	4	553	4	plighter___s
porterages	13	4	598	4	_porterages
quarterages	21	5	285	4	quarterages
righters	12	26	1071	4	righter___s
sighters	12	25	1060	4	sighter___s
slighters	13	4	671	4	slighter___s
tightropes	16	5	359	4	tight_ropes
waterages	13	4	939	4	__waterages

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.420	425454.8
2	DLD Change Limit	148819	56	8.343	17837.6
3	Display Results	56	56	0.033	1697.0
	(SQL Overall)	178691	56	8.796	20315.0