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

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

380 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
pier	6	60	3529	(None)
bier	6	55	3183	1	bier
kier	8	65	2681	1	kier
lier	4	59	4246	1	lier
peer	6	62	3835	1	peer
per	5	63	5309	1	p_er
pie	5	54	5740	1	pie_
pied	7	50	3536	1	pied
piers	7	59	2633	1	piers
pies	6	69	4960	1	pies
piker	11	56	2284	1	piker
piper	9	65	2319	1	piper
plier	7	52	2128	1	plier
prier	7	50	2776	1	prier
spier	7	57	2803	1	spier
tier	4	49	3614	1	tier
vier	7	54	2815	1	vier
ager	5	59	3584	2	ager
aider	6	54	3113	2	aider
aimer	7	59	2682	2	aimer
air	3	80	5839	2	ai_r
airer	5	49	2789	2	airer
aiver	8	57	2516	2	aiver
aper	6	63	3623	2	aper
apter	7	61	2020	2	apter
aver	7	59	3188	2	aver
beer	6	56	3599	2	beer
bider	8	57	2837	2	bider
biers	7	62	2522	2	biers
biker	11	60	2256	2	biker
biner	7	59	3069	2	biner
birr	6	60	2236	2	birr
biter	7	50	3003	2	biter
brier	7	45	2740	2	brier
cider	8	47	2331	2	cider
cire	6	58	3637	2	cire
citer	7	48	2733	2	citer
copier	10	37	2289	2	copier
crier	7	47	2446	2	crier
deer	5	67	3902	2	deer
dicer	8	54	2642	2	dicer
die	4	67	5965	2	die_
died	6	61	3785	2	died
diel	5	90	3460	2	diel
dies	5	56	5352	2	dies
diet	5	73	5753	2	diet
diker	10	55	2455	2	diker
dimer	8	56	2560	2	dimer
diner	6	56	3290	2	diner
dire	5	66	4414	2	dire
direr	6	49	2707	2	direr
diver	9	48	2780	2	diver
doer	5	77	3470	2	doer
dopier	9	35	1592	2	dopier
drier	6	44	2396	2	drier
dyer	8	55	2211	2	dyer
eger	5	59	2357	2	eger
eider	6	46	2474	2	eider
epimer	10	10	915	2	epimer
er	2	83	4514	2	__er
ever	7	70	2769	2	ever
ewer	7	75	2398	2	ewer
eyer	7	61	2728	2	eyer
fer	6	66	4612	2	_fer
fiar	7	64	2733	2	fiar
fiber	10	49	2113	2	fiber
fie	6	71	5244	2	fie_
fief	10	73	3136	2	fief
fiery	11	47	1479	2	fiery
fifer	11	55	1997	2	fifer
filer	8	54	3300	2	filer
finer	8	54	3156	2	finer
fir	6	67	4489	2	fi_r
fire	7	62	4559	2	fire
firer	8	112	2925	2	firer
fiver	11	60	2494	2	fiver
fixer	15	47	1783	2	fixer
flier	8	60	2340	2	flier
frier	8	52	2584	2	frier
giber	8	54	1770	2	giber
gie	4	71	4954	2	gie_
gied	6	46	3198	2	gied
gien	5	63	3002	2	gien
gies	5	56	4142	2	gies
giver	9	49	2120	2	giver
goer	5	68	2710	2	goer
heir	7	75	2380	2	heir
her	6	65	4781	2	_her
hider	9	50	2408	2	hider
hie	6	76	5270	2	hie_
hied	8	54	3404	2	hied
hies	7	48	4283	2	hies
hiker	12	51	1939	2	hiker
hire	7	55	3896	2	hire
hirer	8	54	2312	2	hirer
hoer	7	65	3398	2	hoer
icier	7	43	1375	2	icier
ire	3	69	4317	2	_ire
jeer	11	54	2646	2	jeer
jiber	14	51	1570	2	jiber
jiver	15	51	1905	2	jiver
keir	8	62	1787	2	keir
kief	11	71	2841	2	kief
kiers	9	53	2009	2	kiers
kir	7	65	3568	2	ki_r
kiter	9	55	2321	2	kiter
leer	4	62	3935	2	leer
liar	4	72	2968	2	liar
liber	7	47	2362	2	liber
lie	3	82	6452	2	lie_
lied	5	58	3809	2	lied
lief	7	60	3699	2	lief
lien	4	53	3980	2	lien
liers	5	51	3040	2	liers
lies	4	64	5419	2	lies
lieu	4	65	3436	2	lieu
lifer	8	58	2215	2	lifer
liger	6	50	2447	2	liger
liker	9	56	2706	2	liker
liner	5	59	3892	2	liner
lire	4	78	4529	2	lire
liter	5	47	3634	2	liter
liver	8	51	3296	2	liver
mien	6	50	2836	2	mien
miler	7	57	3306	2	miler
mimer	9	48	2576	2	mimer
miner	7	69	3354	2	miner
mir	5	70	4677	2	mi_r
mire	6	67	4823	2	mire
miser	7	54	3040	2	miser
miter	7	57	3479	2	miter
mixer	14	50	1764	2	mixer
mopier	10	39	1478	2	mopier
nicer	7	46	1829	2	nicer
niter	5	50	2897	2	niter
oiler	5	46	2828	2	oiler
omer	6	70	2839	2	omer
osier	5	35	1801	2	osier
over	7	72	2734	2	over
oyer	7	59	2765	2	oyer
pacer	9	61	3161	2	pacer
pacier	10	50	1868	2	pacier
pager	8	47	2820	2	pager
pair	6	60	3151	2	pair
paler	7	54	3693	2	paler
palier	8	50	2356	2	palier
panier	8	44	2550	2	panier
paper	9	51	2866	2	paper
par	5	74	6702	2	p_ar
pare	6	67	6084	2	pare
parer	7	58	3990	2	parer
parr	6	57	3115	2	parr
pater	7	47	4072	2	pater
paver	10	42	2583	2	paver
pawer	10	44	2297	2	pawer
payer	10	51	2572	2	payer
pe	4	76	4903	2	p_e_
pea	5	66	5724	2	p_ea
pear	6	97	4523	2	pear
pec	7	67	4441	2	p_ec
ped	6	67	5152	2	p_ed
pee	5	60	6651	2	p_ee
peed	7	62	3918	2	peed
peek	10	60	3143	2	peek
peel	6	55	3561	2	peel
peen	6	59	3808	2	peen
peep	8	58	3369	2	peep
peers	7	51	3027	2	peers
peery	10	57	1944	2	peery
pees	6	52	5737	2	pees
peg	6	58	4306	2	p_eg
peh	8	67	4096	2	p_eh
pein	6	58	3494	2	pein
pen	5	65	5884	2	p_en
pep	7	64	4708	2	p_ep
pere	6	64	5026	2	p_ere
peri	6	56	3697	2	p_eri
perk	10	62	3284	2	p_erk
perm	8	58	3463	2	p_erm
perp	8	90	2989	2	p_erp
pert	6	67	5932	2	p_ert
perv	9	72	2481	2	p_erv
pes	5	72	5978	2	p_es
pet	5	64	7730	2	p_et
peter	7	44	2759	2	peter
pew	8	64	4230	2	p_ew
phew	12	84	1711	2	phew
pi	4	81	4536	2	pi__
pia	5	68	4803	2	pi_a
pial	6	56	3670	2	pial
pian	6	61	3609	2	pian
pias	6	65	4255	2	pias
pic	7	60	4682	2	pi_c
pica	8	58	3149	2	pica
pice	8	46	4109	2	pice
pick	12	59	3381	2	pick
picker	14	44	2217	2	picker
pics	8	56	3391	2	pics
piece	9	67	1799	2	piece
piecer	10	52	1308	2	piecer
pierce	10	40	1039	2	pierce
pieta	7	54	2175	2	pieta
piety	10	58	1730	2	piety
pig	6	57	4497	2	pi_g
pigs	7	66	3422	2	pigs
pika	10	63	2295	2	pika
pike	10	63	3521	2	pike
piked	12	56	2331	2	piked
pikers	12	47	1739	2	pikers
pikes	11	50	3103	2	pikes
piki	10	65	2056	2	piki
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
pili	6	61	3035	2	pili
pill	6	53	3946	2	pill
pily	9	61	3273	2	pily
pima	8	54	2865	2	pima
pimp	10	60	2490	2	pimp
pin	5	70	6672	2	pi_n
pina	6	58	4263	2	pina
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	1429	2	pinery
pines	7	60	4886	2	pines
piney	10	57	2750	2	piney
ping	7	59	4359	2	ping
pinger	9	43	2409	2	pinger
pinier	8	40	2469	2	pinier
pink	10	70	3938	2	pink
pinker	12	53	2244	2	pinker
pinner	8	45	2150	2	pinner
pins	6	55	5845	2	pins
pint	6	69	6317	2	pint
piny	9	118	3835	2	piny
pion	6	72	3529	2	pion
pip	7	80	5104	2	pi_p
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
pips	8	58	3713	2	pips
pipy	11	54	2151	2	pipy
pirn	6	71	2837	2	pirn
pis	5	63	6203	2	pi_s
pish	9	61	2791	2	pish
pisher	11	43	1775	2	pisher
piso	6	67	2756	2	piso
piss	6	50	3333	2	piss
pisser	8	44	1638	2	pisser
pit	5	64	7192	2	pi_t
pita	6	54	3643	2	pita
pith	9	54	3269	2	pith
pitier	8	40	1982	2	pitier
pits	6	63	4874	2	pits
pity	9	60	3193	2	pity
piu	5	66	3954	2	pi_u
pix	12	64	3793	2	pi_x
pixel	14	39	1190	2	pixel
pixes	14	43	2317	2	pixes
pixy	16	61	1776	2	pixy
plea	6	68	3060	2	plea
pleb	8	61	2381	2	pleb
pled	7	52	3143	2	pled
plew	9	72	2281	2	plew
plex	13	73	2137	2	plex
plie	6	51	2739	2	plie_
plied	8	51	1859	2	plied
pliers	8	47	1515	2	pliers
plies	7	45	2651	2	plies
plyer	10	62	1433	2	plyer
poem	8	62	2577	2	poem
poet	6	55	5290	2	poet
poiser	8	42	1724	2	poiser
poker	11	51	2288	2	poker
pokier	12	49	1463	2	pokier
poler	7	44	3179	2	poler
poor	6	56	3022	2	poor
pore	6	64	5126	2	pore
poser	7	51	2877	2	poser
pour	6	115	2747	2	pour
power	10	53	2595	2	power
poxier	15	38	1211	2	poxier
pree	6	70	4473	2	pree
prep	8	64	2767	2	prep
prex	13	57	2297	2	prex
prey	9	62	2848	2	prey
prez	15	61	2631	2	prez
pricer	10	39	1829	2	pricer
pried	8	44	2686	2	pried
priers	8	45	2119	2	priers
pries	7	43	3953	2	pries
primer	10	51	1868	2	primer
prior	7	43	1617	2	prior
prizer	17	47	1488	2	prizer
pryer	10	44	1531	2	pryer
puler	7	48	2662	2	puler
punier	8	45	1922	2	punier
pur	5	68	4055	2	p_ur
pure	6	55	4333	2	pure
purer	7	51	2790	2	purer
purr	6	49	2581	2	purr
pye	8	64	3250	2	pye_
pyes	9	55	2899	2	pyes
pyre	9	49	2555	2	pyre
rapier	8	40	1999	2	rapier
ricer	7	47	2661	2	ricer
rider	6	52	3130	2	rider
riel	4	64	3238	2	riel
rifer	8	47	2198	2	rifer
rimer	7	54	2924	2	rimer
riper	7	43	2840	2	riper
riser	5	54	3105	2	riser
river	8	57	3169	2	river
ropier	8	41	1880	2	ropier
ruer	4	61	2756	2	ruer
seer	4	55	4704	2	seer
ser	3	67	5240	2	_ser
shier	8	54	2894	2	shier
sieur	5	9	1189	2	sieur
siker	9	53	2603	2	siker
sir	3	57	4667	2	si_r
sire	4	61	5041	2	sire
siver	8	57	2861	2	siver
sizer	14	55	2181	2	sizer
skier	9	51	1959	2	skier
slier	5	48	2724	2	slier
speer	7	46	2390	2	speer
speir	7	53	1536	2	speir
spicer	10	47	1931	2	spicer
spider	9	45	1680	2	spider
spied	8	54	2771	2	spied
spiel	7	46	2391	2	spiel
spiers	8	44	2174	2	spiers
spies	7	60	3762	2	spies
spiker	12	43	1566	2	spiker
spire	7	58	2869	2	spire
sprier	8	41	1906	2	sprier
suer	4	53	3403	2	suer
tie	3	65	5753	2	tie_
tied	5	55	3521	2	tied
tiers	5	55	2652	2	tiers
ties	4	52	4831	2	ties
tiger	6	57	1863	2	tiger
tiler	5	61	3102	2	tiler
timer	7	56	2604	2	timer
tire	4	61	4335	2	tire
titer	5	54	3061	2	titer
trier	5	43	2853	2	trier
twier	8	47	1329	2	twier
tyer	7	53	2339	2	tyer
typier	11	3	733	2	typier
upper	9	37	1426	2	upper
user	4	50	2300	2	user
veer	7	62	2957	2	veer
vie	6	54	4763	2	vie_
vied	8	63	2863	2	vied
viers	8	56	2195	2	viers
vies	7	52	3862	2	vies
view	10	59	1767	2	view
viler	8	63	2416	2	viler
viper	10	50	1730	2	viper
weer	7	55	3509	2	weer
weir	7	60	1992	2	weir
wider	9	48	2635	2	wider
wiper	10	54	2129	2	wiper
wire	7	58	3981	2	wire
wirer	8	51	2495	2	wirer
wiser	8	55	2280	2	wiser
wiver	11	59	2451	2	wiver
wrier	8	45	2175	2	wrier
yirr	7	65	1357	2	yirr

Search took 2 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	29872	0.296	603685.8
2	DLD Change Limit	29872	380	0.890	33564.0
3	Display Results	380	380	0.110	3454.5
	(SQL Overall)	178691	380	1.296	137878.9