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

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

82 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
priapic	13	4	602	(None)
priapi	10	3	792	1	priapi_
pianic	10	37	1412	2	p_ianic
piratic	11	3	1429	2	piratic
priapism	14	5	624	2	priapism
priapus	11	3	435	2	priapus
triadic	10	3	782	2	triadic
adipic	11	3	726	3	adi_pic
apraxic	18	4	629	3	apr_axic
arabic	10	3	1273	3	ar_abic
aviatic	12	3	924	3	aviatic
biopic	12	37	1067	3	_biopic
crisic	10	36	1184	3	cri_sic
critic	10	36	1681	3	cri_tic
diapir	9	35	711	3	_diapir
dryadic	14	4	362	3	dryadic
eristic	9	8	1408	3	eristic
erratic	9	3	1111	3	erratic
graphic	15	3	735	3	gr_aphic
iridic	9	32	874	3	iri_dic
iritic	8	32	1382	3	iri_tic
jalapic	18	4	454	3	jalapic
organic	10	3	831	3	organic
panic	9	39	2390	3	p__anic
pelagic	12	3	786	3	pelagic
periapsis	13	4	483	3	periapsis
periapt	11	3	1341	3	periap_t
periapts	12	3	727	3	periapts
pericopic	17	4	553	3	pericopic
periodic	13	4	843	3	periodic
periotic	12	3	1344	3	periotic
phasic	13	36	1205	3	p_hasic
phatic	13	30	1440	3	p_hatic
phreatic	15	4	834	3	phreatic
picnic	12	34	1026	3	p_icnic
picric	12	30	992	3	p_icric
pionic	10	35	1595	3	p_ionic
pipit	9	52	2487	3	p_i_pit
pippin	9	28	1030	3	p_ippin
potamic	13	3	1085	3	potamic
practic	13	3	1224	3	practic
prairie	9	3	833	3	prairie
praxis	15	40	1225	3	pr_axis
prelatic	12	3	1128	3	prelatic
prepaid	12	3	1013	3	prepaid
preppie	10	5	809	3	preppie
priapean	12	4	337	3	priapean
priapisms	15	4	546	3	priapisms
primi	9	50	1740	3	pri_mi_
primp	11	56	1592	3	primp__
primped	14	47	915	3	primped
primping	15	33	889	3	primping
primps	12	47	1182	3	primp_s
primsie	11	3	754	3	primsie
prismatic	15	4	714	3	prismatic
prosaic	11	3	1116	3	prosaic
protatic	12	3	1474	3	protatic
prussic	11	4	474	3	prussic
psoatic	11	3	930	3	psoatic
psoriatic	13	8	702	3	psoriatic
puranic	11	4	1048	3	puranic
puristic	12	3	937	3	puristic
puritanic	13	4	358	3	puritanic
pyridic	15	26	783	3	pyri_dic
pyritic	14	33	1131	3	pyri_tic
rabic	9	38	1739	3	_r_abic
rapid	8	64	2203	3	_r_apid
sciatic	11	9	1016	3	sciatic
sialic	8	3	1363	3	_sialic
tragic	9	38	1154	3	tr_agic
triac	7	41	1637	3	tria__c
triacid	10	3	858	3	triacid
triadics	11	4	612	3	triadics
triassic	10	4	461	3	triassic
triazin	16	3	819	3	triazin
tribadic	13	4	408	3	tribadic
tribasic	12	4	478	3	tribasic
trismic	11	3	747	3	trismic
tropic	10	30	1419	3	tr_opic
uranic	8	23	1518	3	ur_anic
uratic	8	30	1635	3	ur_atic
viatic	11	3	1145	3	_viatic

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.156	1145455.1
2	DLD Change Limit	134027	82	6.890	19452.4
3	Display Results	82	82	0.033	2484.8
	(SQL Overall)	178691	82	7.079	25242.4