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

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

331 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
pompon	12	3	894	(None)
pompom	14	3	649	1	pompom
pompons	13	3	855	1	pompons
common	12	3	1080	2	common
compo	11	53	1857	2	compo_
compone	13	65	1719	2	compone
compony	16	130	1191	2	compony
compos	12	48	1880	2	compos
coupon	10	28	1099	2	coupon
jomon	14	6	1008	2	jom_on
poison	8	3	1222	2	poison
pomo	8	58	2845	2	pom_o_
pomos	9	53	2158	2	pom_os
pomp	10	62	2546	2	pomp__
pompano	13	4	520	2	pompano
pompoms	15	3	533	2	pompoms
pompous	13	3	806	2	pompous
pomps	11	53	1619	2	pomp_s
ponton	8	32	1764	2	ponton
poon	6	73	4126	2	po__on
potion	8	45	1957	2	potion
tampon	10	29	1123	2	tampon
tompion	11	24	710	2	tompion
youpon	11	36	600	2	youpon
bolson	8	4	1068	3	bolson
bonbon	10	3	1007	3	bonbon
boon	6	71	4217	3	bo__on
boron	7	67	2714	3	bo_ron
boson	7	60	1973	3	bo_son
boston	8	5	1304	3	boston
bouton	8	3	1153	3	bouton
bowpot	13	4	1007	3	bowpot
camion	10	39	1719	3	camion
campion	13	30	1141	3	campion
campo	11	52	1976	3	campo_
campong	14	31	812	3	campong
campos	12	52	1795	3	campos
capon	9	52	2187	3	_capon
cocoon	10	3	1226	3	cocoon
codon	8	65	2285	3	co_don
cogon	8	91	2090	3	co_gon
colon	7	86	3019	3	co_lon
combo	11	45	1943	3	combo_
combos	12	53	1661	3	combos
commons	13	3	1104	3	commons
comp	10	67	3125	3	comp__
company	16	197	1114	3	company
compas	12	58	1706	3	compas
comped	13	59	1987	3	comped
compel	12	44	1289	3	compel
compend	14	40	1030	3	compend
comping	14	35	1859	3	comping
complin	13	3	1207	3	complin
complot	13	3	1068	3	complot
comply	15	28	1038	3	comply
comport	13	36	1684	3	comport
compose	13	57	1666	3	compose
compost	13	45	1535	3	compost
compote	13	56	1646	3	compote
compound	15	5	599	3	compound
comps	11	55	2605	3	comp_s
compt	11	63	2822	3	comp_t
compts	12	52	1665	3	compts
coon	6	72	4894	3	co__on
copen	9	48	2643	3	co_pen
cordon	9	50	1729	3	cordon
cotton	8	3	1299	3	cotton
coupons	11	27	1056	3	coupons
cowpox	20	3	500	3	cowpox
coypou	13	26	840	3	coypou
crampon	13	3	694	3	crampon
crepon	10	3	994	3	crepon
dampen	11	43	1059	3	dampen
damson	9	3	806	3	damson
demon	8	65	2031	3	dem_on
doblon	9	3	801	3	doblon
dobson	9	3	659	3	dobson
domain	9	5	1132	3	domain
domino	9	26	1149	3	domino
donjon	14	3	646	3	donjon
dromon	9	3	936	3	drom_on
foison	9	4	893	3	foison
gammon	11	3	890	3	gammon
gipon	8	42	1241	3	_gipon
gnomon	9	3	618	3	gnom_on
godson	8	5	738	3	godson
gombo	10	58	1404	3	gombo_
gombos	11	43	1109	3	gombos
gonion	7	36	1283	3	gonion
goon	5	72	3617	3	go__on
gorgon	8	3	1024	3	gorgon
hempen	13	3	896	3	hempen
holpen	11	29	941	3	holpen
hommos	13	12	850	3	hommos
homo	9	61	2647	3	hom_o_
homos	10	59	2179	3	hom_os
hoopoe	11	9	1123	3	hoopoe
hoopoo	11	9	875	3	hoopoo
impone	10	30	1186	3	_impone
joypop	20	6	313	3	joypop
jupon	14	47	919	3	_jupon
kampong	16	29	493	3	kampong
lampion	11	27	830	3	lampion
lampoon	11	26	719	3	lampoon
lemon	7	56	1818	3	lem_on
logion	7	60	1372	3	logion
logon	6	159	2231	3	lo_gon
lomein	8	4	1020	3	lomein
loon	4	73	4479	3	lo__on
lotion	6	57	1652	3	lotion
loupen	8	45	1029	3	loupen
lumpen	10	40	1066	3	lumpen
mammon	9	3	964	3	mammon
mon	5	75	6158	3	__m_on
moon	6	71	4081	3	__moon
morion	8	62	1773	3	morion
moron	7	69	2542	3	mo_ron
motion	8	52	1755	3	motion
mouton	8	4	1085	3	mouton
muon	6	57	2273	3	__muon
nomen	7	56	2162	3	nom_en
nomoi	7	60	1253	3	nom_oi
nomos	7	59	1974	3	nom_os
noon	4	71	3462	3	no__on
notion	6	45	1658	3	notion
odeon	6	4	1148	3	_odeon
omen	6	68	2818	3	_om_en
onion	5	43	2097	3	_onion
oompah	13	3	425	3	oompah
oomph	12	3	697	3	oomp_h
oomphs	13	4	472	3	oomphs
open	6	64	2700	3	_o_pen
operon	8	8	1177	3	operon
option	8	36	1271	3	option
orlon	5	4	1500	3	_orlon
orpin	7	34	1553	3	_orpin
paeon	7	48	1949	3	p_aeon
pampa	11	49	1342	3	pamp_a
pampas	12	49	1399	3	pampas
pampean	13	3	554	3	pampean
pamper	12	43	1666	3	pamper
pardon	9	46	1873	3	pardon
parson	8	38	1790	3	parson
parton	8	47	2099	3	parton
patron	8	40	1804	3	patron
pelon	7	44	2321	3	p_elon
pennon	8	3	1064	3	pennon
peon	6	56	3524	3	p__eon
pepo	8	76	2215	3	p_epo_
pepos	9	66	2008	3	p_epos
pereon	8	35	1745	3	pereon
perron	8	32	1662	3	perron
person	8	35	1787	3	person
phon	9	59	2538	3	p__hon
phonon	11	40	1203	3	phonon
photon	11	115	1483	3	photon
phylon	14	31	803	3	phylon
phyton	14	36	1025	3	phyton
pigeon	9	4	941	3	pigeon
pigpen	11	3	658	3	pigpen
pimp	10	60	2490	3	pimp__
pimped	13	49	1348	3	pimped
pimping	14	38	1212	3	pimping
pimple	12	35	1296	3	pimple
pimply	15	32	921	3	pimply
pimps	11	46	1698	3	pimp_s
pinion	8	38	1589	3	pinion
pinon	7	60	2453	3	p_inon
pinyon	11	45	976	3	pinyon
pion	6	72	3529	3	p__ion
pippin	9	28	1030	3	pippin
piston	8	35	1592	3	piston
piton	7	61	2158	3	p_iton
pleon	7	42	1638	3	p_leon
plosion	9	3	911	3	plosion
plumpen	13	27	640	3	plumpen
pluton	8	3	885	3	pluton
poboy	12	16	1222	3	po_boy
poco	8	68	2615	3	po_co_
pocoson	11	5	675	3	pocoson
podsol	9	4	685	3	podsol
podzol	18	3	508	3	podzol
pogrom	11	3	859	3	pogrom
poisons	9	3	1035	3	poisons
polaron	9	3	984	3	polaron
poleyn	11	5	732	3	poleyn
polio	7	57	2255	3	polio_
polios	8	40	1972	3	polios
pollen	8	34	1645	3	pollen
polo	6	62	3663	3	po_lo_
polos	7	61	2991	3	po_los
polygon	13	4	693	3	polygon
polyol	11	3	871	3	polyol
polypod	15	4	698	3	polypod
pom	7	82	4991	3	pom___
pomace	12	31	1191	3	pomace
pomade	11	36	1133	3	pomade
pome	8	56	3669	3	pom__e
pomelo	10	23	866	3	pomelo
pomelos	11	21	813	3	pomelos
pomes	9	48	3393	3	pom_es
pommee	12	28	1328	3	pommee
pommel	12	27	745	3	pommel
pommie	12	37	1050	3	pommie
pommy	14	44	986	3	pom_my
pompanos	14	4	524	3	pompanos
poms	8	70	3774	3	pom__s
pontons	9	33	1555	3	pontons
pontoon	9	30	1070	3	pontoon
poo	5	77	5711	3	po__o_
pood	7	59	3432	3	po__od
poof	9	55	4166	3	po__of
pooh	9	60	2738	3	po__oh
pool	6	58	3595	3	po__ol
poons	7	54	3097	3	po__ons
poop	8	65	3281	3	po__op
pooped	11	39	1594	3	pooped
pooping	12	36	1544	3	pooping
poops	9	44	2241	3	poop_s
poor	6	56	3022	3	po__or
poos	6	59	4911	3	po__os
pop	7	62	5225	3	po_p__
popcorn	13	4	490	3	popcorn
pope	8	55	3561	3	po_p_e
popes	9	59	3381	3	po_pes
popgun	11	4	573	3	popgun
poplin	10	4	1348	3	poplin
poppa	8	40	989	3	po_ppa
poppas	9	37	1071	3	poppas
popped	10	41	1781	3	popped
popper	9	36	1596	3	popper
poppet	9	27	1732	3	poppet
popping	11	37	1541	3	popping
popple	9	27	1098	3	popple
poppy	11	48	1319	3	po_ppy
pops	8	63	4095	3	po_p_s
popsy	12	57	1340	3	po_psy
porn	6	56	3602	3	po__rn
porno	7	51	2065	3	porno_
pornos	8	50	1525	3	pornos
portion	9	6	1549	3	portion
postin	8	35	2103	3	postin
postop	10	5	1194	3	postop
postpone	12	4	869	3	postpone
potboy	13	9	781	3	potboy
poteen	8	35	1426	3	poteen
pothos	11	42	1469	3	pothos
potions	9	34	1742	3	potions
potman	10	28	1357	3	potman
potmen	10	27	1309	3	potmen
potpie	10	34	1243	3	potpie
potto	7	53	2094	3	potto_
pottos	8	46	1587	3	pottos
powwow	13	4	283	3	powwow
poyou	10	26	1152	3	po_you
prion	7	51	1999	3	p_rion
prison	8	5	1402	3	prison
promo	9	56	2000	3	prom_o_
promos	10	51	1642	3	prom_os
prompt	12	3	1301	3	promp_t
prompts	13	3	747	3	prompts
propman	13	3	906	3	propman
propmen	13	3	876	3	propmen
propone	11	27	1630	3	propone
proton	8	43	1889	3	proton
psammon	13	4	254	3	psammon
ptomain	11	4	696	3	ptomain
pump	10	57	2685	3	pump__
pumped	13	39	1556	3	pumped
pumper	12	44	1555	3	pumper
pumping	14	42	1355	3	pumping
pumpkin	17	4	352	3	pumpkin
pumps	11	55	2060	3	pump_s
puton	7	36	1791	3	p_uton
pylon	10	36	1400	3	p_ylon
python	14	4	714	3	python
rampion	11	29	858	3	rampion
ramson	8	3	1046	3	ramson
roman	7	54	2482	3	rom_an
romano	8	49	1294	3	romano
romeo	7	37	1970	3	romeo_
romeos	8	40	1317	3	romeos
romp	8	59	2657	3	romp__
romped	11	45	1365	3	romped
romper	10	42	1368	3	romper
romping	12	31	1303	3	romping
romps	9	46	1754	3	romp_s
ronion	6	33	1564	3	ronion
ronyon	9	30	913	3	ronyon
sampan	10	25	1189	3	sampan
simoon	8	5	806	3	simoon
solion	6	6	1638	3	solion
solon	5	50	2613	3	so_lon
soman	7	50	2490	3	som_an
someone	9	3	881	3	someone
somoni	8	3	1074	3	som_oni
soon	4	62	4050	3	so__on
sopor	7	40	1649	3	so_por
soupcon	11	4	416	3	soupcon
sponson	9	3	538	3	sponson
spoon	7	47	1944	3	spo__on
summon	10	3	762	3	summon
tampan	10	25	1232	3	tampan
tampion	11	29	866	3	tampion
tampons	11	27	1156	3	tampons
tarpon	8	28	1280	3	tarpon
tempo	9	52	1497	3	tempo_
tempos	10	38	1229	3	tempos
toman	7	57	2405	3	tom_an
tomboy	13	5	821	3	tomboy
tomcod	11	3	578	3	tomcod
tompions	12	26	700	3	tompions
toon	4	77	4063	3	to__on
topo	6	69	3240	3	to_po_
topoi	7	60	1835	3	to_poi
topos	7	57	2639	3	to_pos
torpor	8	3	919	3	torpor
toyon	8	67	1567	3	to_yon
tympan	13	25	701	3	tympan
upon	6	58	1758	3	__upon
voudon	10	3	587	3	voudon
weapon	11	28	811	3	weapon
woman	10	58	1800	3	wom_an
women	10	46	1925	3	wom_en
womyn	13	42	636	3	wom_yn
wonton	9	34	1096	3	wonton
yapon	10	46	1358	3	_yapon
yaupon	11	34	549	3	yaupon
youpons	12	26	598	3	youpons
yupon	10	46	948	3	_yupon
zoon	13	73	2698	3	zo__on

Search took 8 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.410	435831.7
2	DLD Change Limit	112716	331	6.750	16698.7
3	Display Results	331	331	0.106	3122.6
	(SQL Overall)	178691	331	7.266	24592.8