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

Here are the results of your fuzzy-string dictionary search for “chaise” with Change Limit: [1] [2] [3]

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.

83 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
chaise	11	49	1641	(None)
chaine	11	51	1922	1	chaine
chais	10	75	3031	1	chais_
chaises	12	43	1749	1	chaises
chamise	14	36	1285	1	chamise
chase	10	51	2712	1	cha_se
chasse	11	51	1460	1	chasse
archaise	13	4	847	2	archaise
braise	8	43	1875	2	braise
camise	10	33	1963	2	camise
carse	7	49	3433	2	c_arse
case	6	58	4808	2	c_a_se
cause	7	52	2535	2	c_ause
cease	7	52	2765	2	cea_se
cerise	8	48	2204	2	cerise
chads	11	61	2223	2	chads_
chafe	13	51	1735	2	cha_fe
chafes	14	50	1791	2	chafes
chai	9	59	2990	2	chai__
chain	10	57	2367	2	chai_n
chained	13	38	1269	2	chained
chaines	12	45	1873	2	chaines
chains	11	48	1970	2	chains
chair	10	55	1963	2	chai_r
chaired	13	42	1124	2	chaired
chairs	11	49	1618	2	chairs
chalice	14	3	1104	2	chalice
chamisa	14	32	885	2	chamisa
chamises	15	35	1331	2	chamises
chamiso	14	34	865	2	chamiso
chams	12	60	2850	2	chams_
chance	13	46	1709	2	chance
change	12	41	1675	2	change
chaos	10	56	2286	2	chaos_
chaoses	12	47	1512	2	chaoses
chape	12	52	2114	2	cha_pe
chapes	13	54	2187	2	chapes
chaps	12	53	2606	2	chaps_
chare	10	52	3198	2	cha_re
chares	11	56	3180	2	chares
charge	12	51	1421	2	charge
charism	14	7	1220	2	charism
chars	10	59	3664	2	chars_
chased	12	50	1929	2	cha_sed
chaser	11	49	1838	2	cha_ser
chases	11	51	2823	2	cha_ses
chasm	12	55	1879	2	cha_sm
chassed	13	47	1213	2	chassed
chasses	12	40	1750	2	chasses
chaste	11	46	1739	2	chaste
chastise	13	4	817	2	chastise
chats	10	57	3009	2	chats_
chaws	13	50	2246	2	chaws_
chays	13	53	1974	2	chays_
cheese	11	38	1276	2	cheese
chemise	14	32	1150	2	chemise
chias	10	46	2552	2	chias_
chiasm	13	44	910	2	chiasm
chide	11	53	2101	2	ch_ide
chile	10	56	2689	2	ch_ile
chime	12	53	2259	2	ch_ime
chine	10	52	3172	2	ch_ine
chis	9	59	3331	2	ch_is_
chisel	11	21	1194	2	ch_isel
chive	13	51	1762	2	ch_ive
choice	13	20	1052	2	choice
choose	11	51	1614	2	choose
chose	10	59	2540	2	ch_ose
chouse	11	60	1756	2	chouse
chowse	14	47	1175	2	chowse
chrism	13	7	1067	2	chrism
clause	8	43	1150	2	clause
coarse	8	48	1390	2	coarse
cruise	8	43	1404	2	cruise
fraise	9	42	1491	2	fraise
hanse	8	57	2279	2	_hanse
hawse	11	60	1512	2	_hawse
hoise	8	52	2477	2	_hoise
liaise	6	3	1069	2	liaise
paise	7	50	2833	2	_paise
phase	10	46	1721	2	pha_se
praise	8	44	1941	2	praise
raise	5	48	2805	2	_raise

Search took 3 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	82551	0.346	516448.0
2	DLD Change Limit	82551	83	2.186	37763.5
3	Display Results	83	83	0.013	6384.6
	(SQL Overall)	178691	83	2.545	70212.6