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

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

88 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
pricy	12	48	1456	(None)
price	9	37	2541	1	price
pricey	13	44	1263	1	pricey
prick	13	43	1750	1	prick
pricky	17	42	1034	1	pricky
privy	13	43	983	1	privy
brick	13	46	1815	2	brick
bricky	17	48	909	2	bricky
briny	10	47	1966	2	briny
crick	13	51	1875	2	crick
drily	9	58	1652	2	drily
erica	7	3	1654	2	erica
grimy	11	43	1260	2	grimy
gripy	11	51	1525	2	gripy
icy	8	63	2212	2	__icy
juicy	17	3	828	2	juicy
pacy	11	53	2868	2	p_acy
parity	11	47	1987	2	parity
pic	7	60	4682	2	p_ic_
pica	8	58	3149	2	p_ica
pice	8	46	4109	2	p_ice
pick	12	59	3381	2	p_ick
picky	16	54	1694	2	p_icky
pics	8	56	3391	2	p_ics
pily	9	61	3273	2	p_ily
piny	9	118	3835	2	p_iny
pipy	11	54	2151	2	p_ipy
piracy	13	3	947	2	piracy
pity	9	60	3193	2	p_ity
pixy	16	61	1776	2	p_ixy
plica	9	6	1337	2	plica
policy	13	32	1151	2	policy
pray	9	63	3153	2	pr_ay
prexy	17	46	1157	2	prexy
prey	9	62	2848	2	pr_ey
priced	11	50	1888	2	priced
pricer	10	39	1829	2	pricer
prices	10	45	2454	2	prices
pricily	14	27	1028	2	pricily
prickly	18	36	789	2	prickly
pricks	14	44	1426	2	pricks
pride	8	47	2473	2	pride
pried	8	44	2686	2	pried
prier	7	50	2776	2	prier
pries	7	43	3953	2	pries
prig	7	59	2487	2	pri_g
prigs	8	52	1970	2	prigs
prill	7	41	1794	2	prill
prim	8	51	3220	2	pri_m
prima	9	50	1934	2	prima
primacy	16	3	560	2	primacy
prime	9	65	2560	2	prime
primi	9	50	1740	2	primi
primly	13	43	962	2	primly
primo	9	50	1791	2	primo
primp	11	56	1592	2	primp
prims	9	54	2593	2	prims
prince	10	41	1476	2	prince
prink	11	47	1967	2	prink
print	7	48	3746	2	print
prion	7	51	1999	2	prion
prior	7	43	1617	2	prior
priory	11	41	1026	2	priory
prise	7	46	3261	2	prise
prism	9	48	2026	2	prism
priss	7	46	2389	2	priss
prissy	11	34	785	2	prissy
privacy	17	4	423	2	privacy
prize	16	47	1894	2	prize
prosy	10	63	1925	2	prosy
proxy	17	50	1101	2	proxy
pry	8	57	2805	2	pr__y
purify	14	39	915	2	purify
purity	11	41	1491	2	purity
pyic	11	69	1582	2	pyic_
pyric	12	38	1507	2	pyric_
racy	9	58	2568	2	_racy
rice	6	49	4291	2	_rice
rich	9	70	2554	2	_rich
rick	10	73	3465	2	_rick
rimy	9	66	2128	2	_rimy
spicy	12	54	1771	2	spicy
sprucy	13	35	632	2	sprucy
trice	7	51	2749	2	trice
trick	11	54	2069	2	trick
tricky	15	42	1147	2	tricky
uric	6	36	2493	2	uric_
wrick	14	40	1339	2	wrick

Search took 5 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	53800	0.186	960704.3
2	DLD Change Limit	53800	88	4.080	13186.3
3	Display Results	88	88	0.063	1396.8
	(SQL Overall)	178691	88	4.329	41277.7