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

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

79 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
phasing	13	32	1167	(None)
chasing	13	37	1589	1	chasing
phrasing	14	3	801	1	phrasing
abasing	10	6	1067	2	abasing
basing	9	54	2766	2	_basing
biasing	10	35	1245	2	biasing
casing	9	48	2910	2	_casing
ceasing	10	41	1826	2	ceasing
chafing	16	39	1149	2	chafing
charing	13	37	2132	2	charing
chasings	14	31	825	2	chasings
chawing	16	48	1303	2	chawing
easing	7	49	2646	2	_easing
erasing	8	3	1796	2	erasing
feasing	11	39	1665	2	feasing
hading	11	39	2294	2	_hading
haeing	10	41	1892	2	_haeing
haling	10	42	2978	2	_haling
haring	10	42	3300	2	_haring
hashing	14	50	2016	2	_hashing
hasping	13	44	1490	2	_hasping
hasting	11	47	2519	2	_hasting
hating	10	49	2971	2	_hating
having	13	42	2037	2	_having
hawing	13	43	2235	2	_hawing
haying	13	44	2061	2	_haying
hazing	19	42	1855	2	_hazing
hosing	10	34	2110	2	_hosing
lasing	7	47	2798	2	_lasing
leasing	8	39	2016	2	leasing
pacing	11	45	2275	2	p_acing
paging	10	40	2040	2	p_aging
paling	9	35	3013	2	p_aling
paring	9	42	3649	2	p_aring
parsing	10	38	1955	2	parsing
pashing	13	51	2051	2	p_ashing
passing	10	43	1842	2	passing
pasting	10	38	2655	2	p_asting
pausing	10	39	1281	2	pausing
paving	12	45	1974	2	p_aving
pawing	12	45	1955	2	p_awing
paying	12	37	2216	2	p_aying
peacing	12	41	1707	2	peacing
peaking	14	43	1769	2	peaking
pealing	10	41	2320	2	pealing
peising	10	34	1676	2	peising
pharming	16	24	814	2	pharming
phasic	13	36	1205	2	phasi_c
phasis	11	46	1492	2	phasi_s
phoning	13	3	1205	2	phoning
phrasings	15	4	433	2	phrasings
pissing	10	39	1480	2	pissing
placing	12	38	1528	2	placing
planing	10	34	1825	2	planing
plashing	14	33	1106	2	plashing
plating	10	38	2307	2	plating
playing	13	38	1609	2	playing
pleasing	11	26	1159	2	pleasing
poising	10	36	1710	2	poising
posing	9	39	2264	2	p_osing
praising	11	32	1456	2	praising
prating	10	34	2445	2	prating
praying	13	37	1732	2	praying
prising	10	33	2145	2	prising
prosing	10	33	1938	2	prosing
pshawing	17	3	352	2	pshawing
pulsing	10	37	1286	2	pulsing
pursing	10	37	1555	2	pursing
rasing	7	43	3083	2	_rasing
shading	12	31	1556	2	shading
shaking	15	33	1725	2	shaking
shaming	13	30	1674	2	shaming
shaping	13	31	1618	2	shaping
sharing	11	37	2324	2	sharing
shaving	14	34	1433	2	shaving
shawing	14	35	1488	2	shawing
teasing	8	39	1851	2	teasing
thawing	14	37	868	2	thawing
whaling	14	39	1077	2	whaling

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.376	475242.0
2	DLD Change Limit	107671	79	3.373	31921.4
3	Display Results	79	79	0.033	2393.9
	(SQL Overall)	178691	79	3.782	47247.8