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

Here are the results of your fuzzy-string dictionary search for “framing” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

113 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
framing	13	30	1479	(None)
faming	12	49	2297	1	f_aming
farming	13	35	1508	1	farming
flaming	13	42	1644	1	flaming
foaming	13	36	1299	1	foaming
framings	14	33	813	1	framings
fraying	14	34	1343	1	fraying
arming	9	47	1980	2	ar_ming
beaming	12	36	1880	2	beaming
blaming	12	35	1569	2	blaming
bracing	12	38	1761	2	bracing
braking	14	39	1771	2	braking
braving	13	37	1461	2	braving
braying	13	44	1631	2	braying
brazing	19	37	1511	2	brazing
breaming	13	36	1251	2	breaming
coaming	12	38	1832	2	coaming
cramming	15	33	943	2	cramming
cramping	15	34	1185	2	cramping
craning	10	36	2030	2	craning
craping	12	40	1871	2	craping
crating	10	37	2520	2	crating
craving	13	40	1573	2	craving
crazing	19	39	1458	2	crazing
creaming	13	34	1314	2	creaming
dramming	14	34	757	2	dramming
draping	11	42	1335	2	draping
drawing	12	38	1205	2	drawing
draying	12	38	1384	2	draying
dreaming	12	40	1106	2	dreaming
enframing	15	4	611	2	enframing
erasing	8	3	1796	2	erasing
facing	12	53	2157	2	f_acing
fading	11	48	2111	2	f_ading
faking	14	55	2098	2	f_aking
famine	11	43	1819	2	f_amine
farcing	13	35	1400	2	farcing
farding	12	37	1674	2	farding
faring	10	52	3128	2	f_aring
farmings	14	29	822	2	farmings
farting	11	41	2075	2	farting
fating	10	53	2867	2	f_ating
faxing	17	51	1705	2	f_axing
faying	13	45	2107	2	f_aying
fazing	19	44	1864	2	f_azing
fearing	11	35	2003	2	fearing
feasing	11	39	1665	2	feasing
feazing	20	54	1144	2	feazing
filming	13	32	1035	2	filming
firming	13	28	1122	2	firming
flaking	15	41	1449	2	flaking
flamingo	14	27	414	2	flamingo
flamming	16	35	715	2	flamming
flaring	11	41	1680	2	flaring
flawing	14	38	1256	2	flawing
flaying	14	39	1446	2	flaying
fluming	13	35	1279	2	fluming
foaling	11	35	1584	2	foaling
foraging	13	5	806	2	foraging
foramina	13	4	616	2	foramina
foraying	15	3	743	2	foraying
forming	13	36	1573	2	forming
fragging	14	32	942	2	fragging
franking	16	43	1086	2	franking
frapping	16	34	810	2	frapping
frayings	15	32	599	2	frayings
freaking	16	36	1145	2	freaking
freeing	11	37	1391	2	freeing
frizing	20	33	1087	2	frizing
frying	13	45	1140	2	fr_ying
fuming	12	40	1329	2	f_uming
gaming	10	46	2204	2	_gaming
gracing	11	32	1644	2	gracing
grading	10	39	1871	2	grading
grating	9	39	2318	2	grating
graving	12	31	1456	2	graving
graying	12	41	1588	2	graying
grazing	18	35	1455	2	grazing
griming	11	36	1249	2	griming
harming	13	37	1793	2	harming
laming	9	45	2836	2	_laming
loaming	10	36	1373	2	loaming
naming	9	39	1789	2	_naming
orating	8	35	2032	2	orating
prating	10	34	2445	2	prating
praying	13	37	1732	2	praying
priming	12	34	1737	2	priming
racing	9	50	3053	2	_racing
raging	8	51	2643	2	_raging
raking	11	47	2842	2	_raking
ramming	12	31	1506	2	_ramming
ramping	12	33	1687	2	_ramping
raping	9	48	2985	2	_raping
raring	7	43	3287	2	_raring
rasing	7	43	3083	2	_rasing
rating	7	49	3870	2	_rating
raving	10	51	2885	2	_raving
raxing	14	43	2102	2	_raxing
raying	10	50	2719	2	_raying
razing	16	45	2454	2	_razing
reaming	10	39	2401	2	reaming
reframing	15	3	862	2	reframing
riming	9	33	2222	2	_riming
roaming	10	32	1579	2	roaming
seaming	10	32	2211	2	seaming
shaming	13	30	1674	2	shaming
taming	9	40	2343	2	_taming
teaming	10	39	1759	2	teaming
tracing	10	37	2015	2	tracing
trading	9	35	1797	2	trading
tramming	13	27	934	2	tramming
tramping	13	27	1127	2	tramping
warming	13	35	1508	2	warming

Search took 4 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	107671	0.390	458182.1
2	DLD Change Limit	107671	113	3.360	32044.9
3	Display Results	113	113	0.033	3424.2
	(SQL Overall)	178691	113	3.783	47235.3