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

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

325 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
pigeon	9	4	941	(None)
pigeons	10	3	918	1	pigeons
wigeon	10	3	722	1	wigeon
epigean	10	4	550	2	epigean
epigon	9	3	796	2	epig_on
mignon	9	3	795	2	mignon
paeon	7	48	1949	2	p_aeon
peon	6	56	3524	2	p__eon
pereon	8	35	1745	2	pereon
piggin	10	31	1109	2	piggin
pigpen	11	3	658	2	pigpen
pinion	8	38	1589	2	pinion
pinon	7	60	2453	2	pi_non
pinyon	11	45	976	2	pinyon
pion	6	72	3529	2	pi__on
piston	8	35	1592	2	piston
piton	7	61	2158	2	pi_ton
pleon	7	42	1638	2	p_leon
tiglon	7	3	791	2	tiglon
tigon	6	39	1444	2	tig_on
widgeon	12	4	414	2	widgeon
wigeons	11	3	698	2	wigeons
aeon	4	56	3461	3	__aeon
agon	5	65	3188	3	_ag_on
aileron	7	3	983	3	aileron
apogean	10	4	544	3	apogean
argon	6	55	2059	3	arg_on
bicron	10	37	1077	3	bicron
bigeye	12	3	664	3	bigeye
biggin	10	37	1060	3	biggin
bighorn	13	4	606	3	bighorn
bigos	8	50	2001	3	big_os
bigot	8	48	2832	3	big_ot
billon	8	37	1382	3	billon
biogen	9	3	1025	3	bioge_n
bison	7	57	1698	3	bi_son
burgeon	10	3	643	3	burgeon
chignon	13	4	462	3	chignon
cineol	8	10	820	3	cineol
cion	6	133	3091	3	ci__on
citron	8	31	1298	3	citron
cogon	8	91	2090	3	cog_on
digest	8	40	1962	3	digest
diglot	8	30	1433	3	diglot
diuron	7	3	857	3	diuron
dizen	15	52	1493	3	dize_n
dudgeon	10	13	414	3	dudgeon
dungeon	9	13	455	3	dungeon
eikon	9	3	946	3	ei_kon
eon	3	60	5208	3	___eon
epigeal	10	4	624	3	epigeal
epigeic	12	4	598	3	epigeic
epigene	10	3	789	3	epigene
epigeous	11	4	653	3	epigeous
epigone	10	5	784	3	epig_one
epigoni	10	5	609	3	epig_oni
epigons	10	4	818	3	epig_ons
epizoon	18	4	381	3	epizoon
erigeron	9	4	446	3	erigeron
gen	4	59	5051	3	__ge_n
gibbon	11	3	532	3	gibbon
gibson	9	3	512	3	gibson
gien	5	63	3002	3	gi_e_n
gigaton	9	4	634	3	gigaton
giglot	8	40	1313	3	giglot
gigot	7	40	2307	3	gig_ot
gipon	8	42	1241	3	gi_pon
giron	6	61	1899	3	gi_ron
given	9	59	1528	3	give_n
goon	5	72	3617	3	__goon
gudgeon	10	12	374	3	gudgeon
hagdon	11	8	828	3	hagdon
hegemon	13	4	517	3	hegemon
hereon	9	39	1436	3	hereon
icon	6	69	2204	3	_i_con
igloo	6	4	1049	3	_igloo
ikon	8	58	1495	3	_i_kon
inion	5	46	2017	3	_inion
ion	3	60	5102	3	_i__on
iron	4	67	2846	3	_i_ron
jeon	11	68	2144	3	__jeon
lagoon	7	4	1048	3	lagoon
legion	7	57	1298	3	legion
lien	4	53	3980	3	li_e_n
ligan	6	79	2028	3	lig_an
liger	6	50	2446	3	lige_r
ligers	7	50	2202	3	ligers
lignan	7	55	1032	3	lignan
lignin	7	49	1119	3	lignin
ligroin	8	4	804	3	ligroin
liken	9	118	1884	3	like_n
limen	7	54	2603	3	lime_n
linen	5	57	2872	3	line_n
lion	4	63	3444	3	li__on
liven	8	50	2173	3	live_n
logion	7	60	1372	3	logion
logon	6	159	2231	3	log_on
micron	10	37	1428	3	micron
mien	6	50	2835	3	mi_e_n
mignons	10	3	786	3	mignons
mikron	12	31	850	3	mikron
mimeo	9	60	1868	3	mimeo_
mimeos	10	45	1154	3	mimeos
minion	8	34	1623	3	minion
mizen	16	48	1527	3	mize_n
neon	4	70	2642	3	__neon
ninon	5	55	1738	3	ni_non
niton	5	54	1828	3	ni_ton
odeon	6	4	1148	3	_odeon
opinion	9	4	679	3	opinion
paean	7	72	2272	3	p_aean
paeons	8	39	1552	3	p_aeons
pagan	8	61	2116	3	pag_an
page	7	60	3610	3	page__
pageant	10	3	1278	3	pageant
pageboy	15	4	387	3	pageboy
paged	9	59	2678	3	page_d
pager	8	47	2820	3	page_r
pagers	9	44	2325	3	pagers
pages	8	52	3507	3	page_s
pagod	9	50	1368	3	pag_od
pangen	9	41	1591	3	pange_n
pardon	9	46	1873	3	pardon
pareo	7	46	3260	3	pareo_
pareos	8	70	2377	3	pareos
parson	8	38	1790	3	parson
parton	8	47	2099	3	parton
paseo	7	70	2251	3	paseo_
paseos	8	80	1581	3	paseos
paten	7	48	2734	3	pate_n
patron	8	40	1804	3	patron
pean	6	61	4717	3	p__ean
peen	6	59	3808	3	p__een
pegbox	18	4	401	3	pegbox
pein	6	58	3494	3	p__ein
pelon	7	44	2321	3	p_elon
pen	5	65	5884	3	p__e_n
pennon	8	3	1064	3	pennon
peons	7	53	2718	3	p__eons
peony	10	57	1756	3	p__eony
pereion	9	3	1204	3	pereion
pereons	9	28	1500	3	pereons
perigean	11	4	635	3	perigean
perigon	10	3	985	3	perig_on
perron	8	32	1662	3	perron
person	8	35	1787	3	person
phaeton	12	3	597	3	phaeton
phon	9	59	2538	3	p__hon
phonon	11	40	1203	3	phonon
photon	11	115	1482	3	photon
phylon	14	31	803	3	phylon
phyton	14	36	1025	3	phyton
pian	6	61	3609	3	pi__an
piano	7	61	1871	3	piano_
pianos	8	43	1593	3	pianos
pice	8	46	4109	3	pice__
piceous	11	3	1069	3	piceous
picot	9	50	3101	3	pi_cot
pidgin	10	25	981	3	pidgin
pie	5	54	5740	3	pi_e__
piece	9	67	1799	3	pi_ece
pied	7	50	3536	3	pi_e_d
pieing	9	39	1765	3	pi_eing
pier	6	60	3529	3	pi_e_r
piers	7	59	2633	3	pi_ers
pies	6	69	4960	3	pi_e_s
pieta	7	54	2175	3	pi_eta
piety	10	58	1730	3	pi_ety
pig	6	57	4497	3	pig___
pigboat	12	4	782	3	pigboat
pigeonite	12	4	418	3	pigeon~~ite~~
pigged	11	42	1415	3	pigged
piggery	14	26	618	3	piggery
piggie	10	32	1077	3	piggie
pigging	12	36	1467	3	pigging
piggins	11	30	1047	3	piggins
piggy	12	40	1143	3	pig_gy
piglet	9	34	2092	3	piglet
piglets	10	33	1179	3	piglets
pigment	12	5	1073	3	pigment
pigmy	13	29	943	3	pig_my
pignoli	10	4	544	3	pignoli
pignora	10	30	636	3	pignora
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	pig__s
pigskin	14	4	435	3	pigskin
pigsty	12	3	593	3	pigsty
pigweed	14	6	509	3	pigweed
pike	10	63	3521	3	pike__
piked	12	56	2331	3	pike_d
pikeman	15	3	552	3	pikeman
pikemen	15	3	533	3	pikemen
piker	11	56	2284	3	pike_r
pikers	12	47	1739	3	pikers
pikes	11	50	3103	3	pike_s
pile	6	56	4969	3	pile__
pilea	7	51	2395	3	pile_a
piled	8	52	3299	3	pile_d
pilei	7	40	2178	3	pile_i
pileous	9	5	1052	3	pileous
piles	7	47	4261	3	pile_s
pileum	10	39	951	3	pileum
pileup	10	43	792	3	pileup
pileus	8	45	1494	3	pileus
pillion	9	20	1169	3	pillion
pillow	11	31	1057	3	pillow
pilot	7	74	3506	3	pi_lot
pin	5	70	6672	3	pi___n
pinbone	11	3	817	3	pinbone
pine	6	77	5571	3	pine__
pineal	8	48	1768	3	pineal
pinecone	12	4	606	3	pinecone
pined	8	59	3532	3	pine_d
pinene	8	29	1564	3	pinene
pinery	11	52	1428	3	pinery
pines	7	60	4886	3	pine_s
pineta	8	58	1556	3	pineta
piney	10	57	2750	3	pine_y
pinged	10	43	2138	3	pinge_d
pinger	9	43	2408	3	pinge_r
pingers	10	40	2073	3	pingers
pingo	8	71	2271	3	pingo_
pingoes	10	51	1651	3	pingoes
pingos	9	53	1767	3	pingos
pinions	9	34	1360	3	pinions
pinken	12	45	1328	3	pinken
pinko	11	56	1825	3	pinko_
pinkos	12	53	1387	3	pinkos
pinons	8	60	1994	3	pi_nons
pinot	7	87	3729	3	pi_not
pinto	7	56	2575	3	pinto_
pintos	8	60	2129	3	pintos
pinyin	11	27	1061	3	pinyin
pinyons	12	29	900	3	pinyons
pions	7	58	2639	3	pi__ons
pipe	8	64	3443	3	pipe__
piped	10	51	2316	3	pipe_d
piper	9	65	2319	3	pipe_r
pipers	10	43	1866	3	pipers
pipes	9	60	3014	3	pipe_s
pipet	9	55	3332	3	pipe_t
pipets	10	57	1477	3	pipets
pipkin	14	24	860	3	pipkin
pippin	9	28	1030	3	pippin
pirn	6	71	2837	3	pi__rn
pirog	8	39	1367	3	pi_rog
pirogen	10	3	826	3	piroge_n
pisco	9	63	1498	3	pisco_
piscos	10	51	1259	3	piscos
piso	6	67	2756	3	pi_so_
pisos	7	60	2106	3	pi_sos
pistol	8	33	1333	3	pistol
pistons	9	30	1637	3	pistons
pistou	8	32	1184	3	pistou
piteous	9	3	1068	3	piteous
pitman	10	24	1212	3	pitman
pitmen	10	25	1079	3	pitmen
pitons	8	53	1904	3	pi_tons
pivot	10	65	2387	3	pi_vot
pixel	14	39	1190	3	pixe_l
pixels	15	47	853	3	pixels
pixes	14	43	2317	3	pixe_s
pleons	8	42	1334	3	p_leons
pluton	8	3	885	3	pluton
pogey	11	60	1789	3	poge_y
pogeys	12	41	1035	3	pogeys
pogrom	11	3	859	3	pogrom
poison	8	3	1222	3	poison
poleyn	11	5	732	3	poleyn
pompon	12	3	894	3	pompon
ponton	8	32	1764	3	ponton
poon	6	73	4126	3	p__oon
poteen	8	35	1426	3	poteen
potion	8	45	1957	3	potion
preen	7	59	2505	3	p_reen
preop	9	47	1587	3	p_reop
prion	7	51	1999	3	p_rion
prison	8	5	1402	3	prison
proton	8	43	1889	3	proton
puton	7	36	1791	3	p_uton
pygmean	15	4	222	3	pygmean
pylon	10	36	1400	3	p_ylon
python	14	4	714	3	python
region	7	46	1490	3	region
ribbon	10	3	653	3	ribbon
rigor	6	27	1405	3	rig_or
ripen	7	56	1926	3	ripe_n
risen	5	46	2188	3	rise_n
riven	8	51	2162	3	rive_n
sigloi	7	3	773	3	sigloi
siglos	7	3	1146	3	siglos
sign	5	55	2305	3	sig__n
signor	7	35	1035	3	signor
simoon	8	5	806	3	simoon
siphon	11	3	846	3	siphon
siren	5	45	2582	3	sire_n
smidgeon	12	30	327	3	smidgeon
spigot	9	3	1260	3	spig_ot
surgeon	8	3	700	3	surgeon
tiger	6	57	1863	3	tige_r
tigers	7	56	1650	3	tigers
tiglons	8	3	733	3	tiglons
tigons	7	41	1225	3	tig_ons
trigon	7	45	1310	3	trig_on
video	9	60	1495	3	video_
videos	10	49	1137	3	videos
vigneron	12	4	300	3	vigneron
vigor	9	26	1242	3	vig_or
vimen	10	41	1475	3	vime_n
vireo	8	48	1645	3	vireo_
vireos	9	42	1245	3	vireos
virion	9	3	1068	3	virion
vision	9	3	1131	3	vision
vixen	15	30	1002	3	vixe_n
waggon	11	3	639	3	waggon
wagon	9	43	1295	3	wag_on
widen	9	47	1797	3	wide_n
widgeons	13	4	385	3	widgeons
wigan	9	51	1439	3	wig_an
wivern	12	40	928	3	wivern
wizen	17	58	1386	3	wize_n
zircon	17	5	495	3	zircon

Search took 7 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	325	5.986	18829.9
3	Display Results	325	325	0.106	3066.0
	(SQL Overall)	178691	325	6.232	28673.1