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

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

414 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
planch	13	37	1144	(None)
blanch	13	34	1085	1	blanch
planche	14	29	975	1	planche
plench	13	40	1081	1	plench
blench	13	37	1045	2	blench
branch	13	40	1477	2	branch
clach	12	46	1782	2	cla_ch
clench	13	39	1005	2	clench
clinch	13	39	1035	2	clinch
cranch	13	36	1353	2	cranch
flench	14	40	1081	2	flench
flinch	14	40	1010	2	flinch
glance	9	43	1231	2	glance
glunch	12	5	535	2	glunch
klatch	15	44	593	2	klatch
laich	10	59	2071	2	_laich
lance	7	51	2672	2	_lance
larch	10	59	1979	2	_larch
latch	10	46	2046	2	_latch
launch	11	36	806	2	_launch
lunch	10	49	1724	2	_lunch
lynch	13	46	898	2	_lynch
painch	13	35	1132	2	painch
parch	12	51	2300	2	p_arch
patch	12	52	2122	2	p_atch
paunch	13	36	985	2	paunch
peach	12	54	2249	2	pea_ch
pinch	12	56	1930	2	p_inch
place	9	48	2461	2	pla_ce
plack	13	50	1784	2	pla_ck
plaice	10	3	1155	2	plaice
plan	6	58	3394	2	plan__
planar	8	42	1271	2	planar
planches	15	31	1186	2	planches
planchet	15	25	1196	2	planchet
plane	7	49	2914	2	plan_e
planed	9	44	2091	2	planed
planer	8	41	2265	2	planer
planes	8	50	2808	2	planes
planet	8	42	2835	2	planet
planish	12	4	1205	2	planish
plank	11	52	2114	2	plan_k
planks	12	41	1675	2	planks
plans	7	57	3127	2	plan_s
plant	7	54	3711	2	plan_t
plants	8	49	2180	2	plants
plash	10	46	1656	2	pla_sh
pleach	13	42	1124	2	pleach
pliancy	14	3	559	2	pliancy
plinth	11	3	1045	2	plinth
poach	12	49	1786	2	poa_ch
prance	10	43	1857	2	prance
punch	12	51	1842	2	p_unch
ranch	10	50	1979	2	_ranch
slatch	11	45	1053	2	slatch
stanch	11	38	1237	2	stanch
alack	11	48	2006	3	ala_ck
alan	4	68	4408	3	alan__
aland	6	55	2641	3	alan_d
alands	7	54	1837	3	alands
alane	5	61	3561	3	alan_e
alang	6	60	2351	3	alan_g
alanin	6	3	1727	3	alanin
alans	5	56	3617	3	alan_s
alant	5	57	4229	3	alan_t
alants	6	77	2202	3	alants
alanyl	9	5	548	3	alanyl
anarch	11	3	1039	3	anarch
ancho	10	45	1530	3	__ancho
ankh	11	11	1441	3	__ankh
arch	9	86	2844	3	__arch
bach	11	61	3139	3	_ba_ch
balance	11	5	1026	3	balance
banco	9	40	1939	3	_banco
batch	12	46	2010	3	_batch
beach	12	46	2389	3	bea_ch
bench	12	56	1950	3	_bench
black	13	47	1907	3	bla_ck
blah	9	86	2506	3	bla__h
blanched	16	30	860	3	blanched
blancher	15	33	863	3	blancher
blanches	15	33	1160	3	blanches
bland	8	53	2045	3	blan_d
blank	11	54	1855	3	blan_k
blanks	12	41	1289	3	blanks
bleach	13	36	1140	3	bleach
blotch	13	19	714	3	blotch
brach	12	61	2330	3	bra_ch
branchy	17	35	791	3	branchy
brunch	13	32	935	3	brunch
bunch	12	51	1860	3	_bunch
cancha	13	44	1161	3	_cancha
catch	12	51	2037	3	_catch
chance	13	46	1709	3	chance
chancy	16	40	1086	3	chancy
chinch	16	39	1123	3	chinch
cinch	12	45	1624	3	_cinch
clachs	13	35	1132	3	cla_chs
clack	13	47	2017	3	cla_ck
clan	6	56	3392	3	clan__
clang	8	60	1931	3	clan_g
clangs	9	51	1361	3	clangs
clank	11	47	1952	3	clan_k
clanks	12	46	1518	3	clanks
clanky	15	46	907	3	clanky
clans	7	50	3101	3	clan_s
clash	10	62	1903	3	cla_sh
claucht	14	4	558	3	claucht
clutch	13	36	775	3	clutch
coach	12	59	1945	3	coa_ch
conch	12	46	2007	3	_conch
cratch	13	41	1079	3	cratch
craunch	14	6	444	3	craunch
crunch	13	34	950	3	crunch
dance	8	52	2313	3	_dance
drench	12	36	959	3	drench
dunch	11	53	1626	3	_dunch
each	9	55	3058	3	_ea_ch
elan	4	67	3424	3	elan__
eland	6	58	2039	3	elan_d
elands	7	49	1477	3	elands
elans	5	55	2775	3	elan_s
elenchi	12	4	471	3	elenchi
eparch	13	25	842	3	eparch
exarch	18	19	617	3	exarch
fancy	13	46	1548	3	_fancy
fiance	11	3	1074	3	fiance
finch	13	54	1697	3	_finch
flack	14	45	1941	3	fla_ck
flan	7	61	3418	3	flan__
flanes	9	45	2242	3	flanes
flange	10	34	1197	3	flange
flank	12	46	1809	3	flan_k
flanks	13	39	1340	3	flanks
flans	8	53	2797	3	flan_s
flash	11	57	1621	3	fla_sh
fleech	14	36	734	3	fleech
fletch	14	38	819	3	fletch
flitch	14	92	817	3	flitch
flysch	17	3	289	3	flysch
franc	10	46	1541	3	franc_
francs	11	41	1219	3	francs
french	14	35	1121	3	french
glace	8	74	2015	3	gla_ce
glanced	11	43	923	3	glanced
glancer	10	37	1007	3	glancer
glances	10	41	1314	3	glances
gland	7	52	1771	3	glan_d
glands	8	53	1440	3	glands
glans	6	51	2583	3	glan_s
glitch	12	28	635	3	glitch
grinch	12	3	847	3	grinch
hance	10	54	2415	3	_hance
hatch	13	57	1959	3	_hatch
haunch	14	37	734	3	haunch
hunch	13	64	1621	3	_hunch
inarch	11	3	917	3	inarch
inch	9	54	2082	3	__inch
kench	14	55	1392	3	_kench
klatsch	16	5	168	3	klatsch
lac	5	101	5582	3	_la_c_
lace	6	68	4847	3	_la_ce
lack	10	58	3768	3	_la_ck
lacs	6	69	4248	3	_la_cs
lacy	9	58	2963	3	_la_cy
laic	6	59	3156	3	_laic_
laichs	11	51	1089	3	_laichs
laics	7	64	1925	3	_laics
laigh	9	55	1592	3	_laigh
laith	8	57	2210	3	_laith
lakh	11	49	1995	3	_la_kh
lanai	5	3	1957	3	_lanai
lanced	9	37	1772	3	_lanced
lancer	8	43	1997	3	_lancer
lances	8	48	2410	3	_lances
lancet	8	42	2357	3	_lancet
land	5	63	3731	3	_lan_d
lands	6	54	2690	3	_lands
lane	4	51	5333	3	_lan_e
lanes	5	49	4679	3	_lanes
lang	5	66	3738	3	_lan_g
lank	8	47	3445	3	_lan_k
lanky	12	55	1748	3	_lanky
lash	7	65	3965	3	_la_sh
lath	7	66	4038	3	_la_th
laugh	9	44	1437	3	_laugh
launce	8	46	918	3	_launce
leach	10	54	2252	3	_leach
lech	9	68	2544	3	_l_ech
leech	10	49	1321	3	_leech
letch	10	52	1580	3	_letch
lich	9	62	3084	3	_l_ich
llano	5	9	1060	3	llan_o
llanos	6	10	833	3	llanos
loach	10	51	1636	3	_loach
loch	9	55	2713	3	_l_och
lurch	10	48	1463	3	_lurch
lych	12	60	1576	3	_l_ych
mach	11	61	3448	3	_ma_ch
manche	13	35	1510	3	_manche
march	12	56	2289	3	_march
match	12	56	2110	3	_match
munch	12	49	1710	3	_munch
nance	7	47	2184	3	_nance
nancy	10	52	1492	3	_nancy
natch	10	50	1822	3	_natch
nuance	8	5	904	3	nuance
orach	10	52	1923	3	ora_ch
pac	7	90	5408	3	p_a_c_
paca	8	51	3224	3	p_a_ca
pace	8	63	4577	3	p_a_ce
pacha	12	65	1806	3	p_a_cha
pack	12	55	3544	3	p_a_ck
pacs	8	58	4218	3	p_a_cs
pact	8	66	4872	3	p_a_ct
pacy	11	53	2868	3	p_a_cy
pah	8	88	5359	3	p_a__h
palace	10	45	1691	3	palace
palish	11	47	1827	3	palish
pan	5	84	6645	3	p_an__
panache	14	5	842	3	p_anache
panchax	21	3	498	3	p_anchax
panda	8	50	2261	3	p_anda
pandy	11	50	2117	3	p_andy
pane	6	49	5029	3	p_an_e
paned	8	54	3718	3	p_aned
panel	7	60	2362	3	p_anel
panes	7	61	4869	3	p_anes
pang	7	53	3629	3	p_an_g
panga	8	53	2353	3	p_anga
pangs	8	46	2866	3	p_angs
panic	9	39	2390	3	p_anic
panics	10	38	1536	3	p_anics
panne	7	66	2365	3	p_anne
panocha	14	4	498	3	p_anocha
panoche	14	5	638	3	p_anoche
pans	6	58	5573	3	p_an_s
pansy	10	57	1797	3	p_ansy
pant	6	60	6126	3	p_an_t
panto	7	61	2941	3	p_anto
pants	7	65	3692	3	p_ants
panty	10	59	2930	3	p_anty
parlance	12	4	872	3	parlance
pash	9	56	3813	3	p_a_sh
patchy	16	50	957	3	p_atchy
path	9	91	3491	3	p_a_th
paunchy	17	32	444	3	paunchy
peace	9	50	2608	3	pea_ce
peachy	16	45	1084	3	pea_chy
pean	6	61	4717	3	pean__
peans	7	54	3764	3	pean_s
peanut	8	3	1818	3	peanut
pech	11	61	2545	3	p__ech
penance	11	3	1344	3	penance
pence	9	49	2445	3	p_ence
perch	12	45	1883	3	p_erch
pian	6	61	3609	3	pian__
pianic	10	37	1412	3	pianic
piano	7	61	1871	3	pian_o
pianos	8	43	1593	3	pianos
pians	7	51	2696	3	pian_s
pitch	12	50	1841	3	p_itch
placed	11	43	1800	3	placed
placer	10	51	1774	3	placer
places	10	43	2370	3	places
placet	10	39	2367	3	placet
placid	11	40	1254	3	placid
placks	14	44	1415	3	placks
plagal	9	4	857	3	plagal
plage	8	45	2040	3	pla_ge
plages	9	45	2015	3	plages
plague	9	36	1085	3	plague
plaguy	12	38	641	3	plaguy
plaices	11	4	1114	3	plaices
plaid	8	51	1830	3	pla_id
plaids	9	43	1244	3	plaids
plain	7	48	2330	3	pla_in
plained	10	38	1223	3	plained
plainer	9	38	1198	3	plainer
plainly	12	3	647	3	plainly
plains	8	50	1959	3	plains
plaint	8	53	2320	3	plaint
plaints	9	40	1205	3	plaints
plait	7	56	3157	3	pla_it
plaits	8	38	1647	3	plaits
planate	9	3	1457	3	planate
planchets	16	23	674	3	planch~~ets~~
planers	9	45	1794	3	planers
planets	9	39	1408	3	planets
planing	10	34	1825	3	planing
planked	14	35	1228	3	planked
planned	10	38	1015	3	planned
planner	9	35	1162	3	planner
plantar	9	36	999	3	plantar
planted	10	35	1612	3	planted
planter	9	40	1780	3	planter
planula	9	3	577	3	planula
plaque	17	31	764	3	plaque
plashy	14	44	887	3	plashy
plasm	9	41	1463	3	pla_sm
plasma	10	38	1091	3	plasma
plasms	10	37	1133	3	plasms
plat	6	60	4887	3	pla__t
platan	8	39	1369	3	platan
plate	7	46	3511	3	pla_te
plated	9	52	2577	3	plated
platen	8	45	1820	3	platen
plater	8	44	2769	3	plater
plates	8	54	3224	3	plates
plats	7	55	3137	3	pla_ts
platy	10	50	2166	3	pla_ty
platys	11	45	985	3	platys
play	9	59	2898	3	pla__y
playa	10	58	1294	3	pla_ya
playact	14	4	655	3	playact
playas	11	46	1228	3	playas
played	12	48	1503	3	played
player	11	52	1521	3	player
plays	10	63	2077	3	pla_ys
plaza	16	43	1106	3	pla_za
plazas	17	40	991	3	plazas
plena	7	58	1639	3	plen_a
plenches	15	31	1062	3	plenches
plenish	12	3	994	3	plenish
plenty	11	3	1141	3	plenty
plenum	10	3	950	3	plenum
pliant	8	39	1882	3	plian_t
plica	9	6	1337	3	pl_ica
plink	11	52	1912	3	plin_k
plinks	12	49	1326	3	plinks
plinths	12	3	612	3	plinths
plonk	11	46	1398	3	plon_k
plonks	12	42	1042	3	plonks
plough	12	57	756	3	plough
pluck	13	42	1230	3	pl_uck
plunge	9	38	1105	3	plunge
plunk	11	45	1440	3	plun_k
plunks	12	47	1116	3	plunks
plunky	15	37	795	3	plunky
plush	10	56	1471	3	pl_ush
poachy	16	38	896	3	poa_chy
ponce	9	52	2251	3	p_once
poncho	13	33	1012	3	p_oncho
pooch	12	48	1530	3	p_ooch
porch	12	59	1862	3	p_orch
potlach	14	10	636	3	potla_ch
potlatch	15	4	313	3	potlatch
pouch	12	46	1708	3	p_ouch
pounce	10	52	1409	3	pounce
pranced	12	37	1404	3	pranced
prancer	11	36	1338	3	prancer
prances	11	36	1877	3	prances
prang	8	48	2032	3	pran_g
prangs	9	48	1623	3	prangs
prank	11	50	1945	3	pran_k
pranks	12	48	1472	3	pranks
preach	13	36	1392	3	preach
prelaunch	16	4	215	3	prelaunch
prelunch	15	4	343	3	prelunch
prince	10	41	1476	3	prince
psych	15	5	496	3	p_sych
punchy	16	39	852	3	p_unchy
putsch	13	3	493	3	putsch
quaich	20	4	769	3	quaich
quench	20	3	663	3	quench
rance	7	50	2851	3	_rance
rancho	11	43	1085	3	_rancho
ratch	10	42	2136	3	_ratch
raunch	11	35	843	3	raunch
reach	10	51	2388	3	rea_ch
relaunch	13	5	280	3	relaunch
roach	10	57	1700	3	roa_ch
sangh	9	55	1745	3	_sangh
sauch	10	49	1877	3	_sauch
seance	8	37	1669	3	seance
search	11	33	1242	3	search
slack	11	50	2176	3	sla_ck
slang	6	63	2402	3	slan_g
slangs	7	56	1534	3	slangs
slangy	10	54	1139	3	slangy
slank	9	58	2277	3	slan_k
slant	5	52	3870	3	slan_t
slants	6	48	1908	3	slants
slanty	9	51	1484	3	slanty
slash	8	47	1968	3	sla_sh
slouch	11	43	852	3	slouch
snatch	11	43	1060	3	snatch
spinach	14	3	540	3	spinach
splash	11	6	882	3	spla_sh
splotch	14	4	285	3	splotch
stance	8	43	1691	3	stance
starch	11	30	1320	3	starch
staunch	12	4	427	3	staunch
stench	11	41	1116	3	stench
swatch	14	54	928	3	swatch
synch	13	50	1179	3	_synch
tach	9	61	3275	3	_ta_ch
teach	10	52	2112	3	tea_ch
tench	10	56	2000	3	_tench
thatch	14	3	561	3	thatch
trance	8	47	1876	3	trance
tranche	12	33	1222	3	tranche
trench	11	42	1161	3	trench
ulan	4	65	2739	3	ulan__
ulans	5	49	2130	3	ulan_s
unlatch	12	4	505	3	unlatch
upland	9	3	886	3	uplan_d
uplands	10	3	694	3	uplands
usance	8	5	801	3	usance
valance	12	6	925	3	valance
watch	13	56	1706	3	_watch
wench	13	62	1478	3	_wench
winch	13	50	1666	3	_winch
wrench	14	43	935	3	wrench

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.390	458182.1
2	DLD Change Limit	112716	414	4.923	22895.8
3	Display Results	414	414	0.140	2957.1
	(SQL Overall)	178691	414	5.453	32769.3