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

Here are the results of your fuzzy-string dictionary search for “haptical” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

72 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
haptical	15	4	734	(None)
apical	10	9	1390	2	_ap_ical
haptic	13	5	1189	2	haptic__
hectical	15	4	794	2	hectical
nautical	10	5	770	2	nautical
optical	11	4	986	2	_optical
septical	12	5	936	2	septical
tactical	12	4	884	2	tactical
vatical	12	3	998	2	va_tical
abapical	14	4	494	3	abap_ical
actinal	9	3	1229	3	_actinal
anticar	9	3	1266	3	_anticar
apicals	11	5	992	3	_ap_icals
apsidal	10	4	670	3	_apsidal
apteral	9	3	1152	3	_apteral
baptismal	15	4	229	3	baptismal
biotical	12	4	886	3	biotical
capital	11	23	1152	3	cap_ital
capsidal	13	4	563	3	capsidal
chapteral	16	4	470	3	chapteral
cortical	12	4	1221	3	cortical
critical	12	3	1026	3	critical
cryptical	18	4	469	3	cryptical
datival	11	3	558	3	da_tival
epical	10	4	1339	3	_ep_ical
erotical	10	19	1198	3	erotical
fanatical	14	4	649	3	fanatical
farcical	15	4	695	3	farcical
gestical	11	3	899	3	gestical
graphical	17	4	588	3	graphical
habitual	13	4	349	3	habitual
hallucal	13	4	348	3	hallucal
handicap	16	4	493	3	handicap
hartal	9	4	1548	3	hart__al
helical	12	3	1115	3	h_elical
hepatica	15	17	759	3	hepatica_
hepaticae	16	16	485	3	hepaticae
hepaticas	16	16	658	3	hepaticas
heretical	14	4	863	3	heretical
heroical	13	4	1002	3	heroical
iatrical	10	4	927	3	iatrical
laical	8	3	1232	3	la__ical
magical	12	3	978	3	ma_gical
martial	9	24	1541	3	marti_al
matinal	9	3	1260	3	ma_tinal
metical	11	3	1536	3	_metical
mystical	15	4	693	3	mystical
nuptial	9	4	663	3	nupti_al
optimal	11	4	578	3	_optimal
orphical	15	4	673	3	orphical
paprica	13	3	700	3	paprica_
papricas	14	4	705	3	papricas
partial	9	26	1626	3	parti_al
pical	9	55	2437	3	__p_ical
plical	10	4	1168	3	__plical
poetical	12	3	1153	3	poetical
practical	15	4	884	3	practical
radical	10	33	1279	3	ra_dical
rustical	10	4	839	3	rustical
sceptical	15	4	534	3	sceptical
skeptical	17	4	396	3	skeptical
spatial	9	3	1032	3	spati_al
statical	10	3	942	3	statical
styptical	16	4	396	3	styptical
thetical	13	4	912	3	thetical
tical	7	60	2149	3	___tical
topical	11	3	995	3	top_ical
typical	14	3	634	3	typ_ical
vertical	13	4	1043	3	vertical
viatical	13	4	706	3	viatical
vortical	13	4	886	3	vortical
zaptiah	21	4	429	3	zapti_ah

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	146162	0.436	409841.7
2	DLD Change Limit	146162	72	7.470	19566.5
3	Display Results	72	72	0.030	2400.0
	(SQL Overall)	178691	72	7.936	22516.5