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

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

73 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
lightfaces	19	7	309	(None)
lightface	18	6	306	1	lightface_
lightfaced	20	7	225	1	lightfaced
lighterages	16	5	241	3	lighterages
lightfast	16	4	364	3	lightfa_st
lightplanes	17	5	239	3	lightplanes
lightwave	19	5	290	3	lightwave_
nightfalls	17	5	289	3	nightfalls
nightmares	16	5	356	3	nightmares
bifaces	14	4	806	4	bi___faces
blighties	15	4	622	4	blight__ies
catfaces	15	3	696	4	__catfaces
dogfaces	15	5	414	4	dog__faces
doughfaces	20	5	183	4	dough_faces
eightballs	16	5	243	4	eightballs
eighties	12	7	1080	4	eight__ies
highjacks	29	5	269	4	high_jacks
hightails	16	4	531	4	hight_ails
liftgates	13	4	351	4	li_ftgates
ligases	8	23	1071	4	lig___ases
ligates	8	23	1838	4	lig___ates
ligatures	10	4	493	4	ligat_ures
lightbulbs	18	6	161	4	lightbulbs
lighted	12	29	1350	4	light___ed
lighten	11	28	1152	4	light___en
lightened	14	4	602	4	light_ened
lightener	13	4	569	4	light_ener
lighteners	14	4	498	4	lighteners
lightens	12	25	1000	4	light__ens
lighter	11	31	1344	4	light___er
lighterage	15	5	254	4	lighterage_
lightered	14	4	628	4	light_ered
lighters	12	31	1139	4	light__ers
lightest	12	14	1035	4	light___est
lightfastness	20	6	131	4	lightfastness
lightful	15	4	416	4	lightf__ul
lighthouse	17	5	327	4	lighthouse
lighthouses	18	5	297	4	lighthouses
lightings	14	27	772	4	light_ings
lightless	13	8	607	4	light_less
lightness	13	10	743	4	light_ness
lightnesses	15	4	614	4	lightnesses
lightnings	15	26	380	4	lightnings
lightplane	16	5	247	4	lightplane_
lights	10	45	1991	4	light____s
lightships	19	5	328	4	lightships
lightsome	15	11	417	4	lightsome_
lightwoods	18	5	279	4	lightwoods
lignifies	13	4	626	4	lignif_ies
lithiases	12	4	477	4	lith_iases
lithifies	15	4	550	4	lithif_ies
mistraces	13	3	1229	4	mi_straces
nightcaps	17	4	319	4	nightca_ps
nightfall	16	5	315	4	nightfa_ll
nighthawks	24	5	225	4	nighthawks
nighties	12	10	1138	4	night__ies
nightjars	20	4	334	4	nightja_rs
nightlifes	17	9	375	4	nightlifes
nightlives	17	6	380	4	nightlives
nightmare	15	5	362	4	nightmare_
nightshades	19	5	191	4	nightshades
nightsides	15	4	394	4	nightsides
nighttides	15	4	376	4	nighttides
nighttimes	16	5	318	4	nighttimes
outfaces	13	23	1139	4	__outfaces
postfaces	16	5	627	4	_postfaces
righties	12	7	1157	4	right__ies
rightsizes	23	5	343	4	rightsizes
sightlines	14	6	575	4	sightlines
sightsees	13	4	454	4	sight_sees
tightropes	16	5	359	4	tightropes
tightwads	17	4	282	4	tightwa_ds
tightwires	17	10	276	4	tightwires

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	161450	0.436	409841.7
2	DLD Change Limit	161450	73	9.033	17873.4
3	Display Results	73	73	0.046	1587.0
	(SQL Overall)	178691	73	9.515	18779.9