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

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

336 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
apache	13	42	1077	(None)
apace	9	47	1838	1	apac_e
apaches	14	34	1183	1	apaches
ache	9	68	2982	2	__ache
apathy	14	3	703	2	apathy
attache	12	10	669	2	attache
cache	12	51	2248	2	_cache
capuche	16	4	443	2	capuche
earache	12	3	932	2	earache
ganache	13	4	620	2	ganache
mache	12	59	2530	2	_mache
orache	11	40	1359	2	orache
pace	8	63	4577	2	_pac_e
pacha	12	65	1806	2	_pacha
panache	14	5	842	2	panache
space	9	53	2567	2	spac_e
spathe	11	51	1569	2	spathe
tache	10	62	2237	2	_tache
aah	6	162	5296	3	a_a_h_
aahed	9	178	1644	3	a_a_hed
aahs	7	164	2856	3	a_a_hs
abaca	9	51	1804	3	abac_a
abacas	10	44	1472	3	abacas
abaci	9	47	1884	3	abac_i
aback	13	48	1617	3	abac_k
abacus	10	34	976	3	abacus
abase	7	60	2348	3	aba_se
abash	10	60	1651	3	abash_
abashed	13	5	766	3	abashed
abashes	12	5	1037	3	abashes
abate	7	66	2784	3	aba_te
acacia	10	3	1135	3	acacia
ace	5	96	5683	3	__ac_e
ached	11	92	2783	3	__ached
aches	10	61	3229	3	__aches
achy	12	63	1609	3	__achy
acme	8	69	2432	3	__acme
acne	6	66	2587	3	__acne
acre	6	73	3077	3	__acre
adage	7	4	1405	3	ada_ge
affiche	18	4	431	3	affiche
agapae	9	38	804	3	agapae
agape	8	56	1484	3	aga_pe
agate	6	65	2515	3	aga_te
agave	9	53	1403	3	aga_ve
agaze	15	61	1366	3	aga_ze
aitch	10	52	1616	3	aitch_
aitches	12	30	1436	3	aitches
alack	11	48	2006	3	alac_k
alae	4	56	4375	3	ala__e
alane	5	61	3561	3	ala_ne
alate	5	53	4032	3	ala_te
alcade	9	11	1151	3	alcade
alpaca	10	4	738	3	alpac_a
alpacas	11	3	707	3	alpacas
amah	9	89	2749	3	ama_h_
amahs	10	78	1906	3	ama_hs
amaze	16	60	1660	3	ama_ze
amice	9	61	2287	3	amic_e
ananke	10	3	828	3	ananke
anarch	11	3	1039	3	anarch_
anarchs	12	3	709	3	anarchs
anarchy	15	4	493	3	anarchy
ancho	10	45	1530	3	a_ncho
anlace	8	25	1392	3	anlac_e
apagoge	11	16	468	3	apagoge
apanage	10	3	680	3	apanage
apart	7	43	3067	3	apa_rt
apathies	13	3	900	3	apathies
apatite	9	3	1296	3	apatite
ape	5	72	5118	3	ap___e
aphtha	14	4	448	3	aphtha
aphthae	15	4	470	3	aphthae
apical	10	9	1390	3	apical
apices	10	49	1626	3	apices
apiece	10	5	1008	3	apiece
apish	10	51	1663	3	apish_
aplite	8	3	1639	3	aplite
apocope	13	4	603	3	apocope
apogee	9	3	1256	3	apogee
apothem	14	4	464	3	apothem
apple	9	45	1767	3	ap_ple
appose	10	4	1199	3	appose
apse	6	77	2538	3	ap__se
arable	8	18	2100	3	arable
arame	7	50	2662	3	ara_me
arcade	9	10	1364	3	arcade
arcane	8	12	1674	3	arcane
arch	9	86	2844	3	a_rch_
arched	12	57	1732	3	a_rched
archer	11	50	1624	3	a_rcher
arches	11	48	2204	3	a_rches
attach	11	11	839	3	attach_
attached	14	16	570	3	attached
attacher	13	12	571	3	attacher
attaches	13	13	772	3	attaches
awake	12	50	1478	3	awa_ke
aware	8	64	2002	3	awa_re
awash	11	66	1316	3	awash_
ayah	10	80	2299	3	aya_h_
ayahs	11	68	1352	3	aya_hs
babiche	16	4	457	3	babiche
bach	11	61	3139	3	_bach_
bached	14	55	1989	3	_bached
baches	13	54	2694	3	_baches
backache	21	12	606	3	backache
bathe	10	58	2288	3	_bathe
beach	12	46	2389	3	beach_
beached	15	45	1655	3	beached
beaches	14	41	2065	3	beaches
beachy	16	40	1125	3	beachy
boche	12	42	1695	3	_boche
brace	9	56	2927	3	brac_e
brach	12	61	2330	3	brach_
braches	14	46	2122	3	braches
brachet	14	40	2031	3	brachet
brachs	13	44	1575	3	brachs
broche	13	36	1210	3	broche
cached	14	54	1920	3	_cached
caches	13	79	2691	3	_caches
cachet	13	45	2641	3	_cachet
caleche	14	29	794	3	caleche
caliche	14	32	995	3	caliche
capable	13	3	1336	3	capable
capuched	18	4	374	3	capuched
capuches	17	3	551	3	capuches
caroche	14	6	924	3	caroche
clach	12	46	1782	3	clach_
clachs	13	35	1132	3	clachs
cliche	13	37	1245	3	cliche
cloche	13	43	1237	3	cloche
coach	12	59	1945	3	coach_
coached	15	33	1384	3	coached
coacher	14	37	1412	3	coacher
coaches	14	40	1869	3	coaches
creche	13	3	1076	3	creche
dace	7	69	3492	3	_dac_e
dacha	11	48	1257	3	_dacha
douche	12	46	1322	3	douche
drachm	14	3	649	3	drachm
each	9	55	3058	3	_each_
earaches	13	4	1130	3	earaches
eche	9	75	2028	3	__eche
epact	9	49	2153	3	epac_t
epacts	10	50	1039	3	epacts
eparch	13	25	842	3	eparch_
eparchs	14	19	624	3	eparchs
eparchy	17	20	475	3	eparchy
epoch	12	4	820	3	epoch_
epochs	13	3	581	3	epochs
face	9	61	4012	3	_fac_e
fiacre	11	3	762	3	fiacre
fiche	13	46	1674	3	_fiche
fleche	14	29	930	3	fleche
ganaches	14	3	741	3	ganaches
gauche	12	3	855	3	gauche
gazpacho	25	5	126	3	gazpacho
glace	8	74	2015	3	glac_e
gouache	13	3	503	3	gouache
grace	8	51	2454	3	grac_e
halacha	15	38	800	3	halacha
headache	17	4	470	3	headache
huarache	16	4	431	3	huarache
kwacha	18	3	298	3	kwacha
lace	6	68	4847	3	_lac_e
laches	11	65	2834	3	_laches
lathe	8	56	2671	3	_lathe
leach	10	54	2252	3	leach_
leached	13	37	1504	3	leached
leacher	12	40	1484	3	leacher
leaches	12	33	1934	3	leaches
leachy	14	41	973	3	leachy
loach	10	51	1636	3	loach_
loaches	12	36	1398	3	loaches
loathe	9	42	1138	3	loathe
louche	11	52	1266	3	louche
mace	8	73	4579	3	_mac_e
mach	11	61	3448	3	_mach_
maches	13	48	2723	3	_maches
macho	12	61	2015	3	_macho
machs	12	57	2256	3	_machs
macle	9	61	2700	3	_macle
manacle	11	3	1028	3	manacle
manche	13	35	1510	3	manche
miche	12	62	1924	3	_miche
naches	11	46	2241	3	_naches
nacho	10	54	1438	3	_nacho
nacre	7	57	1536	3	_nacre
niche	10	50	1679	3	_niche
opah	9	62	1840	3	opa_h_
opahs	10	54	1198	3	opa_hs
opaque	17	3	421	3	opaque
orach	10	52	1923	3	orach_
oraches	12	42	1647	3	oraches
oracle	8	43	1329	3	oracle
pac	7	90	5408	3	_pac__
paca	8	51	3224	3	_pac_a
pacas	9	60	2940	3	_pacas
paced	10	69	3168	3	_paced
pacer	9	61	3161	3	_pacer
paces	9	67	4111	3	_paces
pacey	12	67	2028	3	_pacey
pachas	13	50	1714	3	_pachas
pacier	10	50	1868	3	_pacier
pack	12	55	3544	3	_pac_k
packed	15	48	2260	3	_packed
packer	14	42	2340	3	_packer
packet	14	47	2650	3	_packet
packs	13	55	2893	3	_packs
pacs	8	58	4218	3	_pac_s
pact	8	66	4872	3	_pac_t
pacts	9	51	2580	3	_pacts
pacy	11	53	2868	3	_pac_y
padle	8	45	2234	3	_padle
padre	8	60	1816	3	_padre
page	7	60	3610	3	_pa_ge
pah	8	88	5359	3	_pa_h_
paise	7	50	2833	3	_paise
palace	10	45	1691	3	palac_e
pale	6	60	5501	3	_pa_le
panaches	15	3	1028	3	panaches
pane	6	49	5029	3	_pa_ne
panne	7	66	2365	3	_panne
panoche	14	5	638	3	panoche
papacies	14	3	947	3	papacies
papacy	15	4	749	3	papac_y
parae	7	63	3570	3	_parae
parch	12	51	2300	3	parch_
parched	15	40	1369	3	parched
parches	14	37	2000	3	parches
pare	6	67	6084	3	_pa_re
parge	8	58	3185	3	_parge
parle	7	58	3616	3	_parle
parse	7	52	3699	3	_parse
parve	10	98	2485	3	_parve
pase	6	53	4686	3	_pa_se
pash	9	56	3813	3	_pash_
pasha	10	54	1718	3	_pasha
pashed	12	59	2314	3	_pashed
pashes	11	58	2839	3	_pashes
passe	7	55	2569	3	_passe
paste	7	49	3295	3	_paste
patch	12	52	2122	3	patch_
patched	15	35	1462	3	patched
patcher	14	35	1514	3	patcher
patches	14	33	2038	3	patches
patchy	16	50	957	3	patchy
pate	6	53	5046	3	_pa_te
path	9	91	3491	3	_path_
paths	10	55	2138	3	_paths
pause	7	50	2183	3	_pause
pave	9	61	3389	3	_pa_ve
payee	10	55	2472	3	_payee
peace	9	50	2608	3	peac_e
peach	12	54	2249	3	peach_
peached	15	43	1588	3	peached
peacher	14	42	1607	3	peacher
peaches	14	41	2005	3	peaches
peachy	16	45	1084	3	peachy
pech	11	61	2545	3	_pech_
peched	14	49	1534	3	_peched
pechs	12	55	1620	3	_pechs
pice	8	46	4109	3	_pic_e
place	9	48	2461	3	plac_e
planche	14	29	975	3	planche
poach	12	49	1786	3	poach_
poached	15	42	1240	3	poached
poacher	14	39	1232	3	poacher
poaches	14	44	1694	3	poaches
poachy	16	38	896	3	poachy
psyche	16	7	429	3	psyche
puce	8	51	2788	3	_puc_e
quiche	20	5	790	3	quiche
race	6	67	4626	3	_rac_e
rachet	11	50	2897	3	_rachet
raphe	10	49	1642	3	_raphe
rathe	8	58	2192	3	_rathe
reach	10	51	2388	3	reach_
reached	13	46	1908	3	reached
reacher	12	37	1829	3	reacher
reaches	12	34	2320	3	reaches
rhaphe	14	3	342	3	rhaphe
roach	10	57	1700	3	roach_
roached	13	32	1183	3	roached
roaches	12	36	1621	3	roaches
rotche	11	43	1198	3	rotche
rouche	11	47	1431	3	rouche
ruche	10	42	1676	3	_ruche
sachem	13	40	1222	3	_sachem
sachet	11	47	2577	3	_sachet
sadhe	9	48	1513	3	_sadhe
scathe	11	44	1499	3	scathe
seiche	11	8	1183	3	seiche
snathe	9	44	1511	3	snathe
spaced	11	45	1725	3	spaced
spacer	10	49	1779	3	spacer
spaces	10	47	2263	3	spaces
spacey	13	62	1253	3	spacey
spacier	11	40	1163	3	spacier
spackle	15	36	957	3	spackle
spacy	12	54	1562	3	spac_y
spade	8	44	2332	3	spa_de
spae	6	50	3432	3	spa__e
spahee	11	3	1344	3	spahee
spahi	10	3	1114	3	spa_hi
spake	11	43	2274	3	spa_ke
spale	7	49	2921	3	spa_le
spare	7	51	3556	3	spa_re
sparge	9	42	1605	3	sparge
sparse	8	45	1634	3	sparse
spate	7	47	3158	3	spa_te
spathed	13	40	1318	3	spathed
spathes	12	51	1653	3	spathes
spavie	11	36	1138	3	spavie
specie	10	4	1222	3	specie
spicae	10	43	1370	3	spicae
spice	9	55	2881	3	spic_e
stacte	8	21	1391	3	stacte
swathe	12	55	1411	3	swathe
tace	6	53	4251	3	_tac_e
tach	9	61	3275	3	_tach_
taches	11	42	2417	3	_taches
tachs	10	58	2093	3	_tachs
takahe	13	3	579	3	taka_he
teach	10	52	2112	3	teach_
teacher	12	37	1483	3	teacher
teaches	12	27	1835	3	teaches
touche	11	49	1617	3	touche
trace	7	58	2961	3	trac_e
trachea	12	3	1167	3	trachea
trachle	12	3	1185	3	trachle
tranche	12	33	1222	3	tranche
troche	11	31	1251	3	troche
tusche	11	3	678	3	tusche
wacke	14	59	1862	3	_wacke
yacht	13	4	1739	3	_yacht

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.376	475242.0
2	DLD Change Limit	112716	336	5.796	19447.2
3	Display Results	336	336	0.110	3054.5
	(SQL Overall)	178691	336	6.282	28444.9