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

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

384 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
pigs	7	66	3422	(None)
bigs	7	62	3502	1	bigs
cigs	7	56	2510	1	cigs
digs	6	60	3605	1	digs
figs	8	53	3264	1	figs
gigs	6	66	3118	1	gigs
jigs	12	65	2476	1	jigs
migs	7	69	3532	1	migs
pegs	7	55	3176	1	pegs
pias	6	65	4255	1	pias
pics	8	56	3391	1	pics
pies	6	69	4960	1	pies
pig	6	57	4497	1	pig_
pings	8	58	3088	1	pings
pins	6	55	5845	1	pins
pips	8	58	3713	1	pips
pis	5	63	6203	1	pi_s
piss	6	50	3333	1	piss
pits	6	63	4874	1	pits
prigs	8	52	1970	1	prigs
pugs	7	63	3277	1	pugs
rigs	5	51	3759	1	rigs
vigs	8	54	2727	1	vigs
wigs	8	49	3125	1	wigs
zigs	14	54	2279	1	zigs
ags	4	75	5166	2	_ags
aids	5	78	4635	2	aids
ails	4	56	5471	2	ails
aims	6	77	3818	2	aims
ains	4	61	5888	2	ains
airs	4	64	4742	2	airs
ais	3	90	8357	2	ai_s
aits	4	63	5553	2	aits
bags	7	66	4550	2	bags
begs	7	57	3383	2	begs
bias	6	47	3816	2	bias
bibs	8	48	3099	2	bibs
bids	7	58	3843	2	bids
big	6	73	4572	2	big_
bigos	8	50	2001	2	bigos
bins	6	65	4825	2	bins
biogs	8	50	1611	2	biogs
bios	6	63	3532	2	bios
bis	5	68	6066	2	bi_s
bits	6	61	4816	2	bits
bogs	7	57	4275	2	bogs
brigs	8	58	2322	2	brigs
bugs	7	60	3591	2	bugs
cig	6	70	3618	2	cig_
cis	5	77	4803	2	ci_s
cogs	7	73	4003	2	cogs
dags	6	66	4260	2	dags
dibs	7	62	3368	2	dibs
dies	5	56	5352	2	dies
difs	8	60	2732	2	difs
dig	5	75	4447	2	dig_
dims	7	54	3502	2	dims
dings	7	63	3140	2	dings
dins	5	66	5204	2	dins
dips	7	55	3691	2	dips
dis	4	64	5989	2	di_s
diss	5	64	3448	2	diss
dits	5	64	5052	2	dits
dogs	6	64	4015	2	dogs
dugs	6	148	3228	2	dugs
eggs	6	65	1615	2	eggs
egis	5	65	2065	2	egis
engs	5	61	2139	2	engs
epics	9	50	1428	2	epics
ergs	5	55	2381	2	ergs
fags	8	69	3912	2	fags
fibs	9	63	2950	2	fibs
fids	8	70	3473	2	fids
fig	7	62	4283	2	fig_
fils	7	58	3869	2	fils
fins	7	58	4909	2	fins
firs	7	66	3771	2	firs
fits	7	60	4346	2	fits
fogs	8	70	3500	2	fogs
frigs	9	60	1927	2	frigs
fugs	8	57	3069	2	fugs
gags	6	64	4106	2	gags
gibs	7	55	2927	2	gibs
gids	6	59	3373	2	gids
gies	5	56	4142	2	gies
gig	5	60	4075	2	gig_
giga	6	67	2094	2	giga
gigas	7	54	1558	2	gigas
gins	5	55	4395	2	gins
gips	7	56	3292	2	gips
gits	5	57	4459	2	gits
grigs	7	53	1819	2	grigs
hags	8	67	4084	2	hags
hies	7	48	4283	2	hies
high	11	66	1992	2	high
highs	12	54	1252	2	highs
hims	9	52	3097	2	hims
hins	7	64	4799	2	hins
hips	9	64	3370	2	hips
his	6	63	5950	2	hi_s
hiss	7	56	2921	2	hiss
hits	7	55	4513	2	hits
hogs	8	71	3966	2	hogs
hugs	8	61	2975	2	hugs
ids	4	75	3546	2	_ids
ifs	6	71	2424	2	_ifs
igg	5	71	1679	2	_igg
iggs	6	66	1267	2	iggs
ins	3	59	4560	2	_ins
is	2	70	4821	2	_i_s
its	3	55	3883	2	_its
jags	12	61	3279	2	jags
jibs	13	67	2408	2	jibs
jig	11	56	3351	2	jig_
jins	11	56	3501	2	jins
jogs	12	71	2933	2	jogs
jugs	12	55	2560	2	jugs
kegs	9	58	2401	2	kegs
kids	9	60	2963	2	kids
kifs	11	60	2350	2	kifs
kings	10	58	2556	2	kings
kins	8	57	4790	2	kins
kips	10	64	3051	2	kips
kirs	8	58	3173	2	kirs
kis	7	80	5147	2	ki_s
kiss	8	52	2739	2	kiss
kits	8	64	4176	2	kits
lags	5	65	4622	2	lags
legs	5	61	3369	2	legs
libs	6	67	3276	2	libs
lids	5	63	3645	2	lids
lies	4	64	5419	2	lies
lings	6	71	3577	2	lings
lins	4	70	5905	2	lins
lips	6	71	4144	2	lips
lis	3	71	6227	2	li_s
lits	4	62	5249	2	lits
logs	5	73	4311	2	logs
lugs	5	52	3352	2	lugs
mags	7	54	4453	2	mags
megs	7	55	3063	2	megs
mibs	8	53	3048	2	mibs
mics	8	74	3515	2	mics
mids	7	65	4178	2	mids
mig	6	56	4608	2	mig_
migg	8	57	1680	2	migg
miggs	9	63	1137	2	miggs
mils	6	60	4533	2	mils
mips	8	55	3408	2	mips
mirs	6	69	4057	2	mirs
mis	5	81	6262	2	mi_s
miss	6	53	3942	2	miss
mogs	7	54	3933	2	mogs
mugs	7	62	3204	2	mugs
nags	5	54	3602	2	nags
negs	5	57	2736	2	negs
nibs	6	50	2831	2	nibs
nigh	8	52	2066	2	nigh
nighs	9	50	1361	2	nighs
nils	4	61	3245	2	nils
nims	6	62	2688	2	nims
nips	6	58	3092	2	nips
nits	4	57	4164	2	nits
nogs	5	65	3461	2	nogs
oils	4	63	3797	2	oils
pacs	8	58	4218	2	pacs
pads	7	67	4295	2	pads
page	7	60	3610	2	page
pages	8	52	3507	2	pages
paiks	11	47	1985	2	paiks
pails	7	58	3306	2	pails
pains	7	51	3828	2	pains
pairs	7	53	2583	2	pairs
pals	6	69	5135	2	pals
pams	8	56	4176	2	pams
pangs	8	46	2866	2	pangs
pans	6	58	5573	2	pans
paps	8	64	4345	2	paps
pars	6	75	6079	2	pars
pas	5	87	7574	2	p_as
pass	6	52	3995	2	pass
pats	6	64	6085	2	pats
paws	9	60	3818	2	paws
pays	9	59	4022	2	pays
peags	8	61	2284	2	peags
peas	6	57	5506	2	peas
pecs	8	46	3410	2	pecs
peds	7	58	3524	2	peds
pees	6	52	5737	2	pees
peg	6	58	4306	2	peg_
pehs	9	56	2576	2	pehs
peins	7	61	2806	2	peins
pens	6	56	4964	2	pens
peps	8	51	3451	2	peps
pes	5	72	5978	2	p_es
pets	6	62	4833	2	pets
pews	9	57	3153	2	pews
phis	9	57	2490	2	phis
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
pians	7	51	2696	2	pians
pic	7	60	4682	2	pi_c
pica	8	58	3149	2	pica
picas	9	46	2652	2	picas
pice	8	46	4109	2	pice
pick	12	59	3381	2	pick
picks	13	52	2614	2	picks
pie	5	54	5740	2	pi_e
pied	7	50	3536	2	pied
pier	6	60	3529	2	pier
piers	7	59	2633	2	piers
piggy	12	40	1143	2	piggy
pigmy	13	29	943	2	pigmy
pignus	9	3	795	2	pignus
pigsty	12	3	593	2	pigsty
pika	10	63	2295	2	pika
pikas	11	42	1809	2	pikas
pike	10	63	3521	2	pike
pikes	11	50	3103	2	pikes
piki	10	65	2056	2	piki
pikis	11	51	1639	2	pikis
pile	6	56	4969	2	pile
piles	7	47	4261	2	piles
pili	6	61	3035	2	pili
pilis	7	58	2520	2	pilis
pill	6	53	3946	2	pill
pills	7	41	3097	2	pills
pilus	7	59	2106	2	pilus
pily	9	61	3273	2	pily
pima	8	54	2865	2	pima
pimas	9	47	2510	2	pimas
pimp	10	60	2490	2	pimp
pimps	11	46	1698	2	pimps
pin	5	70	6672	2	pi_n
pina	6	58	4263	2	pina
pinas	7	54	3445	2	pinas
pine	6	77	5571	2	pine
pines	7	60	4886	2	pines
ping	7	59	4359	2	ping
pingo	8	71	2271	2	pingo
pingos	9	53	1767	2	pingos
pink	10	70	3938	2	pink
pinks	11	57	2938	2	pinks
pint	6	69	6317	2	pint
pints	7	59	3622	2	pints
piny	9	118	3835	2	piny
pion	6	72	3529	2	pion
pions	7	58	2639	2	pions
pious	7	46	2127	2	pious
pip	7	80	5104	2	pi_p
pipe	8	64	3443	2	pipe
pipes	9	60	3014	2	pipes
pipy	11	54	2151	2	pipy
pirn	6	71	2837	2	pirn
pirns	7	60	2009	2	pirns
pish	9	61	2791	2	pish
piso	6	67	2756	2	piso
pisos	7	60	2106	2	pisos
pit	5	64	7192	2	pi_t
pita	6	54	3643	2	pita
pitas	7	74	2767	2	pitas
pith	9	54	3269	2	pith
piths	10	58	1754	2	piths
pity	9	60	3193	2	pity
piu	5	66	3954	2	pi_u
pix	12	64	3793	2	pi_x
pixes	14	43	2317	2	pixes
pixy	16	61	1776	2	pixy
plies	7	45	2651	2	plies
plugs	8	52	1349	2	plugs
plus	6	63	2483	2	plus
pods	7	65	4015	2	pods
pogy	10	56	2355	2	pogy
pois	6	65	3904	2	pois
pols	6	60	4456	2	pols
poms	8	70	3774	2	poms
pongs	8	55	2634	2	pongs
pons	6	58	5060	2	pons
poos	6	59	4911	2	poos
pops	8	63	4095	2	pops
pots	6	64	5236	2	pots
pows	9	55	3766	2	pows
pries	7	43	3953	2	pries
prig	7	59	2487	2	prig_
prims	9	54	2593	2	prims
priss	7	46	2389	2	priss
progs	8	66	2415	2	progs
pros	6	57	4278	2	pros
psis	6	81	2034	2	psis
pubs	8	50	2921	2	pubs
puds	7	56	3051	2	puds
pug	6	53	3718	2	pug_
pugh	10	66	1923	2	pugh
puls	6	54	3756	2	puls
pungs	8	54	2222	2	pungs
puns	6	66	4148	2	puns
pups	8	60	3223	2	pups
purs	6	56	4104	2	purs
pus	5	55	4784	2	p_us
puss	6	48	3013	2	puss
puts	6	56	4175	2	puts
pyas	9	62	2570	2	pyas
pyes	9	55	2899	2	pyes
pyins	10	58	1586	2	pyins
qis	12	69	3438	2	qi_s
rags	5	54	4837	2	rags
regs	5	54	3657	2	regs
rias	4	55	4059	2	rias
ribs	6	58	3302	2	ribs
rids	5	65	3954	2	rids
rifs	7	49	2900	2	rifs
rig	4	67	4812	2	rig_
rims	6	59	3630	2	rims
rings	6	50	2917	2	rings
rins	4	61	5319	2	rins
rips	6	62	3743	2	rips
rugs	5	60	3368	2	rugs
sags	5	59	4840	2	sags
segs	5	49	3388	2	segs
sibs	6	59	3354	2	sibs
sics	6	52	3409	2	sics
sigh	8	56	2589	2	sigh
sighs	9	54	1674	2	sighs
sign	5	55	2305	2	sign
signs	6	55	1632	2	signs
sims	6	57	3717	2	sims
sings	6	55	3270	2	sings
sins	4	67	5527	2	sins
sips	6	57	4010	2	sips
sirs	4	43	3833	2	sirs
sis	3	73	6054	2	si_s
sits	4	50	5020	2	sits
spics	9	41	2324	2	spics
spies	7	60	3762	2	spies
spiks	11	41	1747	2	spiks
spins	7	53	2798	2	spins
spits	7	44	2955	2	spits
spivs	10	51	1424	2	spivs
sprigs	9	48	1477	2	sprigs
swigs	9	62	1366	2	swigs
tags	5	55	4523	2	tags
tegs	5	60	3149	2	tegs
tics	6	57	2963	2	tics
ties	4	52	4831	2	ties
tils	4	57	3961	2	tils
tings	6	53	2920	2	tings
tins	4	52	5130	2	tins
tips	6	64	3676	2	tips
tis	3	70	5664	2	ti_s
tits	4	61	4504	2	tits
togs	5	72	4243	2	togs
trigs	6	54	2306	2	trigs
tugs	5	62	3167	2	tugs
twigs	9	69	1117	2	twigs
vids	8	56	2753	2	vids
vies	7	52	3862	2	vies
vig	7	56	3752	2	vig_
viga	8	56	2296	2	viga
vigas	9	48	1788	2	vigas
vims	9	54	2331	2	vims
vis	6	67	4761	2	vi_s
vugs	8	70	2287	2	vugs
wags	8	61	4055	2	wags
whigs	12	56	1264	2	whigs
wig	7	67	4038	2	wig_
wings	9	57	2724	2	wings
wins	7	59	4917	2	wins
wis	6	65	5233	2	wi_s
wiss	7	56	3054	2	wiss
wits	7	60	4487	2	wits
wogs	8	65	3140	2	wogs
xis	10	69	3533	2	xi_s
yags	8	66	3229	2	yags
yids	8	52	2495	2	yids
yins	7	53	3512	2	yins
yips	9	52	2670	2	yips
zags	14	68	2668	2	zags
zig	13	69	3190	2	zig_
zings	15	46	2089	2	zings
zins	13	57	3500	2	zins
zips	15	57	2379	2	zips
zits	13	60	3029	2	zits

Search took 1 second 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	384	0.750	39829.3
3	Display Results	384	384	0.093	4129.0
	(SQL Overall)	178691	384	0.919	194440.7