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

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

454 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
pile	6	56	4969	(None)
bile	6	61	4717	1	bile
file	7	54	4664	1	file
mile	6	63	5256	1	mile
pale	6	60	5501	1	pale
pele	6	55	3955	1	pele
pice	8	46	4109	1	pice
pie	5	54	5740	1	pi_e
pike	10	63	3521	1	pike
pilea	7	51	2395	1	pilea
piled	8	52	3299	1	piled
pilei	7	40	2178	1	pilei
piles	7	47	4261	1	piles
pili	6	61	3035	1	pili
pill	6	53	3946	1	pill
pily	9	61	3273	1	pily
pine	6	77	5571	1	pine
pipe	8	64	3443	1	pipe
plie	6	51	2739	1	plie
pole	6	59	5130	1	pole
pule	6	50	4095	1	pule
rile	4	56	5053	1	rile
spile	7	52	3008	1	spile
tile	4	54	5144	1	tile
vile	7	61	3980	1	vile
wile	7	59	4437	1	wile
able	6	63	4053	2	able
agile	6	51	2226	2	agile
aide	5	60	4499	2	aide
ail	3	71	7104	2	ail_
ailed	6	62	4028	2	ailed
ails	4	56	5471	2	ails
aisle	5	52	2319	2	aisle
ale	3	65	7234	2	_ale
anile	5	46	3446	2	anile
apple	9	45	1767	2	apple
axile	12	60	2051	2	axile
axle	11	64	2460	2	axle
bale	6	63	5384	2	bale
bible	9	51	1941	2	bible
bice	8	62	3555	2	bice
bide	7	60	4147	2	bide
bike	10	65	3259	2	bike
biles	7	55	4214	2	biles
bilge	8	76	1891	2	bilge
bilk	10	58	2441	2	bilk
bill	6	72	3993	2	bill
bine	6	66	5085	2	bine
birle	7	50	2363	2	birle
bise	6	64	3709	2	bise
bite	6	65	4699	2	bite
bize	15	59	2628	2	bize
bole	6	64	4869	2	bole
chile	10	56	2689	2	chile
cine	6	62	4294	2	cine
cire	6	58	3637	2	cire
cite	6	56	4034	2	cite
cole	6	69	5611	2	cole
dale	5	56	4398	2	dale
dele	5	68	4308	2	dele
dice	7	58	4189	2	dice
die	4	67	5965	2	di_e
diel	5	90	3460	2	diel
dike	9	59	3576	2	dike
dill	5	52	3997	2	dill
dime	7	62	3764	2	dime
dine	5	55	5533	2	dine
dire	5	66	4414	2	dire
dite	5	55	4755	2	dite
dive	8	56	3477	2	dive
dole	5	65	5000	2	dole
edile	6	48	1949	2	edile
eide	5	58	3223	2	eide
exile	12	61	1765	2	exile
fice	9	57	3711	2	fice
fie	6	71	5244	2	fi_e
fife	10	60	2770	2	fife
fil	6	54	4714	2	fil_
fila	7	47	2913	2	fila
filed	9	53	3190	2	filed
filer	8	54	3300	2	filer
files	8	54	4127	2	files
filet	8	55	4016	2	filet
fill	7	55	4019	2	fill
fille	8	43	2740	2	fille
film	9	48	2817	2	film
filo	7	60	3428	2	filo
fils	7	58	3869	2	fils
fine	7	51	4795	2	fine
fire	7	62	4559	2	fire
five	10	76	2974	2	five
gale	5	63	4732	2	gale
gibe	7	59	2777	2	gibe
gie	4	71	4954	2	gi_e
gild	6	55	2651	2	gild
gill	5	63	3618	2	gill
gilt	5	63	4854	2	gilt
gite	5	54	3861	2	gite
give	8	58	2935	2	give
guile	6	45	2113	2	guile
hale	7	60	5283	2	hale
hide	8	51	3462	2	hide
hie	6	76	5270	2	hi_e
hike	11	68	3039	2	hike
hila	7	62	2835	2	hila
hili	7	56	2663	2	hili
hill	7	64	3949	2	hill
hilt	7	58	5071	2	hilt
hire	7	55	3896	2	hire
hive	10	60	2967	2	hive
hole	7	75	5339	2	hole
ice	5	67	3724	2	_ice
idle	5	54	2376	2	idle
ilea	4	59	3146	2	_ilea
ilex	11	58	2203	2	_ilex
ilk	7	83	2530	2	_ilk
ill	3	74	3709	2	_ill
ire	3	69	4317	2	_ire
isle	4	51	2170	2	isle
jibe	13	63	2338	2	jibe
jill	11	64	3026	2	jill
jilt	11	58	3942	2	jilt
jive	14	61	2359	2	jive
jole	11	72	3382	2	jole
kale	8	65	3375	2	kale
kibe	10	65	2343	2	kibe
kike	7	65	2478	2	kike
kill	8	55	3317	2	kill
kiln	8	56	2097	2	kiln
kilo	8	60	2866	2	kilo
kilt	8	61	4441	2	kilt
kine	8	56	4342	2	kine
kite	8	53	3823	2	kite
lice	6	60	4506	2	lice
lie	3	82	6452	2	li_e
life	7	54	3373	2	life
like	8	60	4084	2	like
lilo	4	67	3156	2	lilo
lilt	4	63	4994	2	lilt
lily	7	67	3018	2	lily
lime	6	62	4493	2	lime
line	4	69	6557	2	line
lipe	6	68	3973	2	lipe
lire	4	78	4529	2	lire
lisle	5	39	1672	2	lisle
lite	4	70	5454	2	lite
live	7	65	4099	2	live
maile	7	52	3221	2	maile
male	6	60	5229	2	male
mice	8	74	4222	2	mice
mike	10	55	3528	2	mike
mil	5	57	5210	2	mil_
mild	7	53	3084	2	mild
miler	7	57	3306	2	miler
miles	7	46	4507	2	miles
milk	10	50	2846	2	milk
mill	6	65	4147	2	mill
mille	7	50	2913	2	mille
milo	6	55	3609	2	milo
mils	6	60	4532	2	mils
milt	6	54	5580	2	milt
mime	8	57	3639	2	mime
mine	6	72	5615	2	mine
mire	6	67	4822	2	mire
mise	6	60	4357	2	mise
mite	6	62	4940	2	mite
mole	6	62	5183	2	mole
mule	6	52	3697	2	mule
nice	6	55	3471	2	nice
nide	5	55	3578	2	nide
nil	3	61	4419	2	nil_
nill	4	56	3430	2	nill
nils	4	61	3245	2	nils
nine	4	58	4217	2	nine
nite	4	59	4358	2	nite
nixe	11	57	2202	2	nixe
ogle	5	63	2505	2	ogle
oil	3	74	5205	2	oil_
oiled	6	44	2947	2	oiled
oiler	5	46	2828	2	oiler
oils	4	63	3797	2	oils
oily	7	79	3225	2	oily
ole	3	71	5521	2	_ole
opine	7	74	2246	2	opine
orle	4	56	3046	2	orle
pace	8	63	4577	2	pace
padle	8	45	2234	2	padle
page	7	60	3610	2	page
pail	6	61	4183	2	pail_
pails	7	58	3306	2	pails
paise	7	50	2833	2	paise
pal	5	67	6167	2	pal_
palea	7	50	2866	2	palea
paled	8	55	3872	2	paled
paler	7	54	3693	2	paler
pales	7	57	5380	2	pales
palet	7	46	5080	2	palet
pall	6	50	3934	2	pall
palm	8	53	3136	2	palm
palp	8	58	2857	2	palp
pals	6	69	5135	2	pals
paly	9	58	3553	2	paly
pane	6	49	5028	2	pane
pare	6	67	6084	2	pare
parle	7	58	3616	2	parle
pase	6	53	4686	2	pase
pate	6	53	5046	2	pate
pave	9	61	3389	2	pave
pe	4	76	4903	2	p__e
pee	5	60	6651	2	p_ee
peel	6	55	3561	2	peel
peise	7	58	2577	2	peise
peke	10	59	2620	2	peke
peles	7	57	3808	2	peles
pelf	9	70	3145	2	pelf
pelt	6	76	5108	2	pelt
penile	8	22	1960	2	penile
pere	6	64	5026	2	pere
phyle	13	41	1115	2	phyle
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
pick	12	59	3381	2	pick
pickle	14	42	1565	2	pickle
pics	8	56	3391	2	pics
piddle	10	35	1491	2	piddle
piece	9	67	1799	2	piece
pied	7	50	3536	2	pied
pier	6	60	3529	2	pier
pies	6	69	4960	2	pies
piffle	14	41	823	2	piffle
pig	6	57	4497	2	pi_g
piglet	9	34	2092	2	piglet
pigs	7	66	3422	2	pigs
pika	10	63	2295	2	pika
piked	12	56	2331	2	piked
piker	11	56	2284	2	piker
pikes	11	50	3103	2	pikes
piki	10	65	2056	2	piki
pilaf	10	39	2348	2	pilaf
pilar	7	52	2150	2	pilar
pilau	7	36	1852	2	pilau
pilaw	10	39	1374	2	pilaw
pileum	10	39	951	2	pileum
pileup	10	43	792	2	pileup
pileus	8	45	1494	2	pileus
pilfer	11	3	916	2	pilfer
pilis	7	58	2520	2	pilis
pilled	9	42	2275	2	pilled
pills	7	41	3097	2	pills
pilose	8	45	1423	2	pilose
pilot	7	74	3506	2	pilot
pilule	8	4	1112	2	pilule
pilus	7	59	2106	2	pilus
pima	8	54	2865	2	pima
pimp	10	60	2490	2	pimp
pimple	12	35	1296	2	pimple
pin	5	70	6672	2	pi_n
pina	6	58	4263	2	pina
pined	8	59	3532	2	pined
pines	7	60	4886	2	pines
piney	10	57	2750	2	piney
ping	7	59	4359	2	ping
pink	10	70	3938	2	pink
pinole	8	32	1878	2	pinole
pins	6	55	5845	2	pins
pint	6	69	6317	2	pint
pintle	8	38	1826	2	pintle
piny	9	118	3835	2	piny
piolet	8	32	2564	2	piolet
pion	6	72	3529	2	pion
pip	7	80	5104	2	pi_p
piped	10	51	2316	2	piped
piper	9	65	2319	2	piper
pipes	9	60	3014	2	pipes
pipet	9	55	3332	2	pipet
pips	8	58	3713	2	pips
pipy	11	54	2151	2	pipy
pique	16	4	1017	2	pique
pirn	6	71	2837	2	pirn
pis	5	63	6203	2	pi_s
pish	9	61	2791	2	pish
piso	6	67	2756	2	piso
piss	6	50	3333	2	piss
piste	7	58	2460	2	piste
pit	5	64	7192	2	pi_t
pita	6	54	3643	2	pita
pith	9	54	3269	2	pith
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
pixie	14	54	1552	2	pixie
pixy	16	61	1776	2	pixy
pizzle	16	27	949	2	pizzle
plea	6	68	3060	2	p_lea
pleb	8	61	2381	2	p_leb
pled	7	52	3143	2	p_led
plew	9	72	2281	2	p_lew
plex	13	73	2137	2	p_lex
plied	8	51	1859	2	plied
plier	7	52	2128	2	plier
plies	7	45	2651	2	plies
ply	8	63	2355	2	p_ly
poilu	7	23	1600	2	poilu
poise	7	51	2789	2	poise
poke	10	53	3536	2	poke
pol	5	64	4938	2	pol_
poled	8	49	3484	2	poled
poler	7	44	3179	2	poler
poles	7	53	5100	2	poles
poll	6	63	3213	2	poll
polo	6	62	3663	2	polo
pols	6	60	4456	2	pols
poly	9	62	3515	2	poly
pome	8	56	3669	2	pome
pone	6	57	4753	2	pone
pope	8	55	3561	2	pope
pore	6	64	5126	2	pore
pose	6	64	4173	2	pose
pree	6	70	4473	2	pree
price	9	37	2541	2	price
pride	8	47	2473	2	pride
prill	7	41	1794	2	prill
prime	9	65	2560	2	prime
prise	7	46	3261	2	prise
prize	16	47	1894	2	prize
prole	7	45	2779	2	prole
puce	8	51	2788	2	puce
puke	10	50	2546	2	puke
pul	5	61	3806	2	pul_
pula	6	51	2937	2	pula
puled	8	49	2652	2	puled
puler	7	48	2662	2	puler
pules	7	45	3881	2	pules
puli	6	55	2762	2	puli
pull	6	47	3166	2	pull
pulp	8	48	2535	2	pulp
puls	6	54	3756	2	puls
pulse	7	42	1997	2	pulse
pure	6	55	4333	2	pure
pye	8	64	3250	2	p_ye
pyre	9	49	2555	2	pyre
rale	4	50	5056	2	rale
rice	6	49	4291	2	rice
ride	5	59	4512	2	ride
riel	4	64	3238	2	riel
rife	7	46	3232	2	rife
rifle	8	55	1833	2	rifle
riled	6	58	3325	2	riled
riles	5	53	4364	2	riles
riley	8	44	2058	2	riley
rill	4	51	4090	2	rill
rille	5	57	2873	2	rille
rime	6	51	3888	2	rime
ripe	6	60	3892	2	ripe
rise	4	59	4523	2	rise
rite	4	58	4945	2	rite
rive	7	55	3772	2	rive
role	4	58	5182	2	role
rule	4	99	3842	2	rule
sale	4	49	5970	2	sale
sice	6	55	4559	2	sice
side	5	54	4448	2	side
sidle	6	51	2403	2	sidle
sike	8	71	3878	2	sike
sild	5	50	3058	2	sild
silex	12	34	1741	2	silex
silk	8	55	2932	2	silk
sill	4	55	4515	2	sill
silo	4	60	3791	2	silo
silt	4	65	5819	2	silt
sine	4	65	6062	2	sine
sipe	6	73	4104	2	sipe
sire	4	61	5041	2	sire
site	4	70	5241	2	site
size	13	56	3096	2	size
smile	7	48	2391	2	smile
sole	4	60	5367	2	sole
spale	7	49	2921	2	spale
spice	9	55	2881	2	spice
spiel	7	46	2391	2	spiel
spike	11	49	2284	2	spike
spiled	9	46	2199	2	spiled
spiles	8	42	2791	2	spiles
spill	7	48	2116	2	spill
spilt	7	55	3222	2	spilt
spine	7	65	3442	2	spine
spire	7	58	2869	2	spire
spite	7	54	3066	2	spite
stile	5	49	3157	2	stile
tale	4	61	5416	2	tale
tele	4	50	4087	2	tele
tide	5	52	3737	2	tide
tie	3	65	5753	2	ti_e
tike	8	55	3448	2	tike
til	3	63	5026	2	til_
tilde	6	50	1734	2	tilde
tiled	6	48	3294	2	tiled
tiler	5	61	3102	2	tiler
tiles	5	55	4210	2	tiles
till	4	59	4120	2	till
tils	4	57	3961	2	tils
tilt	4	62	5242	2	tilt
time	6	62	3501	2	time
tine	4	58	5513	2	tine
tire	4	61	4335	2	tire
title	5	47	2107	2	title
toile	5	46	2649	2	toile
tole	4	60	5290	2	tole
tule	4	57	3587	2	tule
unpile	8	19	1432	2	unpile
uppile	10	17	850	2	uppile
utile	5	47	1893	2	utile
vale	7	49	3734	2	vale
vibe	9	51	2449	2	vibe
vice	9	57	3285	2	vice
vide	8	54	3275	2	vide
vie	6	54	4763	2	vi_e
viler	8	63	2416	2	viler
vill	7	52	3507	2	vill
vine	7	56	4368	2	vine
vise	7	56	3267	2	vise
vive	10	54	2662	2	vive
voile	8	47	1972	2	voile
vole	7	52	3698	2	vole
wale	7	45	4643	2	wale
while	11	54	1869	2	while
wide	8	52	3540	2	wide
wife	10	52	2802	2	wife
wild	8	51	2651	2	wild
wiled	9	52	3155	2	wiled
wiles	8	54	3787	2	wiles
will	7	57	3751	2	will
wilt	7	62	4629	2	wilt
wily	10	64	2881	2	wily
wine	7	49	5342	2	wine
wipe	9	48	3028	2	wipe
wire	7	58	3981	2	wire
wise	7	57	3734	2	wise
wite	7	54	4327	2	wite
wive	10	59	3175	2	wive
wyle	10	55	1938	2	wyle
yill	7	56	2897	2	yill
yipe	9	67	2217	2	yipe
yule	7	57	2514	2	yule
zill	13	57	2761	2	zill
zine	13	70	3615	2	zine

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.076	2351197.4
2	DLD Change Limit	29872	454	0.890	33564.0
3	Display Results	454	454	0.110	4127.3
	(SQL Overall)	178691	454	1.076	166069.7