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

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

75 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
chiliads	14	4	585	(None)
chiliad	13	3	756	1	chiliad_
chiliadal	15	5	219	2	chiliadal
chiliadic	17	4	300	2	chiliadic
chiliasm	15	13	451	2	chiliasm
chiliasms	16	9	349	2	chiliasms
chiliast	13	11	793	2	chiliast
chiliasts	14	13	434	2	chiliasts
chilies	12	42	1830	2	chili_es
chilis	11	55	1787	2	chili__s
iliads	7	44	867	2	__iliads
acholias	13	4	957	3	acholia_s
carloads	11	3	839	3	carloads
ceilidh	13	4	536	3	ceili_dh
ceilidhs	14	4	213	3	ceilidhs
ceilings	11	39	799	3	ceilings
ceilis	8	54	1374	3	ceili__s
celiacs	11	15	789	3	c_eliacs
chads	11	61	2223	3	ch___ads
chalahs	15	28	988	3	chal_ahs
chalcids	16	3	589	3	chalcids
chalices	15	3	1081	3	chalices
challahs	16	37	756	3	challahs
challas	12	44	1412	3	challa_s
chelas	11	38	1720	3	chel_a_s
chelipeds	17	4	300	3	chelipeds
cheloids	14	3	803	3	cheloids
chias	10	46	2552	3	ch__ia_s
chiaus	11	36	1131	3	ch__iaus
chicas	13	59	1647	3	chi_ca_s
chields	13	50	748	3	chi_elds
child	11	45	1622	3	chil__d_
childbeds	18	4	172	3	childbeds
childe	12	47	1121	3	chil__de
childes	13	42	1127	3	chil_des
chiles	11	54	2530	3	chil__es
chili	10	62	1848	3	chili___
chiliarch	19	5	247	3	chiliarch
chiliarchs	20	5	169	3	chiliarchs
chilidog	15	13	290	3	chilidog
chilidogs	16	12	277	3	chilidogs
chilled	13	33	1093	3	chilled_
chillers	13	37	1092	3	chillers
chillies	13	41	1348	3	chillies
chillis	12	44	1160	3	chil_lis
chills	11	47	1770	3	chil__ls
chillums	15	4	416	3	chillums
chilopods	17	7	464	3	chilopods
chimars	14	40	1059	3	chi_mars
chimlas	14	3	745	3	chimla_s
chinas	11	51	1940	3	chi_na_s
chinwags	17	4	338	3	chinwags
chitins	12	27	1379	3	chiti_ns
chitlings	15	25	590	3	chitlings
chitlins	13	28	939	3	chitli_ns
chivied	16	36	838	3	chivied_
chivies	15	34	1285	3	chivi_es
cholas	11	48	1800	3	chol_a_s
cholines	13	22	1449	3	cholines
chollas	12	38	1135	3	cholla_s
cilia	7	30	1676	3	c_ilia__
ciliary	12	4	792	3	c_iliary
ciliate	9	5	1460	3	c_iliate
ciliates	10	4	1345	3	c_iliates
cilices	11	38	1402	3	c_ilices
civilians	14	4	359	3	civilians
clads	8	57	2273	3	c__l_ads
clivias	12	6	669	3	clivia_s
coleads	10	29	1142	3	c_oleads
halids	10	40	1613	3	_hali_ds
helipads	14	4	387	3	_helipads
iliad	6	46	1346	3	__iliad_
shiploads	15	4	381	3	shiploads
shitloads	13	9	350	3	shitloads
thulias	10	3	574	3	thulia_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	146162	0.420	425454.8
2	DLD Change Limit	146162	75	7.080	20644.4
3	Display Results	75	75	0.030	2500.0
	(SQL Overall)	178691	75	7.530	23730.5