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

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

531 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
pine	6	77	5571	(None)
bine	6	66	5085	1	bine
cine	6	62	4294	1	cine
dine	5	55	5533	1	dine
fine	7	51	4795	1	fine
kine	8	56	4342	1	kine
line	4	69	6557	1	line
mine	6	72	5615	1	mine
nine	4	58	4217	1	nine
opine	7	74	2246	1	opine
pane	6	49	5028	1	pane
pice	8	46	4109	1	pice
pie	5	54	5740	1	pi_e
pike	10	63	3521	1	pike
pile	6	56	4969	1	pile
pin	5	70	6672	1	pin_
pina	6	58	4263	1	pina
pined	8	59	3532	1	pined
pines	7	60	4886	1	pines
piney	10	57	2750	1	piney
ping	7	59	4359	1	ping
pink	10	70	3938	1	pink
pins	6	55	5845	1	pins
pint	6	69	6317	1	pint
piny	9	118	3835	1	piny
pipe	8	64	3443	1	pipe
pone	6	57	4753	1	pone
sine	4	65	6062	1	sine
spine	7	65	3442	1	spine
tine	4	58	5513	1	tine
vine	7	56	4368	1	vine
wine	7	49	5342	1	wine
zine	13	70	3615	1	zine
acne	6	66	2587	2	acne
aide	5	60	4499	2	aide
ain	3	75	7909	2	ain_
ains	4	61	5888	2	ains
aline	5	72	4315	2	aline
alpine	8	44	1737	2	alpine
amine	7	58	3537	2	amine
ane	3	78	6694	2	_ane
aping	8	73	2723	2	aping
azine	14	67	2141	2	azine
bane	6	52	5042	2	bane
bene	6	64	3949	2	bene
bice	8	62	3555	2	bice
bide	7	60	4147	2	bide
bike	10	65	3259	2	bike
bile	6	61	4717	2	bile
bin	5	66	5863	2	bin_
bind	7	62	3450	2	bind
biner	7	59	3069	2	biner
bines	7	69	4679	2	bines
binge	8	51	2551	2	binge
bins	6	65	4824	2	bins
bint	6	73	5503	2	bint
bise	6	64	3709	2	bise
bite	6	65	4699	2	bite
bize	15	59	2628	2	bize
bone	6	59	4932	2	bone
brine	7	51	3227	2	brine
cane	6	66	5311	2	cane
chine	10	52	3172	2	chine
cines	7	52	3968	2	cines
cire	6	58	3637	2	cire
cite	6	56	4034	2	cite
cline	7	64	2853	2	cline
cone	6	72	5696	2	cone
dene	5	66	4341	2	dene
dice	7	58	4189	2	dice
die	4	67	5965	2	di_e
diene	6	57	2013	2	diene
dike	9	59	3576	2	dike
dime	7	62	3764	2	dime
din	4	64	5946	2	din_
dined	7	64	3199	2	dined
diner	6	56	3290	2	diner
dines	6	64	4915	2	dines
ding	6	69	4095	2	ding
dinge	7	56	2730	2	dinge
dink	9	71	3780	2	dink
dino	5	60	3675	2	dino
dins	5	66	5204	2	dins
dint	5	67	5905	2	dint
dire	5	66	4414	2	dire
dite	5	55	4755	2	dite
dive	8	56	3477	2	dive
done	5	57	4791	2	done
dune	5	61	3758	2	dune
dwine	9	56	1614	2	dwine
dyne	8	53	2093	2	dyne
eide	5	58	3223	2	eide
erne	4	67	2742	2	erne
esne	4	70	1879	2	esne
exine	12	55	1849	2	exine
eyne	7	63	2246	2	eyne
fane	7	53	4356	2	fane
fice	9	57	3711	2	fice
fie	6	71	5244	2	fi_e
fife	10	60	2770	2	fife
file	7	54	4664	2	file
fin	6	64	5803	2	fin_
find	8	75	3260	2	find
fined	9	49	3050	2	fined
finer	8	54	3156	2	finer
fines	8	66	4426	2	fines
fink	11	75	3212	2	fink
fino	7	60	3468	2	fino
fins	7	58	4909	2	fins
fire	7	62	4559	2	fire
five	10	76	2974	2	five
gane	5	51	4529	2	gane
gene	5	62	3722	2	gene
gibe	7	59	2777	2	gibe
gie	4	71	4954	2	gi_e
gien	5	63	3002	2	gien
gin	4	60	5575	2	gin_
gink	9	71	2952	2	gink
gins	5	55	4395	2	gins
gite	5	54	3861	2	gite
give	8	58	2935	2	give
gone	5	56	3904	2	gone
gwine	9	55	1366	2	gwine
hide	8	51	3462	2	hide
hie	6	76	5270	2	hi_e
hike	11	68	3039	2	hike
hin	6	75	5956	2	hin_
hind	8	55	2975	2	hind
hinge	9	53	2344	2	hinge
hins	7	64	4799	2	hins
hint	7	74	5574	2	hint
hire	7	55	3896	2	hire
hive	10	60	2967	2	hive
hone	7	75	4932	2	hone
ice	5	67	3724	2	_ice
imine	7	58	2104	2	imine
in	2	81	5086	2	_in_
ink	7	64	3363	2	_ink
inn	3	67	2743	2	_inn
ins	3	59	4560	2	_ins
ire	3	69	4317	2	_ire
jane	11	50	3147	2	jane
jibe	13	63	2338	2	jibe
jin	10	64	4393	2	jin_
jink	15	62	2720	2	jink
jinn	11	54	2024	2	jinn
jins	11	56	3501	2	jins
jinx	18	55	1657	2	jinx
jive	14	61	2359	2	jive
kane	8	51	3396	2	kane
kibe	10	65	2343	2	kibe
kike	7	65	2478	2	kike
kin	7	63	5396	2	kin_
kina	8	56	3199	2	kina
kind	9	61	2855	2	kind
kines	9	50	3913	2	kines
king	9	59	3365	2	king
kink	7	60	3439	2	kink
kino	8	62	3361	2	kino
kins	8	57	4790	2	kins
kite	8	53	3823	2	kite
koine	9	5	1648	2	koine
kune	8	54	2457	2	kune
lane	4	51	5332	2	lane
liane	5	47	2066	2	liane
lice	6	60	4506	2	lice
lie	3	82	6452	2	li_e
lien	4	53	3980	2	lien
life	7	54	3373	2	life
like	8	60	4084	2	like
lime	6	62	4493	2	lime
lin	3	79	6737	2	lin_
lined	6	49	3464	2	lined
linen	5	57	2872	2	linen
liner	5	59	3891	2	liner
lines	5	70	5457	2	lines
liney	8	70	2962	2	liney
ling	5	74	4796	2	ling
link	8	69	4344	2	link
linn	4	60	3459	2	linn
lino	4	63	4337	2	lino
lins	4	70	5905	2	lins
lint	4	162	6623	2	lint
liny	7	81	4132	2	liny
lipe	6	68	3973	2	lipe
lire	4	78	4529	2	lire
lite	4	70	5454	2	lite
live	7	65	4099	2	live
lone	4	58	4913	2	lone
lune	4	71	4049	2	lune
lupine	8	40	1353	2	lupine
mane	6	50	5201	2	mane
mice	8	74	4222	2	mice
mien	6	50	2835	2	mien
mike	10	55	3528	2	mike
mile	6	63	5256	2	mile
mime	8	57	3639	2	mime
mina	6	51	3690	2	mina
minae	7	56	2772	2	minae
mince	9	53	2523	2	mince
mind	7	54	3436	2	mind
mined	8	53	3335	2	mined
miner	7	69	3354	2	miner
mines	7	56	5195	2	mines
mini	6	56	3454	2	mini
mink	10	66	3651	2	mink
minke	11	54	2176	2	minke
mint	6	67	5804	2	mint
minx	13	77	2333	2	minx
mire	6	67	4822	2	mire
mise	6	60	4357	2	mise
mite	6	62	4940	2	mite
ne	2	70	4510	2	__ne
nene	4	59	3206	2	nene
nice	6	55	3471	2	nice
nide	5	55	3578	2	nide
nines	5	59	3734	2	nines
nite	4	59	4358	2	nite
nixe	11	57	2202	2	nixe
none	4	57	4317	2	none
oink	8	54	2934	2	oink
one	3	70	5091	2	_one
opined	9	51	1385	2	opined
opines	8	48	2070	2	opines
oping	8	63	2240	2	oping
orpine	8	39	1448	2	orpine
ovine	8	63	1664	2	ovine
pace	8	63	4577	2	pace
page	7	60	3610	2	page
pain	6	56	4724	2	pain_
pained	9	56	2285	2	pained
pains	7	51	3828	2	pains
paint	7	54	4369	2	paint
paise	7	50	2833	2	paise
pale	6	60	5501	2	pale
pan	5	84	6644	2	pan_
paned	8	54	3718	2	paned
panel	7	60	2362	2	panel
panes	7	61	4869	2	panes
pang	7	53	3628	2	pang
panne	7	66	2365	2	panne
pans	6	58	5572	2	pans
pant	6	60	6125	2	pant
pare	6	67	6084	2	pare
pase	6	53	4686	2	pase
pate	6	53	5046	2	pate
patine	8	53	2812	2	patine
pave	9	61	3389	2	pave
pe	4	76	4903	2	p__e
pee	5	60	6651	2	p_ee
peen	6	59	3808	2	peen
pein	6	58	3494	2	pein_
peined	9	49	1884	2	peined
peins	7	61	2806	2	peins
peise	7	58	2577	2	peise
peke	10	59	2620	2	peke
pele	6	55	3955	2	pele
pen	5	65	5884	2	pen_
pence	9	49	2445	2	pence
pend	7	59	3453	2	pend
penes	7	58	3922	2	penes
penne	7	54	2385	2	penne
pens	6	56	4964	2	pens
pent	6	65	5907	2	pent
pere	6	64	5026	2	pere
phone	10	56	2193	2	phone
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
piano	7	61	1871	2	piano
pians	7	51	2696	2	pians
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
pics	8	56	3391	2	pics
piece	9	67	1799	2	piece
pied	7	50	3536	2	pied
pier	6	60	3529	2	pier
pies	6	69	4960	2	pies
pig	6	57	4497	2	pi_g
pigs	7	66	3422	2	pigs
piing	8	52	1883	2	piing
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
pilea	7	51	2395	2	pilea
piled	8	52	3299	2	piled
pilei	7	40	2178	2	pilei
piles	7	47	4261	2	piles
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
pinas	7	54	3445	2	pinas
pincer	10	40	1917	2	pincer
pinch	12	56	1929	2	pinch
pinder	9	45	2345	2	pinder
pineal	8	48	1768	2	pineal
pinene	8	29	1564	2	pinene
pinery	11	52	1428	2	pinery
pineta	8	58	1556	2	pineta
pinged	10	43	2138	2	pinged
pinger	9	43	2408	2	pinger
pingo	8	71	2271	2	pingo
pings	8	58	3088	2	pings
pinier	8	40	2469	2	pinier
pinite	8	3	2124	2	pinite
pinked	13	48	1988	2	pinked
pinken	12	45	1328	2	pinken
pinker	12	53	2244	2	pinker
pinkey	15	43	1467	2	pinkey
pinkie	12	44	1427	2	pinkie
pinko	11	56	1825	2	pinko
pinks	11	57	2938	2	pinks
pinky	14	58	2340	2	pinky
pinna	7	53	2018	2	pinna
pinnae	8	44	1464	2	pinnae
pinned	9	48	1838	2	pinned
pinner	8	45	2149	2	pinner
pinny	10	52	2206	2	pinny
pinole	8	32	1878	2	pinole
pinon	7	60	2453	2	pinon
pinot	7	87	3729	2	pinot
pinta	7	57	2705	2	pinta
pintle	8	38	1826	2	pintle
pinto	7	56	2575	2	pinto
pints	7	59	3622	2	pints
pinup	9	6	1288	2	pinup
pion	6	72	3529	2	pion
pions	7	58	2639	2	pions
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
pirns	7	60	2009	2	pirns
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
plane	7	49	2914	2	plane
plie	6	51	2739	2	plie
plink	11	52	1912	2	plink
poind	8	42	1791	2	poind
point	7	53	3873	2	point
pointe	8	46	1931	2	pointe
poise	7	51	2789	2	poise
poke	10	53	3536	2	poke
pole	6	59	5130	2	pole
pome	8	56	3669	2	pome
ponce	9	52	2251	2	ponce
pond	7	55	3049	2	pond
pones	7	45	4704	2	pones
pong	7	62	3114	2	pong
pons	6	58	5060	2	pons
pony	9	64	3405	2	pony
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
prime	9	65	2560	2	prime
prince	10	41	1476	2	prince
prink	11	47	1967	2	prink
print	7	48	3746	2	print
prise	7	46	3261	2	prise
prize	16	47	1894	2	prize
prone	7	53	3262	2	prone
prune	7	51	1963	2	prune
puce	8	51	2788	2	puce
puisne	8	5	635	2	puisne
puke	10	50	2546	2	puke
pule	6	50	4095	2	pule
pun	5	88	4651	2	pun_
puna	6	53	3165	2	puna
pung	7	54	2963	2	pung
punk	10	57	2997	2	punk
puns	6	66	4148	2	puns
punt	6	57	4720	2	punt
puny	9	55	2699	2	puny
pure	6	55	4333	2	pure
purine	8	53	2189	2	purine
pye	8	64	3250	2	p_ye
pyin	9	68	2323	2	pyin_
pyins	10	58	1586	2	pyins
pyre	9	49	2555	2	pyre
rapine	8	50	2308	2	rapine
repine	8	56	2781	2	repine
rice	6	49	4291	2	rice
ride	5	59	4512	2	ride
rife	7	46	3232	2	rife
rile	4	56	5053	2	rile
rime	6	51	3888	2	rime
rin	3	66	6318	2	rin_
rind	5	65	3560	2	rind
ring	5	65	4115	2	ring
rink	8	77	3699	2	rink
rins	4	61	5319	2	rins
rinse	5	48	2097	2	rinse
ripe	6	60	3892	2	ripe
rise	4	59	4523	2	rise
rite	4	58	4945	2	rite
rive	7	55	3772	2	rive
rune	4	52	3629	2	rune
sane	4	59	5433	2	sane
seine	5	57	3287	2	seine
sene	4	68	4805	2	sene
shine	8	55	3309	2	shine
sice	6	55	4559	2	sice
side	5	54	4448	2	side
sike	8	71	3878	2	sike
sin	3	62	6589	2	sin_
since	7	50	2417	2	since
sines	5	59	5482	2	sines
sinew	8	47	1892	2	sinew
sing	5	75	4417	2	sing
singe	6	57	3113	2	singe
sinh	7	62	3804	2	sinh
sink	8	66	4014	2	sink
sins	4	67	5527	2	sins
sipe	6	73	4104	2	sipe
sire	4	61	5041	2	sire
site	4	70	5241	2	site
size	13	56	3096	2	size
sone	4	66	4998	2	sone
spice	9	55	2881	2	spice
spike	11	49	2284	2	spike
spile	7	52	3008	2	spile
spin	6	62	3130	2	spin_
spined	9	54	2394	2	spined
spinel	8	53	1733	2	spinel
spines	8	51	3203	2	spines
spinet	8	56	2975	2	spinet
spins	7	53	2798	2	spins
spiny	10	49	2130	2	spiny
spire	7	58	2869	2	spire
spite	7	54	3066	2	spite
spline	8	60	2053	2	spline
supine	8	42	1669	2	supine
swine	8	56	2530	2	swine
syne	7	57	2576	2	syne
thine	8	50	2685	2	thine
tide	5	52	3737	2	tide
tie	3	65	5753	2	ti_e
tike	8	55	3448	2	tike
tile	4	54	5144	2	tile
time	6	62	3501	2	time
tin	3	63	6217	2	tin_
tinea	5	49	2315	2	tinea
tined	6	54	3453	2	tined
tines	5	48	4842	2	tines
ting	5	61	3989	2	ting
tinge	6	46	2661	2	tinge
tins	4	52	5130	2	tins
tint	4	67	5886	2	tint
tiny	7	61	3463	2	tiny
tire	4	61	4335	2	tire
tone	4	69	5374	2	tone
trine	5	47	3460	2	trine
tune	4	56	3586	2	tune
twine	8	58	2236	2	twine
tyne	7	63	2505	2	tyne
urine	5	50	2659	2	urine
vane	7	55	3468	2	vane
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
vile	7	61	3980	2	vile
vina	7	63	3180	2	vina
vined	9	56	2615	2	vined
vines	8	51	3764	2	vines
vino	7	61	2843	2	vino
viny	10	60	2595	2	viny
vise	7	56	3267	2	vise
vive	10	54	2662	2	vive
wane	7	63	4471	2	wane
whine	11	60	2281	2	whine
wide	8	52	3540	2	wide
wife	10	52	2802	2	wife
wile	7	59	4437	2	wile
win	6	64	5629	2	win_
wince	10	52	2088	2	wince
wind	8	55	3385	2	wind
wined	9	44	3418	2	wined
wines	8	55	4686	2	wines
winey	11	53	2543	2	winey
wing	8	63	3922	2	wing
wink	11	64	3502	2	wink
wino	7	59	3361	2	wino
wins	7	59	4917	2	wins
winy	10	70	3432	2	winy
winze	17	50	1485	2	winze
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
yin	6	76	4873	2	yin_
yince	10	52	1425	2	yince
yins	7	53	3512	2	yins
yipe	9	67	2217	2	yipe
zin	12	56	4377	2	zin_
zinc	15	68	1909	2	zinc
zineb	16	56	1414	2	zineb
zines	14	52	3265	2	zines
zing	14	57	2861	2	zing
zins	13	57	3500	2	zins
zone	13	52	3108	2	zone

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	531	0.783	38150.7
3	Display Results	531	531	0.123	4317.1
	(SQL Overall)	178691	531	0.982	181966.4