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

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

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
aloofly	13	4	362	(None)
aloof	8	35	2157	2	aloof__
blowfly	18	4	324	2	blowfly
glowfly	17	4	267	2	glowfly
shoofly	16	3	435	2	shoofly
actorly	12	4	641	3	actorly
alderfly	15	4	275	3	alderfly
aldol	6	12	1233	3	aldo_l_
aldols	7	10	971	3	aldo_ls
alertly	10	4	679	3	alertly
alienly	10	3	750	3	alienly
alkoxy	20	3	334	3	alko_xy
alloy	8	55	1997	3	allo__y
ally	7	69	3564	3	al___ly
almondy	13	14	448	3	almondy
almonry	12	10	473	3	almonry
aloft	8	4	2343	3	al_of_t
anomaly	12	3	884	3	anomaly
bloodily	14	4	518	3	bloodily
bloody	12	47	1017	3	bloo_dy
blooey	11	51	1079	3	bloo_ey
bloomy	13	45	1011	3	bloo_my
bluffly	18	3	343	3	bluffly
botfly	14	3	609	3	_botfly
closely	12	3	705	3	closely
coolly	11	48	1139	3	_coolly
cooly	10	55	2542	3	_coo_ly
dhooly	13	45	714	3	dhoo_ly
dooly	9	48	2180	3	_doo_ly
drooly	10	49	1107	3	droo_ly
flooey	12	39	1017	3	floo_ey
floosy	12	36	815	3	floo_sy
floozy	21	35	661	3	floo_zy
gallfly	14	3	352	3	gal_lfly
gloomily	14	4	375	3	gloomily
gloomy	12	52	876	3	gloo_my
goodly	11	41	930	3	_goodly
goofily	14	10	535	3	_goofily
goofy	12	49	1562	3	_goof_y
googly	11	41	788	3	_googly
hooly	11	50	2222	3	_hoo_ly
kloof	12	38	1213	3	kloof__
kloofs	13	38	635	3	kloof_s
liefly	12	6	636	3	_liefly
lofty	11	58	1330	3	_l_ofty
logily	10	3	983	3	_logily
lolly	8	51	2066	3	_l_olly
lonely	9	29	1247	3	_lonely
longly	10	27	960	3	_longly
looby	10	81	1562	3	_loo_by
looey	8	48	2291	3	_loo_ey
loof	7	81	4105	3	_loof__
loofa	8	59	1281	3	_loof_a
loofah	12	37	581	3	_loofah
loofas	9	42	983	3	_loofas
loofs	8	56	2378	3	_loof_s
looney	9	47	1241	3	_looney
loonily	10	3	707	3	_loonily
loony	8	69	1896	3	_loo_ny
loopily	12	3	680	3	_loopily
loopy	10	53	1664	3	_loo_py
loosely	10	3	671	3	_loosely
lordly	10	3	875	3	_lordly
loudly	10	3	778	3	_loudly
lovely	12	33	971	3	_lovely
lowly	11	41	1333	3	_l_owly
poofy	13	62	1327	3	_poof_y
poorly	11	3	789	3	_poorly
sallowly	14	34	483	3	sallowly
slowly	12	3	715	3	sl_owly
spoofy	14	49	855	3	spoof_y
woolly	12	40	851	3	_woolly
wooly	11	44	1767	3	_woo_ly

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	134027	0.406	440125.6
2	DLD Change Limit	134027	73	6.893	19443.9
3	Display Results	73	73	0.030	2433.3
	(SQL Overall)	178691	73	7.329	24381.4