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

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

78 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
paranoic	12	4	983	(None)
paranoia	10	4	1056	1	paranoia
paranoiac	13	4	626	1	paranoiac
paranoics	13	4	765	1	paranoics
paranoid	11	3	1114	1	paranoid
parabolic	15	4	628	2	parabolic
parafoil	13	4	597	2	parafoil
paranoea	10	4	857	2	paranoea
paranoiacs	14	4	425	2	paranoiacs
paranoias	11	4	1044	2	paranoias
paranoids	12	4	891	2	paranoids
parsonic	12	3	970	2	parsonic
pharaonic	16	4	576	2	pharaonic
puranic	11	4	1048	2	puran_ic
pyranoid	14	4	728	2	pyranoid
apractic	14	4	830	3	apractic
apraxic	18	4	629	3	apra_xic
arabic	10	3	1273	3	_ara_bic
araneid	8	3	1080	3	_araneid
baryonic	15	4	620	3	baryonic
carangid	12	4	642	3	carangid
carangoid	13	4	451	3	carangoid
carbonic	14	3	999	3	carbonic
faradaic	14	4	365	3	faradaic
faradic	13	3	769	3	fara_dic
frantic	12	3	1037	3	_frantic
harmonic	15	8	943	3	harmonic
marasmic	14	4	616	3	marasmic
panic	9	39	2390	3	p__an_ic
parabiotic	16	4	508	3	parabiotic
parabola	12	4	665	3	parabola
parador	10	33	1141	3	parado_r
paradors	11	34	1190	3	paradors
parados	10	38	1605	3	parado_s
paradox	17	35	817	3	parado_x
paraffin	16	4	490	3	paraffin
parafoils	14	4	550	3	parafoils
paraform	15	4	693	3	paraform
paragoge	12	5	715	3	paragoge
paragon	10	3	1102	3	parago_n
paragons	11	3	1150	3	paragons
paralytic	16	4	797	3	paralytic
paramedic	16	4	572	3	paramedic
paramo	10	26	1464	3	paramo__
paramos	11	32	1351	3	paramo_s
paramour	12	4	608	3	paramour
parang	9	37	1551	3	paran__g
parangs	10	43	1437	3	paran_gs
paranoeas	11	4	752	3	paranoeas
paranoidal	13	5	489	3	paranoidal
parapodia	14	4	551	3	parapodia
parasail	10	4	923	3	parasail
parasitic	13	4	952	3	parasitic
parasol	9	3	955	3	paraso_l
parasols	10	3	926	3	parasols
parazoan	19	4	655	3	parazoan
parboil	11	3	832	3	par_boil
paregoric	14	4	467	3	paregoric
paretic	11	30	1667	3	par_etic
parhelic	15	4	709	3	parhelic
parodic	12	23	1172	3	par_odic
parodoi	10	26	772	3	parodoi_
paronymic	18	4	537	3	paronymic
parotic	11	25	1804	3	par_otic
parotoid	11	4	1003	3	parotoid
parsnip	11	4	632	3	parsn_ip
pedantic	13	4	658	3	pedantic
phratric	15	4	595	3	phratric
phrenic	14	3	877	3	phren_ic
pianic	10	37	1412	3	p_ian_ic
piratic	11	3	1429	3	pira_tic
practic	13	3	1225	3	p_ractic
pyranose	13	4	492	3	pyranose
pyrenoid	14	4	687	3	pyrenoid
sardonic	11	4	745	3	sardonic
satanic	9	3	993	3	satan_ic
tyrannic	13	4	414	3	tyrannic
uranic	8	23	1518	3	_uran_ic

Search took 9 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.453	394461.4
2	DLD Change Limit	146162	78	7.766	18820.8
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	8.249	21662.1