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

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

381 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
ping	7	59	4360	(None)
aping	8	73	2723	1	aping
ding	6	69	4096	1	ding
king	9	59	3367	1	king
ling	5	74	4797	1	ling
oping	8	63	2241	1	oping
pang	7	53	3630	1	pang
pig	6	57	4498	1	pi_g
piing	8	52	1883	1	piing
pin	5	70	6673	1	pin_
pina	6	58	4264	1	pina
pine	6	77	5572	1	pine
pingo	8	71	2271	1	pingo
pings	8	58	3088	1	pings
pink	10	70	3939	1	pink
pins	6	55	5846	1	pins
pint	6	69	6318	1	pint
piny	9	118	3836	1	piny
pong	7	62	3114	1	pong
pung	7	54	2963	1	pung
ring	5	65	4116	1	ring
sing	5	75	4418	1	sing
ting	5	61	3992	1	ting
wing	8	63	3923	1	wing
zing	14	57	2862	1	zing
acing	8	74	2915	2	acing
aging	7	70	2635	2	aging
ahing	9	89	2835	2	ahing
ain	3	75	7910	2	ain_
ains	4	61	5889	2	ains
amping	11	43	1757	2	amping
awing	9	68	2732	2	awing
axing	13	85	2137	2	axing
bang	7	48	3701	2	bang
being	8	49	2050	2	being
big	6	73	4573	2	bi_g
bin	5	66	5865	2	bin_
bind	7	62	3452	2	bind
bine	6	66	5087	2	bine
binge	8	51	2551	2	binge
bingo	8	60	2009	2	bingo
bins	6	65	4826	2	bins
bint	6	73	5505	2	bint
biog	7	61	2233	2	biog
boing	8	47	2555	2	boing
bong	7	56	3341	2	bong
bring	8	55	2850	2	bring
bung	7	57	3063	2	bung
cig	6	70	3619	2	ci_g
cine	6	62	4295	2	cine
cling	8	64	2467	2	cling
coping	11	39	2766	2	coping
cuing	8	54	2019	2	cuing
dang	6	51	3155	2	dang
dig	5	75	4448	2	di_g
din	4	64	5947	2	din_
dine	5	55	5534	2	dine
dinge	7	56	2730	2	dinge
dingo	7	47	2079	2	dingo
dings	7	63	3140	2	dings
dingy	10	57	2126	2	dingy
dink	9	71	3781	2	dink
dino	5	60	3676	2	dino
dins	5	66	5205	2	dins
dint	5	67	5906	2	dint
doing	7	49	2358	2	doing
dong	6	60	3165	2	dong
doping	10	39	1946	2	doping
dung	6	63	2843	2	dung
duping	10	41	1363	2	duping
dying	10	53	1603	2	dying
eking	10	66	1499	2	eking
eng	4	67	2678	2	_eng
exing	13	60	1681	2	exing
eying	9	61	1792	2	eying
fang	8	54	3256	2	fang
fig	7	62	4284	2	fi_g
fin	6	64	5804	2	fin_
find	8	75	3261	2	find
fine	7	51	4796	2	fine
fink	11	75	3213	2	fink
fino	7	60	3470	2	fino
fins	7	58	4910	2	fins
fling	9	70	2351	2	fling
gang	6	60	3198	2	gang
gaping	10	56	1892	2	gaping
gig	5	60	4076	2	gi_g
gin	4	60	5576	2	gin_
gink	9	71	2953	2	gink
gins	5	55	4396	2	gins
going	7	52	1849	2	going
gong	6	68	2719	2	gong
hang	8	55	3556	2	hang
hin	6	75	5957	2	hin_
hind	8	55	2976	2	hind
hinge	9	53	2345	2	hinge
hins	7	64	4800	2	hins
hint	7	74	5575	2	hint
hong	8	58	3395	2	hong
hoping	12	37	1974	2	hoping
hung	8	61	2635	2	hung
hying	12	65	1474	2	hying
hyping	15	40	848	2	hyping
icing	8	60	1775	2	icing
igg	5	71	1680	2	_igg
imping	11	43	1535	2	imping
in	2	81	5087	2	_in_
ink	7	64	3364	2	_ink
inn	3	67	2744	2	_inn
ins	3	59	4561	2	_ins
iring	6	60	2542	2	iring
japing	16	50	1357	2	japing
jig	11	56	3352	2	ji_g
jin	10	64	4394	2	jin_
jingo	13	46	1521	2	jingo
jink	15	62	2721	2	jink
jinn	11	54	2025	2	jinn
jins	11	56	3502	2	jins
jinx	18	55	1658	2	jinx
kiang	10	48	1136	2	kiang
kin	7	63	5398	2	kin_
kina	8	56	3201	2	kina
kind	9	61	2857	2	kind
kine	8	56	4344	2	kine
kings	10	58	2557	2	kings
kink	7	60	3441	2	kink
kino	8	62	3363	2	kino
kins	8	57	4792	2	kins
lang	5	66	3739	2	lang
liang	6	49	1441	2	liang
lin	3	79	6738	2	lin_
line	4	69	6558	2	line
linga	6	68	2082	2	linga
lingo	6	60	2211	2	lingo
lings	6	71	3577	2	lings
lingy	9	69	2514	2	lingy
link	8	69	4345	2	link
linn	4	60	3460	2	linn
lino	4	63	4338	2	lino
lins	4	70	5906	2	lins
lint	4	162	6624	2	lint
liny	7	81	4133	2	liny
long	5	69	3334	2	long
loping	9	39	2141	2	loping
lung	5	57	3249	2	lung
lying	9	57	1745	2	lying
mig	6	56	4609	2	mi_g
migg	8	57	1681	2	migg
mina	6	51	3693	2	mina
mind	7	54	3439	2	mind
mine	6	72	5618	2	mine
mingy	11	55	2018	2	mingy
mini	6	56	3457	2	mini
mink	10	66	3654	2	mink
mint	6	67	5807	2	mint
minx	13	77	2336	2	minx
moping	11	40	1710	2	moping
nine	4	58	4218	2	nine
ohing	9	60	1881	2	ohing
oink	8	54	2935	2	oink
opine	7	74	2246	2	opine
opting	9	45	1440	2	opting
owing	9	62	2272	2	owing
pacing	11	45	2275	2	pacing
paging	10	40	2040	2	paging
pain	6	56	4724	2	pain_
pains	7	51	3828	2	pains
paint	7	54	4369	2	paint
paling	9	35	3013	2	paling
pan	5	84	6645	2	pan_
pane	6	49	5029	2	pane
panga	8	53	2354	2	panga
pangs	8	46	2867	2	pangs
pans	6	58	5573	2	pans
pant	6	60	6126	2	pant
paring	9	42	3649	2	paring
paving	12	45	1974	2	paving
pawing	12	45	1955	2	pawing
paying	12	37	2216	2	paying
peag	7	54	3134	2	peag
peeing	9	46	1808	2	peeing
peg	6	58	4306	2	p_eg
pein	6	58	3494	2	pein_
peins	7	61	2806	2	peins
pen	5	65	5884	2	pen_
pend	7	59	3453	2	pend
pengo	8	43	1759	2	pengo
pens	6	56	4964	2	pens
pent	6	65	5907	2	pent
pi	4	81	4537	2	pi__
pia	5	68	4804	2	pi_a
pial	6	56	3671	2	pial
pian	6	61	3610	2	pian
piano	7	61	1871	2	piano
pians	7	51	2696	2	pians
pias	6	65	4256	2	pias
pic	7	60	4683	2	pi_c
pica	8	58	3150	2	pica
pice	8	46	4110	2	pice
pick	12	59	3382	2	pick
pics	8	56	3392	2	pics
pie	5	54	5741	2	pi_e
pied	7	50	3537	2	pied
pieing	9	39	1765	2	pieing
pier	6	60	3530	2	pier
pies	6	69	4961	2	pies
piggy	12	40	1143	2	piggy
pigs	7	66	3423	2	pigs
pika	10	63	2296	2	pika
pike	10	63	3522	2	pike
piki	10	65	2057	2	piki
piking	13	37	1964	2	piking
pile	6	56	4970	2	pile
pili	6	61	3036	2	pili
piling	9	50	2559	2	piling
pill	6	53	3947	2	pill
pily	9	61	3274	2	pily
pima	8	54	2866	2	pima
pimp	10	60	2491	2	pimp
pinang	9	26	1159	2	pinang
pinas	7	54	3445	2	pinas
pinch	12	56	1930	2	pinch
pined	8	59	3532	2	pined
pines	7	60	4886	2	pines
piney	10	57	2750	2	piney
pinged	10	43	2138	2	pinged
pinger	9	43	2409	2	pinger
pingos	9	53	1767	2	pingos
pining	9	37	2653	2	pining
pinko	11	56	1825	2	pinko
pinks	11	57	2938	2	pinks
pinky	14	58	2340	2	pinky
pinna	7	53	2018	2	pinna
pinny	10	52	2206	2	pinny
pinon	7	60	2453	2	pinon
pinot	7	87	3729	2	pinot
pinta	7	57	2705	2	pinta
pinto	7	56	2575	2	pinto
pints	7	59	3622	2	pints
pinup	9	6	1288	2	pinup
pion	6	72	3530	2	pion
pions	7	58	2639	2	pions
pip	7	80	5105	2	pi_p
pipe	8	64	3444	2	pipe
piping	11	40	1745	2	piping
pips	8	58	3714	2	pips
pipy	11	54	2152	2	pipy
pirn	6	71	2838	2	pirn
pirns	7	60	2009	2	pirns
pirog	8	39	1367	2	pirog
pis	5	63	6204	2	pi_s
pish	9	61	2792	2	pish
piso	6	67	2757	2	piso
piss	6	50	3334	2	piss
pit	5	64	7193	2	pi_t
pita	6	54	3644	2	pita
pith	9	54	3270	2	pith
pits	6	63	4875	2	pits
pity	9	60	3194	2	pity
piu	5	66	3955	2	pi_u
pix	12	64	3794	2	pi_x
pixy	16	61	1777	2	pixy
plink	11	52	1912	2	plink
plug	7	49	1599	2	plug
plying	12	43	1208	2	plying
poind	8	42	1791	2	poind
point	7	53	3873	2	point
poking	13	38	1930	2	poking
poling	9	35	2650	2	poling
pond	7	55	3049	2	pond
pone	6	57	4753	2	pone
pongs	8	55	2634	2	pongs
pons	6	58	5060	2	pons
pony	9	64	3405	2	pony
pooing	9	38	2068	2	pooing
poring	9	42	2727	2	poring
posing	9	39	2264	2	posing
poxing	16	37	1494	2	poxing
prang	8	48	2032	2	prang
prig	7	59	2487	2	prig
prink	11	47	1967	2	prink
print	7	48	3746	2	print
prog	7	57	2900	2	prog
prong	8	52	1811	2	prong
prying	12	41	1480	2	prying
pug	6	53	3718	2	p_ug
puking	13	39	1306	2	puking
puling	9	36	2140	2	puling
pun	5	88	4651	2	pun_
puna	6	53	3165	2	puna
pungs	8	54	2222	2	pungs
punk	10	57	2997	2	punk
puns	6	66	4148	2	puns
punt	6	57	4720	2	punt
puny	9	55	2699	2	puny
pyin	9	68	2323	2	pyin_
pyins	10	58	1586	2	pyins
rang	5	69	3917	2	rang
raping	9	48	2985	2	raping
rig	4	67	4813	2	ri_g
rin	3	66	6319	2	rin_
rind	5	65	3561	2	rind
rings	6	50	2917	2	rings
rink	8	77	3700	2	rink
rins	4	61	5320	2	rins
riping	9	38	2161	2	riping
roping	9	40	2302	2	roping
ruing	6	72	2105	2	ruing
rung	5	64	2998	2	rung
sang	5	54	4124	2	sang
sign	5	55	2306	2	sign
sin	3	62	6590	2	sin_
sine	4	65	6063	2	sine
singe	6	57	3113	2	singe
sings	6	55	3270	2	sings
sinh	7	62	3805	2	sinh
sink	8	66	4015	2	sink
sins	4	67	5528	2	sins
siping	9	42	2063	2	siping
sling	6	60	2880	2	sling
song	5	51	3367	2	song
spang	8	49	1973	2	spang
spin	6	62	3130	2	spin_
spine	7	65	3442	2	spine
spins	7	53	2798	2	spins
spiny	10	49	2130	2	spiny
spring	9	45	2601	2	spring
spuing	9	43	1336	2	spuing
spying	12	39	1325	2	spying
sting	6	53	3024	2	sting
suing	6	50	2636	2	suing
sung	5	58	3217	2	sung
swing	9	61	2484	2	swing
tang	5	61	3869	2	tang
taping	9	42	2239	2	taping
thing	9	66	2298	2	thing
tin	3	63	6218	2	tin_
tine	4	58	5514	2	tine
tinge	6	46	2663	2	tinge
tings	6	53	2921	2	tings
tins	4	52	5131	2	tins
tint	4	67	5887	2	tint
tiny	7	61	3464	2	tiny
tong	5	64	3436	2	tong
toping	9	41	2299	2	toping
tung	5	53	2817	2	tung
tying	9	60	1984	2	tying
typing	12	41	1058	2	typing
umping	11	48	1533	2	umping
upping	11	40	1370	2	upping
urping	9	39	1405	2	urping
using	6	63	1796	2	using
vang	8	49	2605	2	vang
vig	7	56	3753	2	vi_g
vina	7	63	3181	2	vina
vine	7	56	4369	2	vine
vino	7	61	2844	2	vino
viny	10	60	2596	2	viny
vying	12	51	1181	2	vying
wig	7	67	4039	2	wi_g
win	6	64	5630	2	win_
wind	8	55	3386	2	wind
wine	7	49	5343	2	wine
wings	9	57	2724	2	wings
wingy	12	65	2103	2	wingy
wink	11	64	3503	2	wink
wino	7	59	3362	2	wino
wins	7	59	4918	2	wins
winy	10	70	3433	2	winy
wiping	12	39	1671	2	wiping
wring	9	59	2071	2	wring
yang	8	56	2608	2	yang
yin	6	76	4874	2	yin_
yins	7	53	3513	2	yins
zig	13	69	3191	2	zi_g
zin	12	56	4378	2	zin_
zinc	15	68	1910	2	zinc
zine	13	70	3616	2	zine
zings	15	46	2089	2	zings
zingy	18	65	1613	2	zingy
zins	13	57	3501	2	zins

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.263	679433.5
2	DLD Change Limit	29872	381	0.906	32971.3
3	Display Results	381	381	0.093	4096.8
	(SQL Overall)	178691	381	1.262	141593.5