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

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

76 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
pixies	15	49	1551	(None)
nixies	13	53	1387	1	nixies
pities	8	38	2808	1	pities
pixes	14	43	2317	1	pix_es
pixie	14	54	1552	1	pixie_
pyxies	18	33	829	1	pyxies
bikies	12	45	1516	2	bikies
cities	8	45	2485	2	cities
civies	11	41	1644	2	civies
dexies	14	50	1834	2	dexies
didies	8	46	2183	2	didies
dixits	14	42	1031	2	dixits
doxies	14	39	1785	2	doxies
epoxies	16	3	775	2	epoxies
fixes	15	47	2359	2	fix_es
ivies	8	42	1576	2	_ivies
ixias	12	48	837	2	_ixias
lilies	6	30	2141	2	lilies
mixes	14	72	2440	2	mix_es
moxies	15	43	1740	2	moxies
nixes	12	45	1962	2	nix_es
nixie	12	51	1494	2	nixie_
paries	8	47	4251	2	paries
paxes	14	49	2842	2	pax_es
pieces	10	42	1727	2	pieces
pies	6	69	4960	2	p__ies
pieties	9	4	1922	2	pieties
piggies	11	38	1348	2	piggies
pigmies	12	26	1099	2	pigmies
pikes	11	50	3103	2	pi_kes
pikis	11	51	1639	2	piki_s
piles	7	47	4261	2	pi_les
pilis	7	58	2520	2	pili_s
pines	7	60	4886	2	pi_nes
pinier	8	40	2469	2	pinier
piniest	9	31	2113	2	piniest
pinites	9	3	1953	2	pinites
pinkies	13	38	1826	2	pinkies
pinnies	9	33	1844	2	pinnies
pipes	9	60	3014	2	pi_pes
pipier	10	49	1398	2	pipier
pipiest	11	31	1450	2	pipiest
pipits	10	47	1306	2	pipits
piques	17	3	909	2	piques
pishes	11	47	2210	2	pishes
pisses	8	45	2508	2	pisses
pistes	8	53	2563	2	pistes
pitied	9	40	1725	2	pitied
pitier	8	40	1982	2	pitier
pitiers	9	38	1265	2	pitiers
pixel	14	39	1190	2	pix_el
pixels	15	47	853	2	pixels
pixieish	20	4	260	2	pixieish
pixiness	17	3	609	2	pixiness
plies	7	45	2651	2	p_lies
pogies	9	41	2354	2	pogies
pokies	12	59	2133	2	pokies
polies	8	40	3458	2	polies
ponies	8	48	3346	2	ponies
posies	8	44	3143	2	posies
poxes	14	53	2572	2	pox_es
poxier	15	38	1211	2	poxier
poxiest	16	34	1225	2	poxiest
prexies	16	34	1500	2	prexies
pries	7	43	3953	2	p_ries
privies	12	24	1426	2	privies
proxies	16	30	1493	2	proxies
pyxes	17	59	1140	2	pyx_es
pyxides	20	3	442	2	pyxides
pyxie	17	35	936	2	pyxie_
pyxis	17	45	863	2	pyxi_s
sixes	12	45	2636	2	six_es
sixtes	13	36	1240	2	sixtes
sixties	14	3	1097	2	sixties
taxies	13	58	1733	2	taxies
tidies	7	47	2183	2	tidies

Search took 3 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	82551	0.470	380193.6
2	DLD Change Limit	82551	76	2.436	33887.9
3	Display Results	76	76	0.030	2533.3
	(SQL Overall)	178691	76	2.936	60862.1