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

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

69 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
chimaera	15	6	494	(None)
chimaeras	16	6	457	1	chimaeras
chimera	14	38	927	1	chim_era
chimaeric	18	4	432	2	chimaeric
chimar	13	39	1147	2	chima_r_
chimars	14	40	1059	2	chima_rs
chimer	13	55	1720	2	chim_er_
chimeras	15	38	883	2	chim_eras
chimere	14	40	1063	2	chim_ere
chimers	14	45	1514	2	chim_ers
camera	10	3	1369	3	c_am_era
chaeta	11	3	1068	3	ch__aeta
chakra	15	43	753	3	ch__akra
chamber	16	40	1106	3	chamber_
chambers	17	34	1062	3	chambers
chamfer	17	39	986	3	chamfer_
chamfers	18	40	922	3	chamfers
champer	16	38	1341	3	champer_
champers	17	33	1162	3	champers
chiasma	14	36	699	3	chi_asma
chicaner	15	8	607	3	chicaner_
chicaners	16	8	536	3	chicaners
chicanery	19	10	305	3	chicanery
chicer	13	45	1360	3	chi_cer_
chider	12	51	1605	3	chi_der_
chiders	13	53	1294	3	chi_ders
chiefer	15	3	686	3	chiefer_
chigger	14	3	600	3	chigger_
chiggers	15	3	556	3	chiggers
chiller	12	41	1218	3	chiller_
chillers	13	37	1092	3	chillers
chimaerism	19	5	316	3	chimaerism
chime	12	53	2259	3	chim_e__
chimed	14	58	1483	3	chim_e_d
chimeres	15	35	1131	3	chim_eres
chimeric	17	4	674	3	chim_eric
chimes	13	49	2257	3	chim_e_s
chimla	13	3	759	3	chim__la
chimley	17	8	516	3	chimle_y
chimleys	18	8	363	3	chimleys
chimney	17	9	548	3	chimne_y
chimneys	18	8	364	3	chimneys
chipper	16	39	1258	3	chipper_
chippers	17	35	1088	3	chippers
chirker	16	42	932	3	chirker_
chirper	14	35	996	3	chirper_
chirpers	15	35	813	3	chirpers
chitter	12	41	1296	3	chitter_
chitters	13	37	1117	3	chitters
chivalry	19	4	308	3	chivalry
chivaree	16	4	636	3	chivaree
chivari	15	3	604	3	chiva_ri
cholera	12	40	909	3	ch_olera
chomper	16	38	1007	3	chomper_
chompers	17	36	959	3	chompers
climber	13	44	913	3	climber_
climbers	14	31	841	3	climbers
crimmer	13	33	1077	3	crimmer_
crimmers	14	29	854	3	crimmers
crimper	13	65	1042	3	crimper_
crimpers	14	31	893	3	crimpers
hetaera	10	3	649	3	_hetaera
himatia	12	4	859	3	_himatia
primavera	16	4	240	3	primavera
shimmer	14	33	1087	3	shimmer_
shimmers	15	26	941	3	shimmers
shimmery	18	26	525	3	shimmery
whimper	17	29	772	3	whimper_
whimpers	18	27	661	3	whimpers

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.440	406115.9
2	DLD Change Limit	146162	69	7.123	20519.7
3	Display Results	69	69	0.030	2300.0
	(SQL Overall)	178691	69	7.593	23533.6