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

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

110 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
flaying	14	39	1446	(None)
claying	13	36	1430	1	claying
faying	13	45	2107	1	f_aying
flaking	15	41	1449	1	flaking
flaming	13	42	1644	1	flaming
flaring	11	41	1680	1	flaring
flawing	14	38	1256	1	flawing
fleying	14	32	987	1	fleying
flying	13	46	1215	1	fl_ying
fraying	14	34	1343	1	fraying
laying	10	45	2570	1	_laying
playing	13	38	1609	1	playing
slaying	11	33	1684	1	slaying
allaying	12	33	931	2	allaying
allying	11	30	1166	2	allying
baying	12	52	2258	2	_baying
belaying	14	31	1060	2	belaying
blading	11	36	1536	2	blading
blaming	12	35	1569	2	blaming
blaring	10	43	1711	2	blaring
blawing	13	40	1275	2	blawing
blazing	19	36	1239	2	blazing
braying	13	44	1631	2	braying
clawing	13	38	1267	2	clawing
cloying	13	35	1175	2	cloying
delaying	13	32	1097	2	delaying
draying	12	38	1384	2	draying
elating	8	34	2308	2	elating
facing	12	53	2157	2	f_acing
fading	11	48	2111	2	f_ading
faking	14	55	2098	2	f_aking
falling	11	36	2158	2	falling
faming	12	49	2297	2	f_aming
faring	10	52	3128	2	f_aring
fating	10	53	2867	2	f_ating
faxing	17	51	1705	2	f_axing
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
flacking	18	43	1179	2	flacking
flagging	14	32	923	2	flagging
flailing	12	29	892	2	flailing
flamingo	14	27	414	2	flamingo
flamming	16	35	715	2	flamming
flanging	13	27	1058	2	flanging
flanking	16	42	1108	2	flanking
flapping	16	29	815	2	flapping
flashing	15	37	1155	2	flashing
flatling	12	34	1001	2	flatling
flatting	12	35	1125	2	flatting
flavin	12	3	930	2	flavin_
flavine	13	3	845	2	flavine
flavins	13	3	854	2	flavins
fleeing	11	35	1129	2	fleeing
flexing	18	35	899	2	flexing
fling	9	70	2351	2	fl__ing
fliting	11	35	1461	2	fliting
floating	12	31	1188	2	floating
flowing	14	34	1176	2	flowing
fluking	15	44	1051	2	fluking
fluming	13	35	1279	2	fluming
fluting	11	38	1509	2	fluting
fluxing	18	39	892	2	fluxing
flyings	14	49	606	2	fl_yings
flyting	14	37	855	2	flyting
foaling	11	35	1584	2	foaling
foaming	13	36	1299	2	foaming
foraying	15	3	743	2	foraying
framing	13	30	1479	2	framing
frayings	15	32	599	2	frayings
frying	13	45	1140	2	f_rying
glaring	9	37	1488	2	glaring
glazing	18	36	1100	2	glazing
gleying	12	31	843	2	gleying
graying	12	41	1588	2	graying
haying	13	44	2061	2	_haying
inlaying	12	4	789	2	inlaying
lacing	9	46	2623	2	_lacing
lading	8	42	2712	2	_lading
laking	11	50	2704	2	_laking
laming	9	45	2836	2	_laming
lasing	7	47	2798	2	_lasing
laving	10	46	2357	2	_laving
lawing	10	46	2528	2	_lawing
layin	8	47	2033	2	_layin_
layins	9	38	1765	2	_layins
lazing	16	48	2147	2	_lazing
lazying	20	4	667	2	_lazying
lying	9	57	1745	2	_l_ying
maying	12	44	2115	2	_maying
okaying	15	3	483	2	okaying
paying	12	37	2216	2	_paying
placing	12	38	1528	2	placing
planing	10	34	1825	2	planing
plating	10	38	2307	2	plating
ploying	13	28	1157	2	ploying
plying	12	43	1208	2	pl_ying
praying	13	37	1732	2	praying
raying	10	50	2719	2	_raying
relaying	12	25	1515	2	relaying
saying	10	43	2554	2	_saying
slaking	12	37	1747	2	slaking
slating	8	37	2465	2	slating
slaving	11	35	1483	2	slaving
spaying	13	30	1462	2	spaying
splaying	14	21	930	2	splaying
staying	11	40	1732	2	staying
swaying	14	36	1064	2	swaying
unlaying	12	5	836	2	unlaying

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.360	496363.9
2	DLD Change Limit	107671	110	3.563	30219.2
3	Display Results	110	110	0.030	3666.7
	(SQL Overall)	178691	110	3.953	45203.9