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

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

90 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
compas	12	58	1706	(None)
comas	9	58	3300	1	com_as
commas	12	48	1457	1	commas
compass	13	37	956	1	compass
compos	12	48	1880	1	compos
comps	11	55	2605	1	comp_s
compts	12	52	1665	1	compts
camas	9	63	3352	2	cam_as
campos	12	52	1795	2	campos
camps	11	63	3026	2	camp_s
campus	12	52	1392	2	campus
chomps	15	51	1222	2	chomp_s
clomps	12	52	1223	2	clomp_s
coalas	8	74	1896	2	coalas
coapts	10	46	1400	2	coapts
cobias	10	40	1497	2	cobias
cobras	10	40	1419	2	cobras
cocas	9	59	2657	2	co_cas
cocoas	10	49	1574	2	cocoas
codas	8	47	2424	2	co_das
coempts	13	3	568	2	coempts
colas	7	54	3677	2	co_las
colzas	17	40	1050	2	colzas
coma	8	71	3485	2	com_a_
comae	9	71	2842	2	com_ae
comal	9	51	2513	2	com_al
combat	12	3	1675	2	combat
combats	13	3	1168	2	combats
combes	12	53	2173	2	combes
combos	12	53	1661	2	combos
combs	11	61	2296	2	com_bs
comers	10	53	2808	2	comers
comes	9	72	4699	2	com_es
comets	10	58	2358	2	comets
comics	12	40	1556	2	comics
comma	11	45	1479	2	comma_
comous	10	8	1650	2	comous
comp	10	67	3125	2	comp__
compact	15	37	1221	2	compact
compacts	16	36	890	2	compacts
company	16	197	1114	2	company
compare	13	58	1499	2	compare
compares	14	38	1643	2	compares
compart	13	40	1600	2	compart
comparts	14	42	1083	2	comparts
comped	13	59	1987	2	comped
compel	12	44	1289	2	compel
compels	13	32	1088	2	compels
comply	15	28	1038	2	comply
compo	11	53	1857	2	comp_o
compose	13	57	1666	2	compose
compost	13	45	1535	2	compost
compt	11	63	2822	2	comp_t
comtes	10	62	2281	2	comtes
congas	9	44	1703	2	congas
coops	9	62	2964	2	coop_s
coopts	10	58	1458	2	coopts
copal	9	56	2178	2	co_pal
copals	10	50	1894	2	co_pals
copay	12	65	1631	2	co_pay
copays	13	49	1127	2	co_pays
copes	9	77	4710	2	co_pes
coppras	13	32	783	2	coppras
copras	10	35	1715	2	copras
cops	8	67	5137	2	co_p_s
corps	9	59	2704	2	corp_s
corpus	10	60	1529	2	corpus
cottas	8	46	1557	2	cottas
coupes	10	50	2252	2	coupes
coups	9	55	2247	2	coup_s
cowpat	13	3	1203	2	cowpat
cowpats	14	3	771	2	cowpats
cowpeas	14	3	727	2	cowpeas
coypus	13	38	930	2	coypus
cuppas	12	45	859	2	cuppas
cymas	12	64	1788	2	cym_as
dopas	8	50	1906	2	do_pas
koppas	14	40	760	2	koppas
lampas	10	66	1595	2	lampas
limpas	10	55	1308	2	limpas
mommas	9	41	1065	2	mommas
nomas	7	47	2641	2	nom_as
oompah	13	3	425	2	oompah
oompahs	14	3	426	2	oompahs
oomphs	13	4	472	2	oomphs
pampas	12	49	1399	2	pampas
pomps	11	53	1619	2	pomp_s
poppas	9	37	1071	2	poppas
romps	9	46	1754	2	romp_s
somas	7	60	3037	2	som_as

Search took 4 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.250	714764.0
2	DLD Change Limit	82551	90	3.000	27517.0
3	Display Results	90	90	0.030	3000.0
	(SQL Overall)	178691	90	3.280	54479.0