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

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

326 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
aphides	13	47	1120	(None)
aphids	12	51	1084	1	aphid_s
apsides	10	39	1130	1	apsides
raphides	14	18	839	1	raphides
abides	9	47	1989	2	a_bides
aides	6	53	3660	2	a__ides
amides	9	57	2266	2	a_mides
apheses	12	6	1070	2	apheses
aphid	11	55	1539	2	aphid__
aphis	10	59	1713	2	aphi__s
apices	10	49	1626	2	ap_ices
aplites	9	3	1493	2	aplites
asides	7	51	1887	2	a_sides
azides	16	51	1380	2	a_zides
chides	12	46	2047	2	_chides
hides	9	51	2942	2	__hides
lapides	10	30	1204	2	lap_ides
ophites	12	3	1010	2	ophites
phizes	20	38	913	2	_phizes
prides	9	43	2418	2	_prides
rachides	14	15	1122	2	rachides
raphide	13	13	807	2	raphide_
rawhides	15	14	554	2	rawhides
upsides	10	31	963	2	upsides
abide	8	62	2371	3	a_bide_
abided	10	53	1331	3	a_bided
abider	9	53	1446	3	a_bider
abiders	10	40	1108	3	a_biders
abodes	9	44	1751	3	a_bodes
abrades	10	3	1207	3	abrades
abridges	12	4	530	3	abridges
accedes	12	3	772	3	accedes
accidies	13	3	804	3	accidies
achenes	12	3	1349	3	achenes
aches	10	61	3229	3	ach__es
achier	11	39	1426	3	achi_er
achiest	12	3	1519	3	achi_est
achieves	16	4	552	3	achieves
achiness	13	3	970	3	achiness
achiotes	13	3	900	3	achiotes
acids	8	71	2100	3	a_cid_s
acnodes	10	3	783	3	acnodes
acrider	10	3	862	3	acrider
acridest	11	3	814	3	acridest
actives	12	3	1152	3	actives
adheres	11	3	1016	3	adheres
admires	10	3	866	3	admires
admixes	17	6	596	3	admixes
advices	13	13	693	3	advices
advises	11	13	897	3	advises
aedes	6	46	2515	3	a__edes
aediles	8	34	1390	3	aediles
aegises	8	3	1137	3	aegises
aeries	6	47	3778	3	aeri_es
affines	13	3	948	3	affines
affixes	20	3	550	3	affixes
aggies	8	35	1551	3	aggi_es
agnizes	17	32	884	3	agnizes
ahis	7	61	3538	3	a_hi__s
aide	5	60	4500	3	a__ide_
aided	7	58	2893	3	a__ided
aider	6	54	3113	3	a__ider
aiders	7	45	2463	3	a__iders
aids	5	78	4636	3	a__id_s
aikidos	12	5	388	3	aikidos
albites	9	3	1320	3	albites
alcades	10	10	1147	3	alcades
alcaides	11	11	767	3	alcaides
alcids	9	48	1229	3	alcid_s
alines	6	57	3522	3	a_lines
alkies	10	45	1809	3	alki_es
alkines	11	44	1573	3	alkines
allies	6	38	2767	3	alli_es
alludes	8	36	1033	3	alludes
almudes	10	41	826	3	almudes
alpines	9	40	1619	3	alpines
alsikes	11	3	726	3	alsikes
amices	10	50	1801	3	a_mices
amide	8	61	2848	3	a_mide_
amids	8	56	2751	3	a_mid_s
amies	7	68	3769	3	a_mi_es
amines	8	47	2798	3	a_mines
ammines	11	3	1267	3	ammines
animes	8	47	1959	3	a_nimes
anises	6	48	2669	3	a_nises
anodes	7	44	1876	3	a_nodes
apaches	14	34	1184	3	apaches
apathies	13	3	901	3	apathi_es
apatites	10	3	1129	3	apatites
aperies	9	4	2320	3	aperies
apes	6	60	4743	3	ap___es
apexes	15	3	913	3	ap_exes
aphanites	14	4	827	3	aphanites
aphesis	12	6	1051	3	aphesis
aphidian	14	4	553	3	aphidian
aphidians	15	4	405	3	aphidians
aphorises	14	3	1000	3	aphorises
aphorizes	23	4	801	3	aphorizes
aplite	8	3	1639	3	aplite_
apods	8	63	1634	3	ap_od_s
apogees	10	3	710	3	apogees
apomixes	19	3	485	3	apomixes
apples	10	43	1576	3	ap_ples
applies	11	3	1122	3	applies
apposes	11	5	1147	3	apposes
apprises	12	3	1096	3	apprises
apprizes	21	3	779	3	apprizes
apres	7	54	2640	3	ap__res
apses	7	68	2391	3	ap__ses
apsidal	10	4	670	3	apsidal
apsis	7	57	1829	3	apsi__s
aptitudes	12	15	618	3	aptitudes
arcades	10	11	1319	3	arcades
archines	13	38	1525	3	archines
archives	16	39	955	3	archives
arider	7	47	1774	3	a_rider
aridest	8	3	1614	3	a_ridest
arises	6	52	3380	3	a_rises
armies	8	51	2369	3	armi_es
aroids	7	51	1822	3	aroid_s
arrises	7	16	1758	3	arrises
arrives	10	13	1151	3	arrives
arsines	7	35	1881	3	arsines
ascites	9	3	1260	3	ascites
ashes	8	62	3061	3	ash__es
ashier	9	47	1483	3	ashi_er
ashiest	10	3	1396	3	ashi_est
ashiness	11	3	896	3	ashiness
aside	6	51	2208	3	a_side_
asphodel	14	4	259	3	asphodel
asphodels	15	4	178	3	asphodels
aspires	9	6	1204	3	aspires
aspises	9	6	1164	3	aspises
assizes	16	3	845	3	assizes
attires	7	23	1295	3	attires
aubades	10	3	875	3	aubades
audiles	8	31	1261	3	audiles
augites	8	3	1218	3	augites
avoided	12	3	555	3	avoided
avoider	11	5	581	3	avoider
avoiders	12	5	479	3	avoiders
avoids	10	44	1020	3	avoid_s
awhile	12	5	779	3	awhile_
axises	13	44	1399	3	a_xises
axites	13	49	1383	3	a_xites
azide	15	56	1716	3	a_zide_
azines	15	55	1707	3	a_zines
baptises	12	3	892	3	baptises
baptizes	21	3	684	3	baptizes
besides	10	48	1453	3	besides
betides	10	49	1526	3	betides
bides	8	55	3677	3	__bides
bolides	10	5	1507	3	bolides
borides	10	5	1515	3	borides
brides	9	44	2351	3	_brides
camphines	18	4	756	3	camphines
camphires	18	4	578	3	camphires
capizes	20	4	1037	3	cap_izes
caprices	14	3	989	3	caprices
capsids	12	3	933	3	capsid_s
capsizes	21	4	720	3	capsizes
captives	15	3	862	3	captives
carbides	13	31	1169	3	carbides
cathodes	14	3	939	3	cathodes
chide	11	53	2101	3	_chide_
chided	13	51	1396	3	_chided
chider	12	51	1605	3	_chider
chiders	13	53	1294	3	_chiders
childes	13	42	1127	3	_childes
chiles	11	54	2530	3	_chiles
chimes	13	49	2257	3	_chimes
chines	11	50	2917	3	_chines
chives	14	43	1759	3	_chives
cowhides	17	3	601	3	cowhides
daphnes	13	32	768	3	daph_nes
dauphines	15	4	434	3	dauphines
daysides	13	3	596	3	daysides
decides	11	42	1765	3	decides
depsides	12	3	850	3	depsides
derides	9	34	2085	3	derides
divides	12	32	1145	3	divides
elides	7	44	2069	3	_elides
ephebes	14	3	615	3	ephebes
ephods	12	3	836	3	ephod_s
epodes	9	43	1556	3	ep_odes
epoxides	18	4	486	3	epoxides
excides	17	3	834	3	excides
farsides	12	3	799	3	farsides
glides	8	45	1886	3	_glides
graphites	15	4	682	3	graphites
grides	8	44	2236	3	_grides
guides	8	41	1828	3	_guides
hades	9	60	3511	3	__hades
hagrides	13	3	762	3	hagrides
halides	11	34	1666	3	halides
hapkidos	18	4	271	3	hapkidos
haplites	13	3	999	3	haplites
hayrides	15	3	688	3	hayrides
hide	8	51	3464	3	__hide_
hided	10	52	2244	3	__hided
hider	9	50	2408	3	__hider
hiders	10	49	1965	3	__hiders
hies	7	48	4283	3	__hi_es
hikes	12	54	2698	3	__hikes
hires	8	61	3434	3	__hires
hives	11	69	2551	3	__hives
ides	5	77	3423	3	___ides
imides	9	45	1534	3	_imides
insides	8	5	1265	3	insides
iodides	9	38	1161	3	iodides
irides	7	45	1912	3	_irides
kathodes	16	4	618	3	kathodes
lapises	9	35	1346	3	lap_ises
lipides	10	38	1062	3	lipides
machines	15	3	1289	3	machines
mashies	12	3	1825	3	mashi_es
nappies	11	46	1340	3	nappi_es
nides	6	52	2913	3	__nides
ophite	11	4	1056	3	ophite_
opines	8	48	2070	3	op_ines
optimes	11	4	847	3	optimes
oreides	8	3	1202	3	oreides
oroides	8	3	1197	3	oroides
oxides	14	10	969	3	_oxides
paddies	11	37	1572	3	paddies
pandies	10	42	2450	3	pandies
paphians	15	4	559	3	paphians
pappies	10	32	1483	3	pappi_es
parades	10	41	2146	3	parades
paries	8	47	4251	3	pari_es
parises	9	48	2718	3	parises
patines	9	52	2576	3	patines
pavises	12	53	1549	3	pavises
pedes	8	53	2729	3	_p_edes
peises	8	41	2504	3	_peises
peptides	13	26	1026	3	peptides
phages	12	52	1351	3	_phages
phases	11	46	1840	3	_phases
phials	11	5	887	3	_phials
phis	9	57	2490	3	_phi__s
phones	11	41	2121	3	_phones
physes	14	39	978	3	_physes
pies	6	69	4960	3	_p_i_es
pikes	11	50	3103	3	_p_ikes
piles	7	47	4261	3	_p_iles
pines	7	60	4886	3	_p_ines
pipes	9	60	3014	3	_p_ipes
pixes	14	43	2317	3	_p_ixes
plies	7	45	2651	3	_pli_es
poises	8	42	2654	3	_poises
prices	10	45	2454	3	_prices
pride	8	47	2473	3	_pride_
prided	10	36	1803	3	_prided
pries	7	43	3953	3	_pri_es
primes	10	42	2526	3	_primes
prises	8	41	3317	3	_prises
prizes	17	38	1981	3	_prizes
prudes	9	42	1544	3	_prudes
pyxides	20	3	442	3	pyxides
rachises	13	14	1241	3	rachises
raphes	11	51	1745	3	raph__es
raphias	12	35	1108	3	raphi_as
raphis	11	40	1432	3	raphi__s
rapider	10	6	790	3	rap_ider
rapidest	11	3	854	3	rap_idest
rapids	9	49	1389	3	rap_id_s
rapines	9	51	2086	3	rap_ines
rawhide	14	13	497	3	rawhide_
rawhided	16	15	307	3	rawhided
rehires	10	50	1611	3	rehires
resides	8	45	2328	3	resides
rhachides	18	5	366	3	rhachides
rides	6	61	4081	3	__rides
riptides	11	3	641	3	riptides
samphires	16	4	551	3	samphires
sapphires	16	4	404	3	sapphires
shades	10	59	2453	3	_shades
shies	8	61	3655	3	_shi_es
shines	9	50	2891	3	_shines
shires	9	52	2557	3	_shires
shives	12	49	2141	3	_shives
sides	6	58	3836	3	__sides
slides	7	39	2218	3	_slides
sophies	12	3	1462	3	sophi_es
spades	9	42	2258	3	sp_ades
speises	9	38	1393	3	speises
sphenes	12	30	1316	3	sphenes
spheres	12	31	1435	3	spheres
sphinges	14	26	748	3	sphinges
sphinxes	20	33	440	3	sphinxes
spices	10	43	2603	3	sp_ices
spider	9	45	1680	3	sp_ider
spiders	10	39	1441	3	sp_iders
spies	7	60	3762	3	sp_i_es
spikes	12	45	2071	3	sp_ikes
spiles	8	42	2791	3	sp_iles
spines	8	51	3203	3	sp_ines
spires	8	46	2811	3	sp_ires
spites	8	41	2733	3	sp_ites
splices	11	39	1438	3	splices
splines	9	47	1889	3	splines
spodes	9	48	1743	3	sp_odes
sprites	9	42	2033	3	sprites
strides	8	45	2039	3	strides
sulphides	15	4	469	3	sulphides
tapholes	13	3	962	3	tapholes
tapises	9	29	1401	3	tap_ises
tides	6	48	3015	3	__tides
topsides	11	3	720	3	topsides
updives	13	3	471	3	updives
uphills	12	9	523	3	uphills
uphroes	12	3	630	3	uphroes
uppiles	11	20	826	3	uppiles
uprises	9	20	1273	3	uprises
upside	9	28	980	3	upside_
upsizes	18	29	716	3	upsizes
uptimes	11	7	755	3	uptimes
ureides	8	3	1110	3	ureides
vahines	13	34	1052	3	vahines
wahines	13	31	1117	3	wahines
waysides	15	4	445	3	waysides
whids	12	54	1398	3	_whid_s
whiles	12	44	1801	3	_whiles
whines	12	51	2010	3	_whines
whites	12	39	1988	3	_whites
wides	9	48	3282	3	__wides

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	134027	0.453	394461.4
2	DLD Change Limit	134027	326	6.593	20328.7
3	Display Results	326	326	0.106	3075.5
	(SQL Overall)	178691	326	7.152	24984.8