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

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

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.

82 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
flayers	13	39	1203	(None)
flakers	14	36	1327	1	flakers
flamers	12	46	1636	1	flamers
flayer	12	47	1356	1	flayer_
flyers	12	57	1280	1	fl_yers
layers	9	39	2118	1	_layers
players	12	43	1376	1	players
slayers	10	45	1332	1	slayers
allayers	11	15	663	2	allayers
belayers	13	29	814	2	belayers
bilayers	13	29	692	2	bilayers
bladers	10	42	1468	2	bladers
blamers	11	53	1421	2	blamers
blazers	18	48	1168	2	blazers
brayers	12	45	1190	2	brayers
clavers	12	43	1490	2	clavers
clawers	12	39	1097	2	clawers
delayers	12	26	866	2	delayers
elaters	7	44	2019	2	elaters
facers	11	55	1944	2	f_acers
faders	10	51	1746	2	f_aders
fakers	13	42	1953	2	f_akers
fallers	10	39	1799	2	fallers
falters	10	39	1647	2	falters
farers	9	59	2405	2	f_arers
fearers	10	48	1527	2	fearers
flaggers	13	32	807	2	flaggers
flairs	9	57	1191	2	fla_irs
flaker	13	49	1617	2	flaker_
flakes	13	41	1887	2	flake_s
flamens	12	46	1106	2	flamens
flamer	11	49	1912	2	flamer_
flames	11	47	2369	2	flame_s
flanes	9	45	2242	2	flane_s
flaneurs	11	3	395	2	flaneurs
flangers	12	33	1137	2	flangers
flankers	15	34	930	2	flankers
flappers	15	38	838	2	flappers
flares	9	45	2170	2	flare_s
flashers	14	39	1265	2	flashers
flatters	11	38	1420	2	flatters
flavors	13	3	729	2	flavors
flaxes	16	50	1535	2	flaxe_s
flayed	13	44	1405	2	flaye_d
flays	11	63	2105	2	flay__s
fleers	9	60	1579	2	fl_eers
fliers	9	44	1719	2	fl_iers
floaters	11	27	1151	2	floaters
flowers	13	34	1317	2	flowers
fluters	10	37	1368	2	fluters
flyer	11	49	1625	2	fl_yer_
foamers	12	38	1210	2	foamers
forayers	14	27	727	2	forayers
foyers	12	54	1313	2	f_oyers
framers	12	51	1382	2	framers
fraters	10	35	1721	2	fraters
fryers	12	57	1097	2	f_ryers
glazers	17	44	1004	2	glazers
hayers	12	44	1594	2	_hayers
inlayers	11	3	564	2	inlayers
lacers	8	52	2525	2	_lacers
laders	7	49	2776	2	_laders
lagers	7	48	2614	2	_lagers
lakers	10	52	2515	2	_lakers
lasers	6	49	2570	2	_lasers
lavers	9	45	2636	2	_lavers
lawyers	13	37	715	2	_lawyers
layer	8	46	2647	2	_layer_
payers	11	46	2182	2	_payers
placers	11	45	1526	2	placers
planers	9	45	1795	2	planers
platers	9	39	2409	2	platers
player	11	52	1521	2	player_
plyers	11	49	1298	2	pl_yers
prayers	12	42	1285	2	prayers
sayers	9	42	2159	2	_sayers
slakers	11	41	1575	2	slakers
slaters	7	31	2373	2	slaters
slavers	10	37	1650	2	slavers
slayer	9	39	1633	2	slayer_
stayers	10	38	1363	2	stayers
swayers	13	39	885	2	swayers

Search took 6 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.373	479064.3
2	DLD Change Limit	107671	82	4.610	23356.0
3	Display Results	82	82	0.033	2484.8
	(SQL Overall)	178691	82	5.016	35624.2