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

Here are the results of your fuzzy-string dictionary search for “piker” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

251 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
piker	11	56	2284	(None)
biker	11	60	2256	1	biker
diker	10	55	2455	1	diker
hiker	12	51	1939	1	hiker
liker	9	56	2706	1	liker
picker	14	44	2217	1	picker
pier	6	60	3529	1	pi_er
pike	10	63	3521	1	pike_
piked	12	56	2331	1	piked
pikers	12	47	1739	1	pikers
pikes	11	50	3103	1	pikes
pinker	12	53	2244	1	pinker
piper	9	65	2319	1	piper
poker	11	51	2288	1	poker
siker	9	53	2603	1	siker
spiker	12	43	1566	1	spiker
aider	6	54	3113	2	aider
aimer	7	59	2682	2	aimer
airer	5	49	2789	2	airer
aiver	8	57	2516	2	aiver
asker	9	64	1878	2	asker
baker	11	56	2954	2	baker
bicker	14	48	1917	2	bicker
bider	8	57	2837	2	bider
bier	6	55	3182	2	bi_er
bike	10	65	3259	2	bike_
biked	12	53	2003	2	biked
bikers	12	45	1755	2	bikers
bikes	11	75	2947	2	bikes
bilker	12	49	1344	2	bilker
biner	7	59	3069	2	biner
biter	7	50	3003	2	biter
cider	8	47	2331	2	cider
citer	7	48	2732	2	citer
daiker	11	51	1303	2	daiker
dicer	8	54	2642	2	dicer
dicker	13	45	2140	2	dicker
dike	9	59	3576	2	dike_
diked	11	50	2468	2	diked
dikers	11	44	1879	2	dikers
dikes	10	58	3133	2	dikes
dikey	13	51	1642	2	dikey
dimer	8	56	2560	2	dimer
diner	6	56	3290	2	diner
direr	6	49	2707	2	direr
diver	9	48	2780	2	diver
duiker	11	41	1059	2	duiker
eider	6	46	2474	2	eider
epimer	10	10	915	2	epimer
esker	9	44	1298	2	esker
faker	12	48	2459	2	faker
fiber	10	49	2113	2	fiber
fifer	11	55	1997	2	fifer
filer	8	54	3300	2	filer
finer	8	54	3156	2	finer
firer	8	112	2925	2	firer
fiver	11	60	2494	2	fiver
fixer	15	47	1783	2	fixer
giber	8	54	1770	2	giber
giver	9	49	2120	2	giver
hider	9	50	2408	2	hider
hike	11	68	3039	2	hike_
hiked	13	59	1920	2	hiked
hikers	13	50	1435	2	hikers
hikes	12	54	2698	2	hikes
hirer	8	54	2312	2	hirer
icker	11	40	1844	2	icker
inker	9	44	2109	2	inker
jiber	14	51	1570	2	jiber
jinker	17	40	1354	2	jinker
jiver	15	51	1905	2	jiver
joker	16	57	1589	2	joker
kicker	11	41	1618	2	kicker
kier	8	65	2680	2	ki_er
kike	7	65	2478	2	kike_
kikes	8	51	2255	2	kikes
kiter	9	55	2321	2	kiter
laker	9	54	3287	2	laker
liber	7	47	2361	2	liber
licker	12	52	2204	2	licker
lier	4	59	4246	2	li_er
lifer	8	58	2215	2	lifer
liger	6	50	2446	2	liger
like	8	60	4084	2	like_
liked	10	45	2381	2	liked
liken	9	118	1884	2	liken
likers	10	46	2091	2	likers
likes	9	62	3190	2	likes
liner	5	59	3891	2	liner
linker	10	43	2146	2	linker
liter	5	47	3634	2	liter
liver	8	51	3296	2	liver
maker	11	41	2781	2	maker
mike	10	55	3528	2	mike_
miked	12	50	2045	2	miked
mikes	11	51	2989	2	mikes
miler	7	57	3306	2	miler
milker	12	48	1432	2	milker
mimer	9	48	2576	2	mimer
miner	7	69	3354	2	miner
mirker	12	37	1269	2	mirker
miser	7	54	3040	2	miser
miter	7	57	3479	2	miter
mixer	14	50	1764	2	mixer
nicer	7	46	1829	2	nicer
nicker	12	38	1870	2	nicker
niter	5	50	2897	2	niter
ocker	11	39	1575	2	ocker
oiler	5	46	2828	2	oiler
pacer	9	61	3161	2	pacer
packer	14	42	2340	2	packer
pager	8	47	2820	2	pager
paiked	13	51	1343	2	paiked
paler	7	54	3693	2	paler
paper	9	51	2866	2	paper
parer	7	58	3990	2	parer
parker	12	41	2137	2	parker
pater	7	47	4072	2	pater
paver	10	42	2583	2	paver
pawer	10	44	2297	2	pawer
payer	10	51	2572	2	payer
pecker	14	46	1536	2	pecker
peer	6	62	3835	2	p_eer
peke	10	59	2620	2	peke_
pekes	11	46	2356	2	pekes
per	5	63	5309	2	p__er
peter	7	44	2759	2	peter
pice	8	46	4109	2	pice_
picked	15	44	2131	2	picked
pickeer	15	37	1011	2	pickeer
pickers	15	37	1809	2	pickers
picket	14	49	2431	2	picket
pickier	15	39	1297	2	pickier
pie	5	54	5740	2	pi_e_
piecer	10	52	1308	2	piecer
pied	7	50	3536	2	pi_ed
piers	7	59	2633	2	pi_ers
pies	6	69	4960	2	pi_es
pika	10	63	2295	2	pik_a
pikas	11	42	1809	2	pikas
piki	10	65	2056	2	pik_i
pikis	11	51	1639	2	pikis
pilar	7	52	2150	2	pilar
pile	6	56	4969	2	pile_
pilea	7	51	2395	2	pilea
piled	8	52	3299	2	piled
pilei	7	40	2178	2	pilei
piles	7	47	4261	2	piles
pilfer	11	3	916	2	pilfer
pincer	10	40	1917	2	pincer
pinder	9	45	2345	2	pinder
pine	6	77	5571	2	pine_
pined	8	59	3532	2	pined
pinery	11	52	1428	2	pinery
pines	7	60	4886	2	pines
piney	10	57	2750	2	piney
pinger	9	43	2408	2	pinger
pinier	8	40	2469	2	pinier
pinked	13	48	1988	2	pinked
pinken	12	45	1328	2	pinken
pinkers	13	41	1860	2	pinkers
pinkey	15	43	1467	2	pinkey
pinner	8	45	2149	2	pinner
pipe	8	64	3443	2	pipe_
piped	10	51	2316	2	piped
pipers	10	43	1866	2	pipers
pipes	9	60	3014	2	pipes
pipet	9	55	3332	2	pipet
pipier	10	49	1398	2	pipier
pisher	11	43	1775	2	pisher
pisser	8	44	1638	2	pisser
pitier	8	40	1982	2	pitier
pixel	14	39	1190	2	pixel
pixes	14	43	2317	2	pixes
plier	7	52	2128	2	plier
plinker	13	40	1096	2	plinker
plyer	10	62	1433	2	plyer
poiser	8	42	1724	2	poiser
poke	10	53	3536	2	poke_
poked	12	54	2539	2	poked
pokers	12	46	1792	2	pokers
pokes	11	61	3301	2	pokes
pokey	14	53	1897	2	pokey
pokier	12	49	1463	2	pokier
poler	7	44	3179	2	poler
porker	12	49	1754	2	porker
poser	7	51	2877	2	poser
power	10	53	2595	2	power
pricer	10	39	1829	2	pricer
pricker	15	40	1341	2	pricker
prier	7	50	2776	2	prier
primer	10	51	1868	2	primer
prinker	13	34	1274	2	prinker
prizer	17	47	1488	2	prizer
pryer	10	44	1531	2	pryer
pucker	14	38	1763	2	pucker
puke	10	50	2546	2	puke_
puked	12	47	1622	2	puked
pukes	11	45	2302	2	pukes
puler	7	48	2662	2	puler
punker	12	37	1882	2	punker
purer	7	51	2790	2	purer
raker	9	45	2979	2	raker
ricer	7	47	2661	2	ricer
rider	6	52	3130	2	rider
rifer	8	47	2198	2	rifer
rimer	7	54	2924	2	rimer
riper	7	43	2840	2	riper
riser	5	54	3105	2	riser
risker	10	54	1449	2	risker
river	8	57	3169	2	river
saker	9	51	3202	2	saker
sicker	12	40	2390	2	sicker
sike	8	71	3878	2	sike_
sikes	9	62	3608	2	sikes
sinker	10	36	2090	2	sinker
siver	8	57	2861	2	siver
sizer	14	55	2181	2	sizer
skier	9	51	1959	2	skier
spicer	10	47	1931	2	spicer
spider	9	45	1680	2	spider
spier	7	57	2803	2	spi_er
spike	11	49	2284	2	spike_
spiked	13	49	1555	2	spiked
spikers	13	53	1199	2	spikers
spikes	12	45	2071	2	spikes
spikey	15	54	1133	2	spikey
spikier	13	36	998	2	spikier
taker	9	52	2900	2	taker
ticker	12	43	2150	2	ticker
tier	4	49	3614	2	ti_er
tiger	6	57	1863	2	tiger
tike	8	55	3448	2	tike_
tikes	9	56	2890	2	tikes
tiler	5	61	3102	2	tiler
timer	7	56	2604	2	timer
tinker	10	36	1992	2	tinker
titer	5	54	3061	2	titer
toker	9	59	2491	2	toker
vier	7	54	2815	2	vi_er
viler	8	63	2416	2	viler
viper	10	50	1730	2	viper
waker	12	55	2659	2	waker
wicker	15	45	1867	2	wicker
wider	9	48	2635	2	wider
winker	13	42	2029	2	winker
wiper	10	54	2129	2	wiper
wirer	8	51	2495	2	wirer
wiser	8	55	2280	2	wiser
wiver	11	59	2451	2	wiver
yikes	12	51	1775	2	yikes

Search took 6 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.266	671770.7
2	DLD Change Limit	53800	251	4.296	12523.3
3	Display Results	251	251	0.140	1792.9
	(SQL Overall)	178691	251	4.702	38003.2