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

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

74 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
preying	13	31	1455	(None)
greying	12	41	1089	1	greying
praying	13	37	1732	1	praying
preeing	10	38	1767	1	preeing
prying	12	41	1480	1	pr_ying
braying	13	44	1631	2	braying
brewing	13	34	1115	2	brewing
creping	12	29	1365	2	creping
crewing	13	32	1263	2	crewing
crying	12	36	1228	2	cr_ying
draying	12	38	1384	2	draying
dreeing	9	43	1118	2	dreeing
drying	11	34	1160	2	dr_ying
eying	9	61	1792	2	__eying
fleying	14	32	987	2	fleying
fraying	14	34	1343	2	fraying
freeing	11	37	1391	2	freeing
frying	13	45	1140	2	fr_ying
gleying	12	31	843	2	gleying
graying	12	41	1588	2	graying
greeing	9	36	1378	2	greeing
keying	14	3	804	2	_keying
obeying	13	3	654	2	obeying
parleying	15	3	611	2	parleying
parrying	14	16	813	2	parrying
partying	14	16	889	2	partying
paying	12	37	2216	2	p_aying
peeing	9	46	1808	2	p_eeing
peeking	14	44	1495	2	peeking
peeling	10	29	1987	2	peeling
peening	10	33	1830	2	peening
peeping	12	36	1521	2	peeping
peering	10	35	2035	2	peering
peeving	13	51	1224	2	peeving
perking	14	37	1646	2	perking
perming	12	34	1609	2	perming
piecing	12	4	1045	2	piecing
pieing	9	39	1765	2	pie_ing
pitying	13	29	1024	2	pitying
playing	13	38	1609	2	playing
ploying	13	28	1157	2	ploying
plying	12	43	1208	2	p_lying
ponying	13	33	1212	2	ponying
prating	10	34	2445	2	prating
prebind	12	38	1064	2	prebind
prebuying	17	3	430	2	prebuying
predrying	16	4	534	2	predrying
preening	11	31	1584	2	preening
prepaying	17	4	797	2	prepaying
prepping	12	30	976	2	prepping
presong	10	3	984	2	presong
pressing	11	25	1644	2	pressing
prettying	15	3	604	2	prettying
pretyping	17	6	494	2	pretyping
prevuing	14	5	725	2	prevuing
pricing	12	34	1734	2	pricing
priding	11	33	1754	2	priding
priming	12	34	1737	2	priming
prising	10	33	2145	2	prising
prizing	19	35	1468	2	prizing
probing	12	33	1444	2	probing
prosing	10	33	1938	2	prosing
proving	13	42	1407	2	proving
pruning	10	3	1173	2	pruning
pureeing	11	3	727	2	pureeing
purveying	18	4	357	2	purveying
raying	10	50	2719	2	_raying
reding	8	38	2556	2	_reding
relying	11	29	1461	2	_relying
retying	11	32	1383	2	_retying
spraying	14	29	988	2	spraying
treeing	8	34	1430	2	treeing
trying	10	42	1407	2	tr_ying
wrying	13	37	962	2	wr_ying

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.373	479064.3
2	DLD Change Limit	107671	74	3.406	31612.2
3	Display Results	74	74	0.016	4625.0
	(SQL Overall)	178691	74	3.795	47085.9