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

Here are the results of your fuzzy-string dictionary search for “cabrioles” 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
cabrioles	13	7	636	(None)
cabriole	12	7	693	1	cabriole_
cabriolet	13	7	748	1	cabriolet
cabriolets	14	6	337	1	cabriolets
caprioles	13	7	675	1	caprioles
carioles	10	8	1706	1	ca_rioles
carrioles	11	6	947	1	carrioles
cabrillas	13	4	560	2	cabrillas
capriole	12	7	691	2	capriole_
caprioled	14	6	474	2	caprioled
cariole	9	8	1834	2	ca_riole_
carriole	10	8	986	2	carriole_
darioles	9	7	1069	2	da_rioles
varioles	11	7	1112	2	va_rioles
abioses	9	3	1149	3	_ab_ioses
abridges	12	4	530	3	_abridges
airholes	11	3	803	3	_airholes
areoles	7	10	1695	3	_a_reoles
aureoles	8	3	828	3	_aureoles
auricles	10	13	833	3	_auricles
bricoles	12	26	1030	3	__bricoles
bridles	10	41	1447	3	__bridles
cabbies	13	31	1516	3	cabbi__es
cabezones	22	4	378	3	cabezones
cables	10	45	2755	3	cab___les
caboodles	14	4	328	3	caboodles
cabooses	12	3	786	3	cab_ooses
cabrilla	12	4	583	3	cabri_lla
cajoles	16	37	1210	3	ca__joles
calcicoles	13	4	402	3	calcicoles
calicles	12	38	1142	3	ca_licles
calliopes	13	4	614	3	calliopes
camisoles	13	4	557	3	camisoles
canailles	11	4	826	3	canailles
canticles	13	3	918	3	canticles
caprices	14	3	989	3	capri_ces
caracoles	13	3	1007	3	caracoles
carbazoles	23	4	359	3	carbazoles
carbides	13	31	1169	3	carbi_des
carbines	12	36	1753	3	carbi_nes
carbinols	13	4	610	3	carbinol_s
cargoes	10	44	1522	3	ca_rgo_es
caribes	11	37	1564	3	ca_ri_bes
carices	11	42	2095	3	ca_ri_ces
caries	8	51	4762	3	ca_ri__es
cariocas	12	3	966	3	ca_riocas
carious	9	33	2028	3	ca_rio_us
carles	8	54	3508	3	ca_r__les
caroled	10	37	1768	3	ca_r_oled
caroler	9	38	1675	3	ca_r_oler
carolers	10	33	1417	3	ca_r_olers
carols	8	51	2498	3	ca_r_ol_s
carolus	9	46	1260	3	ca_r_olus
carriages	12	3	833	3	carriages
carries	9	43	2801	3	carri__es
carrions	10	3	1244	3	carrio_ns
caulicles	13	4	438	3	caulicles
centrioles	12	4	580	3	centrioles
creoles	9	9	1332	3	c__reoles
cubicles	14	3	588	3	cub_icles
curricles	13	10	542	3	curricles
dariole	8	7	1116	3	da_riole_
glorioles	10	4	426	3	glorioles
orioles	7	4	1299	3	__orioles
ovarioles	12	4	460	3	ovarioles
paroles	9	50	2588	3	pa_r_oles
safroles	11	3	693	3	safr_oles
unbridles	12	4	413	3	unbridles
variolas	11	6	853	3	va_riolas
variole	10	7	1159	3	va_riole_
vibrioses	14	4	392	3	vibrioses
zabaiones	20	4	300	3	zabaiones

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	148641	0.173	1032896.0
2	DLD Change Limit	148641	72	7.436	19989.4
3	Display Results	72	72	0.033	2181.8
	(SQL Overall)	178691	72	7.642	23382.8