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

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

63 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
lacewings	15	4	330	(None)
lacewing	14	3	584	1	lacewing_
lacings	10	50	1365	2	lac__ings
lapwings	14	27	497	2	la_pwings
lawings	11	36	1147	2	la__wings
layerings	13	23	568	2	layerings
acetins	9	3	1317	3	_acetin_s
actings	10	45	1246	3	_ac_tings
ageings	9	43	769	3	_age_ings
backings	17	40	1221	3	bac_kings
backswings	22	4	311	3	backswings
bitewings	15	4	294	3	bitewings
blackenings	20	4	256	3	blackenings
blackings	18	31	676	3	blac_kings
brewings	14	29	669	3	_brewings
cagelings	13	3	541	3	cagelings
faceting	14	3	878	3	faceting_
facings	13	45	1126	3	fac__ings
forewings	16	4	511	3	forewings
gaywings	16	3	319	3	ga_ywings
glaceing	12	3	653	3	glace_ing_
labeling	11	3	1164	3	labeling_
lacewoods	15	5	489	3	lacewoods
laceworks	18	4	658	3	laceworks
lacing	9	46	2623	3	lac__ing_
lackering	16	3	937	3	lackering_
lackeying	19	3	492	3	lackeying_
lacking	14	38	2154	3	lac_king_
ladening	10	7	882	3	ladening_
ladings	9	38	1413	3	la__dings
lagering	10	22	1231	3	lagering_
laggings	11	29	840	3	la_ggings
lakings	12	47	1351	3	la__kings
landings	10	31	1007	3	la_ndings
lapwing	13	30	826	3	la_pwing_
lashings	12	44	1225	3	la_shings
lastings	9	42	1442	3	la_stings
latening	9	7	1149	3	latening_
lathings	12	46	985	3	la_things
laughings	14	4	348	3	laughings
lauwines	11	4	571	3	la_uwines
lawines	10	33	1356	3	la__wines
lawing	10	46	2528	3	la__wing_
lawyerings	17	5	258	3	lawyerings
layering	12	23	1035	3	layering_
leavenings	14	7	258	3	leavenings
lickings	15	29	814	3	lic_kings
lowings	11	37	1007	3	l__owings
packings	17	43	1006	3	pac_kings
panelings	12	10	745	3	panelings
parawings	15	3	582	3	parawings
racings	10	50	1513	3	rac__ings
ravelings	13	37	738	3	ravelings
ravenings	13	23	518	3	ravenings
sackings	15	38	963	3	sac_kings
sacrings	11	27	892	3	sac_rings
sewings	11	36	917	3	__sewings
tacklings	16	23	585	3	tacklings
viewings	15	3	398	3	_viewings
wakenings	17	4	304	3	wakenings
waterings	13	22	925	3	waterings
waxwings	22	3	295	3	wa_xwings
yachtings	18	4	266	3	yachtings

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	148641	0.436	409841.7
2	DLD Change Limit	148641	63	8.143	18253.8
3	Display Results	63	63	0.030	2100.0
	(SQL Overall)	178691	63	8.609	20756.3