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

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

86 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
curragh	13	4	429	(None)
curagh	12	3	655	1	cu_ragh
currach	14	4	645	1	currach
curraghs	14	4	288	1	curraghs
curaghs	13	3	458	2	cu_raghs
currachs	15	4	454	2	currachs
curran	8	3	1202	2	curra_n
currans	9	3	1061	2	currans
currant	9	3	1417	2	currant
currish	12	3	835	2	currish
hurrah	12	36	918	2	hurra_h
aarrgh	10	78	630	3	aarr_gh
barrage	10	7	1084	3	barrage
burgage	11	3	663	3	burgage
burgh	11	52	1603	3	bu_r_gh
carnage	10	3	1174	3	carnage
caroach	14	8	886	3	caroach
carrack	15	4	875	3	carrack
carriage	11	3	785	3	carriage
carroch	14	3	709	3	carroch
cartage	10	3	1259	3	cartage
carwash	15	3	599	3	carwash
choragi	13	4	668	3	choragi
cirrate	9	24	1349	3	cirrate
coprah	13	37	1060	3	copra_h
cordage	11	3	1006	3	cordage
corkage	14	3	837	3	corkage
corrade	10	11	1104	3	corrade
corral	8	36	1625	3	corra_l
corrals	9	37	1385	3	corrals
corsage	10	3	980	3	corsage
courage	10	3	1099	3	courage
crag	7	56	2530	3	c__rag_
crags	8	56	2257	3	c__rags
crash	10	91	2001	3	c__rash
crura	7	3	1258	3	crura__
crural	8	6	1063	3	crura_l
cubage	11	7	827	3	cu_bage
cuirass	9	3	497	3	cuirass
curacy	13	3	959	3	cu_racy
curara	8	37	1220	3	cu_rara
curaras	9	39	1195	3	curaras
curare	8	49	1695	3	cu_rare
curares	9	49	1685	3	curares
curari	8	44	1440	3	cu_rari
curaris	9	41	1477	3	curaris
curate	8	52	2624	3	cu_rate
curch	12	44	1541	3	cu_r_ch
curia	7	45	2377	3	curia__
curiae	8	45	1837	3	curia_e
curial	8	40	1915	3	curia_l
curing	9	48	2478	3	curing_
curr	6	54	2965	3	curr___
currants	10	3	793	3	currants
curred	9	43	1926	3	curr_ed
current	9	3	1369	3	current
currie	8	43	1726	3	curr_ie
curried	10	33	1365	3	curried
currier	9	33	1670	3	currier
curries	9	37	2316	3	curries
curring	10	36	1684	3	curring
currs	7	56	2439	3	curr__s
curry	10	59	2034	3	curr__y
curtail	9	29	966	3	curtail
curtain	9	31	979	3	curtain
curtal	8	39	1454	3	curta_l
curtals	9	31	1162	3	curtals
curtate	9	3	1264	3	curtate
cuttage	10	31	834	3	cuttage
durra	6	53	1579	3	durra__
durras	7	47	1337	3	durra_s
farrago	11	4	492	3	farrago
hurrahs	13	33	677	3	hurrahs
hurray	12	45	991	3	hurra_y
hurrays	13	38	615	3	hurrays
jarrah	16	3	668	3	jarra_h
kurbash	16	4	380	3	kurbash
murra	7	45	1908	3	murra__
murrain	9	3	776	3	murrain
murras	8	49	1600	3	murra_s
outrage	8	26	1689	3	outrage
purdah	12	28	875	3	purda_h
sirrah	9	37	975	3	sirra_h
surah	8	68	2325	3	su_ra_h
surra	5	55	2134	3	surra__
surras	6	59	1953	3	surra_s

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.173	1032896.0
2	DLD Change Limit	134027	86	7.343	18252.3
3	Display Results	86	86	0.030	2866.7
	(SQL Overall)	178691	86	7.546	23680.2