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

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

79 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
charqui	21	4	399	(None)
charquid	23	4	290	1	charquid
charquis	22	4	391	1	charquis
charpai	14	3	662	2	charpai
barque	17	23	955	3	_barque
caique	17	31	880	3	c_aique
calque	17	28	984	3	c_alque
carful	11	6	1097	3	c_arful
caroli	8	59	1823	3	c_aroli
carpi	9	43	1939	3	c_ar_pi
carpus	10	55	1430	3	c_arpus
casque	17	29	927	3	c_asque
chabouk	18	4	454	3	chabouk
chabuk	17	3	467	3	cha_buk
chadri	12	3	813	3	cha_dri
chai	9	59	2990	3	cha___i
chapati	14	11	800	3	chapati
char	9	51	3215	3	char___
characid	16	4	684	3	characid
characin	15	4	797	3	characin
charade	13	12	990	3	charade
charas	11	42	2359	3	char_as
chard	11	61	2474	3	char__d
chards	12	51	1972	3	char_ds
chare	10	52	3198	3	char__e
chared	12	54	2369	3	char_ed
chares	11	56	3180	3	char_es
charge	12	51	1421	3	char_ge
charged	14	46	1402	3	charged
charger	13	39	1406	3	charger
charges	13	46	1598	3	charges
charier	12	43	1790	3	charier
charily	15	3	1028	3	charily
charing	13	37	2132	3	charing
chariot	12	3	1621	3	chariot
charism	14	7	1220	3	charism
charity	15	3	1102	3	charity
chark	14	42	2271	3	char__k
charka	15	40	1170	3	char_ka
charkas	16	48	1095	3	charkas
charked	17	48	1401	3	charked
charkha	19	40	515	3	charkha
charks	15	52	1970	3	char_ks
charley	15	11	827	3	charley
charlie	12	30	1192	3	charlie
charm	12	61	2466	3	char__m
charmed	15	47	1424	3	charmed
charmer	14	49	1366	3	charmer
charms	13	52	1883	3	char_ms
charnel	12	40	1005	3	charnel
charpais	15	3	692	3	charpais
charpoy	17	3	571	3	charpoy
charr	10	48	2178	3	char__r
charred	13	46	1448	3	charred
charro	11	42	1295	3	char_ro
charros	12	43	1214	3	charros
charrs	11	52	1918	3	char_rs
charry	14	50	1211	3	char_ry
chars	10	59	3663	3	char__s
chart	10	50	3828	3	char__t
charted	13	51	1685	3	charted
charter	12	39	1830	3	charter
charts	11	58	2309	3	char_ts
chary	13	50	2313	3	char__y
cheque	20	3	666	3	ch_eque
cherub	13	3	726	3	cher_ub
chirrup	14	12	383	3	chirrup
chiru	10	53	1715	3	chir_u_
chirus	11	46	1569	3	chir_us
choragi	13	4	668	3	choragi
choregi	13	4	456	3	choregi
chorus	11	50	1476	3	chor_us
cirque	17	3	585	3	c_irque
claque	17	33	856	3	cla_que
gharri	10	38	616	3	ghar_ri
maqui	16	24	995	3	_ma_qui
marque	17	24	1050	3	_marque
marquis	18	24	706	3	_marquis
yanqui	18	4	338	3	_yanqui

Search took 7 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.203	880251.2
2	DLD Change Limit	134027	79	6.313	21230.3
3	Display Results	79	79	0.030	2633.3
	(SQL Overall)	178691	79	6.546	27297.7