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

Here are the results of your fuzzy-string dictionary search for “piggin” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

339 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
piggin	10	31	1109	(None)
biggin	10	37	1060	1	biggin
pidgin	10	25	981	1	pidgin
piggie	10	32	1077	1	piggie
pigging	12	36	1467	1	pigging
piggins	11	30	1047	1	piggins
biggie	10	38	1093	2	biggie
bigging	12	28	1588	2	bigging
biggins	11	34	1069	2	biggins
digging	11	35	1370	2	digging
figging	13	33	1356	2	figging
gigging	9	33	1177	2	gigging
igging	9	32	1207	2	_igging
jigging	17	30	1155	2	jigging
leggin	8	26	859	2	leggin
lignin	7	49	1119	2	lignin
noggin	8	28	888	2	noggin
pegging	12	28	1113	2	pegging
pidgins	11	25	912	2	pidgins
pigeon	9	4	941	2	pigeon
pigged	11	42	1415	2	pigged
piggier	11	35	1000	2	piggier
piggies	11	38	1348	2	piggies
piggish	14	22	770	2	piggish
piggy	12	40	1143	2	pigg_y
pigpen	11	3	658	2	pigpen
pigskin	14	4	435	2	pigskin
pinging	11	34	1955	2	pinging
pinyin	11	27	1061	2	pinyin
pipkin	14	24	860	2	pipkin
pippin	9	28	1030	2	pippin
prigging	13	29	909	2	prigging
pugging	12	29	1254	2	pugging
rigging	10	30	1633	2	rigging
virgin	10	3	808	2	virgin
wigging	13	34	1383	2	wigging
zigging	19	32	1053	2	zigging
again	6	52	1812	3	_again
aggie	7	34	1501	3	_aggie
agin	5	61	3271	3	__agin
algin	6	57	1876	3	_algin
baggie	10	29	1219	3	baggie
bagging	12	33	1698	3	bagging
begging	12	30	1265	3	begging
begin	8	51	1735	3	_begin
biffin	14	36	910	3	biffin
bigger	10	43	1506	3	bigger
biggies	11	38	1352	3	biggies
biggings	13	32	747	3	biggings
biggish	14	24	750	3	biggish
biggity	14	3	501	3	biggity
biggy	12	44	1313	3	bigg_y
bigwig	13	3	334	3	bigwig
bilging	11	42	1268	3	bilging
binging	11	36	1938	3	binging
biogen	9	3	1025	3	biogen
biotin	8	32	1583	3	biotin
bogging	12	36	1575	3	bogging
bugging	12	35	1518	3	bugging
citrin	8	26	1541	3	citrin
cogging	12	35	1371	3	cogging
diamin	9	3	1252	3	diamin
diazin	16	3	916	3	diazin
digged	10	43	1465	3	digged
digger	9	46	1608	3	digger
diggings	12	31	662	3	diggings
digit	7	38	2527	3	di_git
digoxin	16	4	494	3	digoxin
dinging	10	36	1861	3	dinging
dioxin	14	11	878	3	dioxin
doggie	9	39	1089	3	doggie
dogging	11	33	1269	3	dogging
egging	9	32	1098	3	_egging
epigean	10	4	550	3	epigean
epigeic	12	4	598	3	epigeic
epigon	9	3	796	3	epi_gon
epigoni	10	5	609	3	epigoni
fagging	13	37	1476	3	fagging
fagin	9	2	1657	3	_fagin
fibrin	11	3	853	3	fibrin
ficin	10	35	1672	3	fi_cin
fidging	13	39	1050	3	fidging
figged	12	40	1389	3	figged
firkin	13	3	782	3	firkin
fizgig	20	3	297	3	fizgig
fogging	13	35	1373	3	fogging
frigging	14	26	895	3	frigging
fugging	13	39	1291	3	fugging
gagging	9	30	1352	3	gagging
gain	5	60	4216	3	__gain
gigged	10	41	1229	3	gigged
giggle	9	43	1351	3	giggle
giggling	10	22	704	3	giggling
giggly	12	51	870	3	giggly
gin	4	60	5575	3	___gin
gittin	7	29	1055	3	gittin
grin	5	57	3372	3	__grin
hagging	13	31	1468	3	hagging
haggis	11	20	951	3	haggis
higgle	11	38	1174	3	higgle
higgling	14	21	716	3	higgling
hinging	12	39	1712	3	hinging
hogging	13	31	1280	3	hogging
hugging	13	27	1063	3	hugging
igg	5	71	1679	3	_igg__
igged	8	60	1276	3	_igged
iggs	6	66	1267	3	_igg_s
iodin	6	44	1935	3	_iodin
jagging	17	33	1199	3	jagging
jigged	16	44	1277	3	jigged
jigger	15	53	1305	3	jigger
jiggier	16	37	782	3	jiggier
jiggish	19	22	594	3	jiggish
jiggle	15	38	1199	3	jiggle
jiggling	18	22	636	3	jiggling
jiggly	18	37	871	3	jiggly
jiggy	17	54	914	3	jigg_y
jogging	17	32	1123	3	jogging
jugging	17	29	1072	3	jugging
kegging	14	32	829	3	kegging
kinging	13	31	1503	3	kinging
kingpin	14	4	500	3	kingpin
kinin	9	49	1732	3	ki_nin
lagging	10	33	1673	3	lagging
legging	10	39	1264	3	legging
leggins	9	25	947	3	leggins
ligan	6	79	2028	3	li_gan
lignan	7	55	1032	3	lignan
lignins	8	40	1049	3	lignins
ligroin	8	4	804	3	ligroin
linin	5	80	2552	3	li_nin
lipin	7	55	1889	3	li_pin
loggia	8	45	705	3	loggia
loggie	8	40	1199	3	loggie
logging	10	33	1680	3	logging
login	6	60	2500	3	_login
luggie	8	31	890	3	luggie
lugging	10	41	1435	3	lugging
margin	9	40	1684	3	margin
migg	8	57	1680	3	migg__
miggle	10	40	1211	3	miggle
miggs	9	63	1137	3	migg_s
mignon	9	3	795	3	mignon
mirin	7	50	2315	3	mi_rin
moggie	10	32	1010	3	moggie
mogging	12	33	1149	3	mogging
mugging	12	27	1179	3	mugging
muggins	11	24	807	3	muggins
nagging	10	26	1304	3	nagging
niacin	8	3	1022	3	niacin
nigger	8	97	1357	3	nigger
niggle	8	36	1282	3	niggle
niggling	11	22	744	3	niggling
niggly	11	41	891	3	niggly
nighing	12	34	1006	3	nighing
nogging	10	36	1272	3	nogging
noggins	9	28	845	3	noggins
origin	7	3	1103	3	origin
pagan	8	61	2116	3	p_agan
paging	10	40	2040	3	p_aging
pain	6	56	4724	3	p__ain
pangen	9	41	1591	3	pangen
panging	11	33	1911	3	panging
papain	10	3	1379	3	papain
parging	11	33	1860	3	parging
patin	7	68	3285	3	p_atin
paulin	8	3	1298	3	paulin
pavin	10	56	2320	3	p_avin
pectin	10	26	1553	3	pectin
pegged	11	48	1190	3	pegged
pein	6	58	3494	3	p__ein
pekin	11	15	1442	3	p_ekin
penguin	10	4	587	3	penguin
pepsin	10	3	1085	3	pepsin
phytin	14	45	901	3	phytin
pian	6	61	3609	3	pi__an
pianic	10	37	1412	3	pianic
picking	16	34	1833	3	picking
picnic	12	34	1026	3	picnic
picolin	11	3	1088	3	picolin
picric	12	30	992	3	picric
piecing	12	4	1045	3	piecing
pieing	9	39	1765	3	pi_eing
pig	6	57	4497	3	pi_g__
pigeons	10	3	918	3	pigeons
pigfish	16	21	717	3	pigfish
piggery	14	26	619	3	piggery
piggiest	12	25	966	3	piggiest
pigginess	13	7	545	3	piggin~~ess~~
piglet	9	34	2092	3	piglet
piglike	14	15	731	3	piglike
pigment	12	5	1073	3	pigment
pigmies	12	26	1099	3	pigmies
pigmy	13	29	943	3	pi_gmy
pignus	9	3	795	3	pignus
pignut	9	3	1157	3	pignut
pigout	9	3	1461	3	pigout
pigpens	12	3	550	3	pigpens
pigs	7	66	3422	3	pi_g_s
pigskins	15	4	425	3	pigskins
pigsty	12	3	593	3	pigsty
pigtail	10	4	662	3	pigtail
piing	8	52	1883	3	pi__ing
piki	10	65	2056	3	pi_ki_
piking	13	37	1964	3	pi_king
pikis	11	51	1639	3	pi_kis
pilei	7	40	2178	3	pilei_
pilgrim	12	4	464	3	pilgrim
pili	6	61	3035	3	pi_li_
piling	9	50	2559	3	pi_ling
pilis	7	58	2520	3	pi_lis
pilling	10	37	2256	3	pilling
pillion	9	20	1170	3	pillion
pimping	14	38	1212	3	pimping
pin	5	70	6672	3	p___in
ping	7	59	4359	3	ping__
pinged	10	43	2138	3	pinged
pinger	9	43	2409	3	pinger
pingo	8	71	2271	3	ping_o
pingos	9	53	1767	3	pingos
pings	8	58	3088	3	ping_s
pinguid	11	4	624	3	pinguid
pining	9	37	2653	3	pi_ning
pinion	8	38	1589	3	pinion
pinken	12	45	1328	3	pinken
pinkie	12	44	1427	3	pinkie
pinking	14	39	1894	3	pinking
pinning	10	34	1785	3	pinning
pinon	7	60	2453	3	pi_non
pinyon	11	45	976	3	pinyon
pion	6	72	3529	3	pi__on
pionic	10	35	1595	3	pionic
piping	11	40	1745	3	pi_ping
pipit	9	52	2487	3	pi_pit
pipkins	15	32	818	3	pipkins
pipping	11	34	1474	3	pipping
pippins	10	31	975	3	pippins
piquing	19	3	587	3	piquing
pirn	6	71	2837	3	pi__rn
pirogen	10	3	826	3	pirogen
pirogi	9	29	901	3	pirogi_
piscina	11	7	704	3	piscina
piscine	11	6	1097	3	piscine
pishing	13	43	1437	3	pishing
pissing	10	39	1480	3	pissing
pistil	8	39	1507	3	pistil
piston	8	35	1592	3	piston
pithing	13	40	1405	3	pithing
pitman	10	24	1212	3	pitman
pitmen	10	25	1079	3	pitmen
piton	7	61	2158	3	pi_ton
pitting	10	36	1887	3	pitting
pitying	13	29	1024	3	pitying
pixie	14	54	1552	3	pi_xie
plain	7	48	2330	3	p_lain
plugging	13	30	689	3	plugging
pongid	10	41	1158	3	pongid
ponging	11	34	1615	3	ponging
popgun	11	4	573	3	popgun
poplin	10	4	1348	3	poplin
postin	8	35	2103	3	postin
prigged	12	39	893	3	prigged
priggish	15	4	468	3	priggish
priggism	14	4	438	3	priggism
progging	13	26	1038	3	progging
progun	9	6	878	3	progun
pterin	8	10	1415	3	pterin
puffin	14	114	900	3	puffin
pugged	11	43	1453	3	pugged
puggier	11	30	938	3	puggier
puggish	14	26	599	3	puggish
puggry	13	37	482	3	puggry
puggy	12	46	1232	3	pugg_y
punkin	12	36	1152	3	punkin
purging	11	33	1418	3	purging
purin	7	55	2759	3	p_urin
purlin	8	36	1586	3	purlin
pyin	9	68	2323	3	p__yin
ragging	10	35	1668	3	ragging
reagin	7	49	1553	3	reagin
regain	7	45	1776	3	regain
ricin	7	46	2021	3	ri_cin
ridgil	8	31	682	3	ridgil
ridging	10	41	1298	3	ridging
rigged	9	45	1740	3	rigged
rigger	8	56	1671	3	rigger
riggings	11	32	713	3	riggings
rigid	7	9	1389	3	ri_gid
ringgit	9	4	601	3	ringgit
ringing	9	35	2128	3	ringing
rugging	10	25	1276	3	rugging
sagging	10	31	1610	3	sagging
sieging	9	26	1320	3	sieging
sighing	12	33	1166	3	sighing
sigil	6	35	1550	3	si_gil
sign	5	55	2305	3	si_g_n
signing	9	27	1396	3	signing
simlin	8	3	1173	3	simlin
singing	9	32	2142	3	singing
siskin	10	7	978	3	siskin
smidgin	11	33	510	3	smidgin
spongin	10	3	637	3	spongin
sprigging	14	3	589	3	sprigging
swigging	14	33	722	3	swigging
tagging	10	30	1491	3	tagging
tiepin	8	3	934	3	tiepin
tiffin	12	32	793	3	tiffin
tiglon	7	3	792	3	tiglon
tigon	6	39	1444	3	ti_gon
tinging	9	36	1946	3	tinging
togging	10	35	1274	3	togging
trigging	11	29	958	3	trigging
tugging	10	26	1123	3	tugging
twiggen	12	33	350	3	twiggen
twigging	14	30	567	3	twigging
veggie	11	3	630	3	veggie
vegging	13	30	887	3	vegging
vigia	9	48	1327	3	vi_gia
vigil	9	43	1300	3	vi_gil
violin	9	3	1198	3	violin
virgins	11	3	786	3	virgins
wagging	13	33	1335	3	wagging
waggon	11	3	639	3	waggon
wigan	9	51	1439	3	wi_gan
wigeon	10	3	722	3	wigeon
wigged	12	44	1358	3	wigged
wiggier	12	41	886	3	wiggier
wiggings	14	31	617	3	wiggings
wiggle	11	37	1301	3	wiggle
wiggling	14	21	729	3	wiggling
wiggly	14	55	968	3	wiggly
wiggy	13	45	1073	3	wigg_y
wimmin	13	3	615	3	wimmin
winging	12	37	1871	3	winging
within	12	36	1138	3	within
yogin	9	83	1774	3	_yogin
zagging	19	32	1045	3	zagging
zigged	18	41	1019	3	zigged
zinging	18	35	1394	3	zinging

Search took 6 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	112716	0.140	1276364.3
2	DLD Change Limit	112716	339	5.110	22057.9
3	Display Results	339	339	0.126	2690.5
	(SQL Overall)	178691	339	5.376	33238.7