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

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

320 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
pioneer	9	3	689	(None)
pioneers	10	3	586	1	pioneers
phonier	12	27	1063	2	phonier
pickeer	15	37	1011	2	pickeer
pincer	10	40	1917	2	pi_ncer
pinder	9	45	2345	2	pi_nder
pinger	9	43	2409	2	pi_nger
pinier	8	40	2469	2	pi_nier
pinker	12	53	2244	2	pi_nker
pinner	8	45	2150	2	pi_nner
pioneered	12	5	373	2	pioneered
pointer	9	38	1493	2	pointer
ponder	9	45	2169	2	p_onder
atoner	6	48	1719	3	aton_er
binder	9	44	2287	3	bi_nder
biner	7	59	3069	3	bi_n_er
binger	9	49	2345	3	bi_nger
biometer	12	3	960	3	biometer
blonder	10	40	1194	3	blonder
bonder	9	53	2478	3	_bonder
boner	7	51	3308	3	_bon_er
boneyer	12	3	740	3	_boneyer
bonier	8	43	2199	3	_bonier
bonzer	17	53	1367	3	_bonzer
bronzer	18	34	849	3	bronzer
cinder	9	41	1912	3	ci_nder
cloner	8	44	1809	3	clon_er
coiner	8	43	2378	3	coin_er
coinfer	12	41	939	3	coinfer
cointer	9	36	1672	3	cointer
confer	11	40	1868	3	_confer
conger	9	50	2427	3	_conger
conker	12	47	2155	3	_conker
conner	8	44	2396	3	_conner
diner	6	56	3290	3	di_n_er
dinger	8	53	2367	3	di_nger
dinner	7	42	1716	3	di_nner
diopter	10	3	847	3	diopter
donee	6	69	3101	3	_donee_
donees	7	45	1949	3	_donees
droner	7	47	1767	3	dron_er
finder	10	40	2023	3	fi_nder
finer	8	54	3156	3	fi_n_er
finger	10	49	2033	3	fi_nger
finnier	10	31	995	3	finnier
fonder	10	41	2006	3	_fonder
fronter	10	36	1158	3	fronter
ginger	8	49	2003	3	gi_nger
ginner	7	39	1582	3	gi_nner
ginnier	8	29	898	3	ginnier
goner	6	60	2516	3	_gon_er
goonier	8	36	1284	3	goonier
hinder	10	41	2006	3	hi_nder
hinger	10	47	2333	3	hi_nger
hinter	9	40	2130	3	hi_nter
honer	8	53	3209	3	_hon_er
honker	13	41	1746	3	_honker
infer	8	42	1503	3	_i_nfer
inker	9	44	2109	3	_i_nker
inner	5	49	2063	3	_i_nner
inter	5	50	2849	3	_i_nter
ionizer	16	23	1012	3	_ionizer
ionomer	9	3	983	3	_ionomer
ironer	6	42	1645	3	iron_er
jinker	17	40	1354	3	ji_nker
jinnee	13	4	1157	3	jinnee_
joinder	15	33	759	3	joinder
joiner	13	41	1413	3	join_er
jointer	14	37	971	3	jointer
kinder	11	37	1684	3	ki_nder
kroner	10	46	1257	3	kron_er
limner	8	41	1287	3	limn_er
linear	6	51	1334	3	li_near
liner	5	59	3892	3	li_n_er
linger	7	52	2600	3	li_nger
linier	6	44	2379	3	li_nier
linker	10	43	2147	3	li_nker
linter	6	46	2534	3	li_nter
lioness	7	3	910	3	lioness
lioniser	8	4	558	3	lioniser
lionizer	17	5	605	3	lionizer
livener	10	27	894	3	livener
loner	5	54	3104	3	_lon_er
longer	7	58	2320	3	_longer
loonier	7	33	1268	3	loonier
mijnheer	20	4	147	3	mijnheer
mincer	10	40	1736	3	mi_ncer
minder	9	48	2250	3	mi_nder
miner	7	69	3354	3	mi_n_er
minter	8	44	2510	3	mi_nter
moneyer	12	3	790	3	_moneyer
monger	9	44	1833	3	_monger
mooner	8	53	1783	3	moon_er
moonier	9	37	1410	3	moonier
optionee	10	4	651	3	optionee_
optionees	11	4	434	3	optionees
painter	9	38	1456	3	painter
pander	9	37	2552	3	p_ander
panier	8	44	2550	3	p_anier
panner	8	42	2476	3	p_anner
pannier	9	36	1335	3	pannier
panzer	17	42	1323	3	p_anzer
pawnee	11	31	1540	3	pawnee_
pawnees	12	29	817	3	pawnees
pawner	11	42	1292	3	pawn_er
peer	6	62	3835	3	p___eer
penner	8	46	1666	3	p_enner
peones	8	38	2104	3	peon_es
peonies	9	36	2015	3	peonies
peopler	11	3	808	3	peopler
phone	10	56	2193	3	phon_e_
phoned	12	40	1455	3	phon_ed
phoneme	14	4	620	3	phoneme
phonemes	15	4	619	3	phonemes
phones	11	41	2121	3	phon_es
phoney	14	36	1298	3	phon_ey
phoneyed	17	4	384	3	phoneyed
phoneys	15	43	714	3	phoneys
phonied	13	37	1056	3	phonied
phonies	12	37	1751	3	phonies
piaffer	15	10	444	3	piaffer
piaster	9	30	1288	3	piaster
pickeers	16	34	724	3	pickeers
picker	14	44	2217	3	pi_cker
picketer	16	18	743	3	picketer
pickier	15	39	1297	3	pickier
picometer	15	4	891	3	picometer
picotee	11	3	1147	3	picotee_
picotees	12	4	711	3	picotees
piddler	11	29	1152	3	piddler
piecer	10	52	1308	3	pi_ecer
pier	6	60	3529	3	pi___er
piercer	11	33	777	3	piercer
piggier	11	35	1000	3	piggier
pigweed	14	6	509	3	pigweed
piker	11	56	2284	3	pi__ker
pilfer	11	3	916	3	pi_lfer
pilferer	13	4	492	3	pilferer
pilsener	10	4	475	3	pilsener
pilsner	9	3	534	3	pilsner
pincers	11	39	1650	3	pi_ncers
pincher	14	38	1271	3	pincher
pinders	10	37	2047	3	pi_nders
pine	6	77	5571	3	pi_n_e_
pineal	8	48	1768	3	pi_neal
pined	8	59	3532	3	pi_n_ed
pinene	8	29	1564	3	pi_nene
pinenes	9	34	1667	3	pi_nenes
pinery	11	52	1429	3	pi_nery
pines	7	60	4886	3	pi_n_es
pineta	8	58	1556	3	pi_neta
piney	10	57	2750	3	pi_n_ey
pinged	10	43	2138	3	pi_nged
pingers	10	40	2074	3	pi_ngers
pinked	13	48	1988	3	pi_nked
pinken	12	45	1328	3	pi_nken
pinkers	13	41	1860	3	pi_nkers
pinkey	15	43	1467	3	pi_nkey
pinnae	8	44	1464	3	pinnae_
pinned	9	48	1838	3	pi_nned
pinners	9	35	1860	3	pinners
pinnies	9	33	1844	3	pinnies
pinole	8	32	1878	3	pinole_
pinoles	9	34	1870	3	pinoles
pinones	9	47	1707	3	pinones
pinweed	13	4	693	3	pinweed
piolet	8	32	2564	3	pio_let
piolets	9	35	1319	3	piolets
pion	6	72	3529	3	pion___
pioneering	13	5	439	3	pioneer~~ing~~
pionic	10	35	1595	3	pion_ic
pions	7	58	2639	3	pion__s
piper	9	65	2319	3	pi__per
pipier	10	49	1398	3	pi_pier
pisher	11	43	1775	3	pi_sher
pisser	8	44	1638	3	pi_sser
pistoleer	11	4	431	3	pistoleer
pitcher	14	38	1371	3	pitcher
pithier	12	30	1029	3	pithier
pitier	8	40	1982	3	pi_tier
planer	8	41	2265	3	plan_er
planner	9	35	1162	3	planner
planter	9	40	1780	3	planter
plinker	13	40	1096	3	plinker
plodder	11	4	600	3	plodder
plonked	14	34	810	3	plonked
plotter	9	41	1366	3	plotter
plover	11	53	1261	3	plo_ver
plower	11	43	1506	3	plo_wer
plunder	10	38	1050	3	plunder
plunger	10	42	1124	3	plunger
plunker	13	39	1065	3	plunker
poinded	11	35	897	3	poinded
pointe	8	46	1931	3	pointe_
pointed	10	38	1398	3	pointed
pointers	10	30	1372	3	pointers
pointes	9	32	1675	3	pointes
pointier	10	3	830	3	pointier
poiser	8	42	1724	3	p_oiser
poisoner	10	4	698	3	poison_er
poker	11	51	2288	3	p_o_ker
pokier	12	49	1463	3	p_okier
polder	9	40	1925	3	p_older
poler	7	44	3179	3	p_o_ler
poller	8	39	2185	3	p_oller
ponce	9	52	2251	3	p_once_
ponced	11	43	1481	3	p_onced
ponces	10	47	2084	3	p_onces
ponded	10	52	1877	3	p_onded
ponderer	11	24	1019	3	p_onderer
ponders	10	36	1884	3	p_onders
pone	6	57	4753	3	p_on_e_
ponent	8	28	2159	3	p_onent
pones	7	45	4704	3	p_on_es
ponged	10	56	1935	3	p_onged
pongee	9	49	2019	3	p_ongee
pongees	10	42	1254	3	p_ongees
ponied	9	49	2070	3	p_onied
ponies	8	48	3346	3	p_onies
pontes	8	36	2785	3	p_ontes
poofter	12	3	716	3	poofter
pooler	8	38	1984	3	p_ooler
poorer	8	26	1399	3	p_oorer
popper	9	36	1596	3	p_opper
porker	12	49	1754	3	p_orker
pornier	9	34	1313	3	pornier
porter	8	42	2441	3	p_orter
poser	7	51	2877	3	p_o_ser
poseur	8	41	940	3	p_oseur
posher	11	50	1816	3	p_osher
poster	8	41	2917	3	p_oster
poteen	8	35	1426	3	p_oteen
pother	11	38	1885	3	p_other
potter	8	39	2698	3	p_otter
potzer	17	44	1121	3	p_otzer
pouncer	11	35	1123	3	pouncer
pounder	10	33	1400	3	pounder
pourer	8	45	1604	3	p_ourer
pouter	8	39	2398	3	p_outer
powder	12	36	1190	3	p_owder
power	10	53	2595	3	p_o_wer
powter	11	41	1603	3	p_owter
poxier	15	38	1211	3	p_oxier
prancer	11	36	1338	3	prancer
preener	9	31	1483	3	preener
prinker	13	34	1274	3	prinker
printer	9	39	1730	3	printer
prisoner	10	4	857	3	prison_er
prober	10	45	1607	3	pro_ber
proceed	12	3	1055	3	proceed
prodder	11	4	795	3	prodder
proffer	15	12	693	3	proffer
progger	11	31	937	3	progger
prone	7	53	3262	3	pron_e_
pronely	12	3	1025	3	pronely
pronged	11	39	1239	3	pronged
proofer	12	14	910	3	proofer
proper	10	43	1995	3	pro_per
properer	12	5	920	3	properer
proser	8	42	2346	3	pro_ser
prosier	9	38	1748	3	prosier
prosper	11	40	1219	3	prosper
prouder	10	3	1038	3	prouder
prover	11	38	1972	3	pro_ver
prower	11	42	1812	3	pro_wer
prowler	12	33	1001	3	prowler
pruner	8	34	1345	3	prun_er
punier	8	45	1922	3	p_unier
punker	12	37	1882	3	p_unker
punner	8	49	1815	3	p_unner
punnier	9	35	1126	3	punnier
punter	8	43	2002	3	p_unter
ringer	7	45	2606	3	ri_nger
rinser	6	43	1721	3	ri_nser
rioter	6	48	1728	3	rio_ter
ripener	9	3	790	3	ripener
signee	7	36	1723	3	signee_
signees	8	35	1080	3	signees
signer	7	40	1563	3	sign_er
singer	7	42	2731	3	si_nger
sinker	10	36	2090	3	si_nker
sinner	6	43	2060	3	si_nner
sinter	6	36	2592	3	si_nter
sneer	5	49	1995	3	__sneer
sonder	7	36	2352	3	_sonder
sooner	6	42	2046	3	soon_er
spinier	9	37	1516	3	spi_nier
spinner	9	39	1226	3	spi_nner
sponger	10	3	852	3	sponger
spoonier	10	16	765	3	spoonier
stoner	6	58	2320	3	ston_er
stonier	7	20	1379	3	stonier
tinder	7	38	2180	3	ti_nder
tinier	6	36	2223	3	ti_nier
tinker	10	36	1992	3	ti_nker
tinner	6	41	1996	3	ti_nner
tinnier	7	29	1014	3	tinnier
tinter	6	39	2364	3	ti_nter
toner	5	53	3624	3	_ton_er
tonger	7	47	1968	3	_tonger
tonier	6	55	2071	3	_tonier
tonner	6	48	1920	3	_tonner
veneer	9	45	1169	3	_veneer
vinier	9	37	1674	3	vi_nier
widener	11	31	869	3	widener
wiener	9	45	1354	3	wien_er
wincer	11	50	1819	3	wi_ncer
winder	10	40	2526	3	wi_nder
winger	10	41	2544	3	wi_nger
winier	9	45	2245	3	wi_nier
winker	13	42	2029	3	wi_nker
winner	9	42	1993	3	wi_nner
winter	9	42	2280	3	wi_nter
wonder	10	36	1781	3	_wonder
wonner	9	51	1444	3	_wonner
wronger	11	28	882	3	wronger
yonder	10	32	1413	3	_yonder
yonker	13	41	1085	3	_yonker
zinger	16	38	1670	3	zi_nger
zoner	14	45	2034	3	_zon_er

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	134027	0.390	458182.1
2	DLD Change Limit	134027	320	5.923	22628.2
3	Display Results	320	320	0.106	3018.9
	(SQL Overall)	178691	320	6.419	27837.8