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

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

72 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
ploying	13	28	1157	(None)
cloying	13	35	1175	1	cloying
playing	13	38	1609	1	playing
plowing	13	31	1172	1	plowing
plying	12	43	1208	1	pl_ying
alloying	12	33	914	2	alloying
allying	11	30	1166	2	allying
blowing	13	38	1305	2	blowing
buoying	13	37	995	2	buoying
claying	13	36	1430	2	claying
cloning	10	32	1547	2	cloning
closing	10	31	1484	2	closing
coying	12	40	2148	2	_coying
deploying	16	3	615	2	deploying
eloping	10	35	1283	2	eloping
employing	17	6	534	2	employing
flaying	14	39	1446	2	flaying
fleying	14	32	987	2	fleying
flowing	14	34	1176	2	flowing
flying	13	46	1215	2	fl_ying
gleying	12	31	843	2	gleying
globing	11	32	1000	2	globing
glorying	13	3	554	2	glorying
gloving	12	30	844	2	gloving
glowing	12	32	1179	2	glowing
glozing	18	33	889	2	glozing
joying	17	38	1080	2	_joying
laying	10	45	2570	2	_laying
looing	7	36	2104	2	_looing
loping	9	39	2141	2	_loping
losing	7	40	2287	2	_losing
loving	10	44	1672	2	_loving
lowing	10	46	2327	2	_lowing
loxing	14	36	1527	2	_loxing
lying	9	57	1745	2	_l_ying
palsying	14	3	623	2	palsying
paying	12	37	2216	2	p_aying
phoning	13	3	1205	2	phoning
phonying	17	4	583	2	phonying
piloting	11	3	969	2	piloting
pitying	13	29	1024	2	pitying
placing	12	38	1528	2	placing
planing	10	34	1825	2	planing
plating	10	38	2307	2	plating
plodding	13	16	634	2	plodding
plonking	15	35	856	2	plonking
plopping	12	31	870	2	plopping
plotting	11	30	1101	2	plotting
plotzing	20	27	615	2	plotzing
pluming	12	34	1204	2	pluming
poking	13	38	1930	2	p_oking
poling	9	35	2650	2	p_oling
polling	10	29	2038	2	polling
ponying	13	33	1212	2	ponying
poohing	13	31	1232	2	poohing
pooing	9	38	2068	2	p_ooing
pooling	10	32	1909	2	pooling
pooping	12	36	1544	2	pooping
poring	9	42	2727	2	p_oring
posing	9	39	2264	2	p_osing
poxing	16	37	1494	2	p_oxing
praying	13	37	1732	2	praying
preying	13	31	1455	2	preying
probing	12	33	1444	2	probing
prosing	10	33	1938	2	prosing
proving	13	42	1407	2	proving
prying	12	41	1480	2	p_rying
slaying	11	33	1684	2	slaying
sloping	10	41	1407	2	sloping
slowing	11	28	1474	2	slowing
splaying	14	21	930	2	splaying
toying	10	50	1730	2	_toying

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.403	443402.0
2	DLD Change Limit	107671	72	3.423	31455.2
3	Display Results	72	72	0.033	2181.8
	(SQL Overall)	178691	72	3.859	46305.0