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

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

398 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
pied	7	50	3536	(None)
died	6	61	3785	1	died
gied	6	46	3198	1	gied
hied	8	54	3404	1	hied
lied	5	58	3809	1	lied
ped	6	67	5152	1	p_ed
peed	7	62	3918	1	peed
pie	5	54	5740	1	pie_
pier	6	60	3529	1	pier
pies	6	69	4960	1	pies
piked	12	56	2331	1	piked
piled	8	52	3299	1	piled
pined	8	59	3532	1	pined
piped	10	51	2316	1	piped
pled	7	52	3143	1	pled
plied	8	51	1859	1	plied
pried	8	44	2686	1	pried
spied	8	54	2771	1	spied
tied	5	55	3521	1	tied
vied	8	63	2863	1	vied
abed	7	97	3413	2	abed
aced	7	95	4088	2	aced
aged	6	73	3425	2	aged
ahed	8	95	3625	2	ahed
aid	4	92	6907	2	ai_d
aide	5	60	4499	2	aide
aided	7	58	2893	2	aided
ailed	6	62	4028	2	ailed
aimed	8	56	2605	2	aimed
aired	6	60	3292	2	aired
aped	7	85	3815	2	aped
awed	8	84	3603	2	awed
axed	12	88	2961	2	axed
bed	6	79	5062	2	_bed
bid	6	77	5178	2	bi_d
bide	7	60	4147	2	bide
bided	9	54	2496	2	bided
bield	8	46	1465	2	bield
bier	6	55	3182	2	bier
biked	12	53	2003	2	biked
bind	7	62	3450	2	bind
biped	10	47	1883	2	biped
bird	7	61	2831	2	bird
bled	7	57	2931	2	bled
bred	7	51	3097	2	bred
cited	8	44	2195	2	cited
coed	7	71	4054	2	coed
copied	11	46	1856	2	copied
cred	7	65	3088	2	cred
cried	8	46	2428	2	cried
cued	7	63	2956	2	cued
deed	6	53	4090	2	deed
diced	9	58	2468	2	diced
did	5	68	5051	2	di_d
die	4	67	5965	2	die_
diel	5	90	3460	2	diel
dies	5	56	5352	2	dies
diet	5	73	5753	2	diet
diked	11	50	2468	2	diked
dined	7	64	3199	2	dined
dived	10	63	2137	2	dived
dried	7	53	2138	2	dried
dyed	9	67	2076	2	dyed
ed	3	86	4518	2	__ed
eide	5	58	3223	2	eide
eked	9	67	1802	2	eked
espied	9	35	977	2	espied
exed	12	54	2059	2	exed
eyed	8	66	2323	2	eyed
fed	7	65	4835	2	_fed
feed	8	45	3890	2	feed
fid	7	68	4768	2	fi_d
fie	6	71	5244	2	fie_
fief	10	73	3135	2	fief
field	9	50	1532	2	field
fiend	9	53	1298	2	fiend
fifed	12	51	1597	2	fifed
filed	9	53	3190	2	filed
find	8	75	3260	2	find
fined	9	49	3050	2	fined
fired	9	48	2974	2	fired
fixed	16	54	1695	2	fixed
fled	8	54	2977	2	fled
flied	9	65	1943	2	flied
fried	9	53	2291	2	fried
gaed	6	60	3151	2	gaed
ged	5	70	4453	2	_ged
geed	6	54	3550	2	geed
gibed	9	62	1596	2	gibed
gid	5	70	4726	2	gi_d
gie	4	71	4954	2	gie_
gien	5	63	3002	2	gien
gies	5	56	4142	2	gies
gild	6	55	2651	2	gild
gird	6	54	2499	2	gird
gled	6	56	3114	2	gled
haed	8	63	3858	2	haed
heed	8	64	3760	2	heed
hid	7	62	4836	2	hi_d
hide	8	51	3462	2	hide
hided	10	52	2244	2	hided
hie	6	76	5270	2	hie_
hies	7	48	4283	2	hies
hiked	13	59	1920	2	hiked
hind	8	55	2975	2	hind
hired	9	52	2626	2	hired
hived	12	52	1791	2	hived
hoed	8	78	3798	2	hoed
hued	8	69	2585	2	hued
iced	7	87	2189	2	iced
id	3	89	4183	2	_i_d
ired	5	51	3187	2	ired
ivied	9	47	1051	2	ivied
jeed	12	54	2850	2	jeed
jibed	15	51	1416	2	jibed
jived	16	51	1504	2	jived
kid	8	65	4061	2	ki_d
kief	11	71	2839	2	kief
kier	8	65	2680	2	kier
kind	9	61	2855	2	kind
kited	10	51	2009	2	kited
led	4	62	5455	2	_led
lid	4	74	5351	2	li_d
lie	3	82	6452	2	lie_
lief	7	60	3698	2	lief
lien	4	53	3980	2	lien
lier	4	59	4246	2	lier
lies	4	64	5419	2	lies
lieu	4	65	3436	2	lieu
liked	10	45	2381	2	liked
limed	8	54	2680	2	limed
lined	6	49	3464	2	lined
lived	9	55	2372	2	lived
med	6	61	4674	2	_med
meed	7	49	3470	2	meed
mid	6	73	5445	2	mi_d
mien	6	50	2835	2	mien
miked	12	50	2045	2	miked
mild	7	53	3084	2	mild
mimed	10	56	2273	2	mimed
mind	7	54	3436	2	mind
mined	8	53	3335	2	mined
mired	8	57	2922	2	mired
mixed	15	57	1725	2	mixed
need	5	49	3415	2	need
nide	5	55	3578	2	nide
nided	7	59	2087	2	nided
nixed	13	57	1422	2	nixed
ohed	8	78	2518	2	ohed
oiled	6	44	2947	2	oiled
oped	7	62	3015	2	oped
opined	9	51	1385	2	opined
opted	8	49	1427	2	opted
owed	8	68	3387	2	owed
paced	10	69	3168	2	paced
pad	6	80	5732	2	p_ad
paged	9	59	2678	2	paged
paid	7	57	3748	2	paid
paiked	13	51	1343	2	paiked
pained	9	56	2285	2	pained
paired	9	50	1752	2	paired
paled	8	55	3872	2	paled
paned	8	54	3718	2	paned
pard	7	64	4132	2	pard
pared	8	69	4676	2	pared
pated	8	52	3784	2	pated
paved	11	55	2526	2	paved
pawed	11	57	2561	2	pawed
payed	11	59	2593	2	payed
pe	4	76	4903	2	p_e_
pea	5	66	5724	2	p_ea
pec	7	67	4441	2	p_ec
peds	7	58	3524	2	p_eds
pee	5	60	6651	2	p_ee
peek	10	60	3143	2	peek
peel	6	55	3561	2	peel
peen	6	59	3808	2	peen
peep	8	58	3369	2	peep
peer	6	62	3835	2	peer
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
peined	9	49	1884	2	peined
peised	9	48	1768	2	peised
pen	5	65	5884	2	p_en
pend	7	59	3453	2	pend
pep	7	64	4708	2	p_ep
per	5	63	5309	2	p_er
pes	5	72	5978	2	p_es
pet	5	64	7730	2	p_et
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
picked	15	44	2131	2	picked
pics	8	56	3391	2	pics
piece	9	67	1799	2	piece
pieced	11	39	1210	2	pieced
piers	7	59	2633	2	piers
pieta	7	54	2175	2	pieta
piety	10	58	1730	2	piety
pig	6	57	4497	2	pi_g
pigged	11	42	1415	2	pigged
pigs	7	66	3422	2	pigs
pika	10	63	2295	2	pika
pike	10	63	3521	2	pike
piker	11	56	2284	2	piker
pikes	11	50	3103	2	pikes
piki	10	65	2056	2	piki
pile	6	56	4969	2	pile
pilea	7	51	2395	2	pilea
pilei	7	40	2178	2	pilei
piles	7	47	4261	2	piles
pili	6	61	3035	2	pili
pill	6	53	3946	2	pill
pilled	9	42	2275	2	pilled
pily	9	61	3273	2	pily
pima	8	54	2865	2	pima
pimp	10	60	2490	2	pimp
pimped	13	49	1348	2	pimped
pin	5	70	6672	2	pi_n
pina	6	58	4263	2	pina
pine	6	77	5571	2	pine
pines	7	60	4886	2	pines
piney	10	57	2750	2	piney
ping	7	59	4359	2	ping
pinged	10	43	2138	2	pinged
pink	10	70	3938	2	pink
pinked	13	48	1988	2	pinked
pinned	9	48	1838	2	pinned
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
piper	9	65	2319	2	piper
pipes	9	60	3014	2	pipes
pipet	9	55	3332	2	pipet
pipped	10	45	1654	2	pipped
pips	8	58	3713	2	pips
pipy	11	54	2151	2	pipy
piqued	18	3	621	2	piqued
pirn	6	71	2837	2	pirn
pis	5	63	6203	2	pi_s
pish	9	61	2791	2	pish
pished	12	48	1706	2	pished
piso	6	67	2756	2	piso
piss	6	50	3333	2	piss
pissed	9	48	1693	2	pissed
pit	5	64	7192	2	pi_t
pita	6	54	3643	2	pita
pith	9	54	3269	2	pith
pithed	12	46	1561	2	pithed
pitied	9	40	1725	2	pitied
pits	6	63	4874	2	pits
pitted	9	43	1959	2	pitted
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
plead	8	58	1846	2	plead
pleb	8	61	2381	2	pleb
plew	9	72	2281	2	plew
plex	13	73	2137	2	plex
plie	6	51	2739	2	plie_
plier	7	52	2128	2	plier
plies	7	45	2651	2	plies
plod	7	67	2327	2	plod
pod	6	63	5148	2	p_od
poem	8	62	2577	2	poem
poet	6	55	5290	2	poet
poind	8	42	1791	2	poind
poised	9	49	1847	2	poised
poked	12	54	2539	2	poked
poled	8	49	3484	2	poled
pond	7	55	3049	2	pond
ponied	9	49	2070	2	ponied
pood	7	59	3432	2	pood
pooed	8	52	2624	2	pooed
pored	8	52	3451	2	pored
posed	8	58	2841	2	posed
poxed	15	48	1786	2	poxed
pree	6	70	4473	2	pree
preed	8	51	2811	2	preed
prep	8	64	2767	2	prep
prex	13	57	2297	2	prex
prey	9	62	2848	2	prey
prez	15	61	2631	2	prez
priced	11	50	1888	2	priced
pride	8	47	2473	2	pride
prided	10	36	1803	2	prided
prier	7	50	2776	2	prier
pries	7	43	3953	2	pries
primed	11	51	1891	2	primed
prised	9	43	2220	2	prised
prized	18	44	1539	2	prized
prod	7	61	2950	2	prod
pseud	8	6	704	2	pseud
pud	6	58	3665	2	p_ud
puked	12	47	1622	2	puked
puled	8	49	2652	2	puled
pye	8	64	3250	2	pye_
pyes	9	55	2899	2	pyes
red	4	67	5580	2	_red
reed	5	55	4962	2	reed
riced	8	58	2554	2	riced
rid	4	67	5462	2	ri_d
ride	5	59	4512	2	ride
riel	4	64	3238	2	riel
riled	6	58	3325	2	riled
rimed	8	48	2637	2	rimed
rind	5	65	3560	2	rind
riped	8	52	2643	2	riped
rived	9	48	2561	2	rived
rued	5	57	2979	2	rued
seed	5	55	4948	2	seed
shed	8	65	3615	2	shed
shied	9	61	2549	2	shied
side	5	54	4448	2	side
sided	7	48	2595	2	sided
sild	5	50	3058	2	sild
siped	8	49	2768	2	siped
sired	6	61	3428	2	sired
sited	6	51	3074	2	sited
sized	15	55	1924	2	sized
skied	10	44	1775	2	skied
sled	5	53	3437	2	sled
sned	5	60	2605	2	sned
spaed	8	55	2227	2	spaed
sped	7	60	3149	2	sped
speed	8	55	2662	2	speed
spiced	11	52	1831	2	spiced
spiel	7	46	2391	2	spiel
spier	7	57	2803	2	spier
spies	7	60	3762	2	spies
spiked	13	49	1555	2	spiked
spiled	9	46	2199	2	spiled
spined	9	54	2394	2	spined
spired	9	49	2186	2	spired
spited	9	48	2044	2	spited
spued	8	49	1847	2	spued
stied	6	57	2303	2	stied
sued	5	65	3793	2	sued
ted	4	64	4656	2	_ted
teed	5	54	3926	2	teed
tide	5	52	3737	2	tide
tided	7	63	2251	2	tided
tie	3	65	5753	2	tie_
tier	4	49	3614	2	tier
ties	4	52	4831	2	ties
tiled	6	48	3294	2	tiled
timed	8	52	2361	2	timed
tined	6	54	3453	2	tined
tired	6	52	2890	2	tired
toed	5	61	3704	2	toed
tried	6	50	2691	2	tried
upped	10	37	1516	2	upped
used	5	57	2282	2	used
viced	11	51	1818	2	viced
vid	7	72	4180	2	vi_d
vide	8	54	3275	2	vide
vie	6	54	4763	2	vie_
vier	7	54	2815	2	vier
vies	7	52	3862	2	vies
view	10	59	1767	2	view
vined	9	56	2615	2	vined
vised	9	55	1876	2	vised
wed	7	58	4362	2	_wed
weed	8	56	3751	2	weed
wide	8	52	3540	2	wide
wield	9	52	1391	2	wield
wifed	12	51	1774	2	wifed
wild	8	51	2651	2	wild
wiled	9	52	3155	2	wiled
wind	8	55	3385	2	wind
wined	9	44	3418	2	wined
wiped	11	47	2208	2	wiped
wired	9	53	2764	2	wired
wised	9	51	2334	2	wised
wited	9	47	2714	2	wited
wived	12	51	2150	2	wived
wried	9	55	1856	2	wried
yid	7	66	4082	2	yi_d
yield	9	51	969	2	yield
yird	8	70	1898	2	yird
zed	13	54	3117	2	_zed

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.080	2233637.5
2	DLD Change Limit	29872	398	1.216	24565.8
3	Display Results	398	398	0.093	4279.6
	(SQL Overall)	178691	398	1.389	128647.2