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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

260 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
compass	13	37	956	(None)
compas	12	58	1706	1	compa_s
camass	10	41	1418	2	cam_ass
comas	9	58	3300	2	com_a_s
combats	13	3	1168	2	combats
commas	12	48	1457	2	comma_s
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
compassed	16	4	554	2	compassed
compasses	15	4	739	2	compasses
compels	13	32	1088	2	compels
compos	12	48	1880	2	comp_os
compose	13	57	1666	2	compose
composes	14	50	1711	2	composes
compost	13	45	1535	2	compost
composts	14	42	1091	2	composts
compress	14	3	905	2	compress
comps	11	55	2605	2	comp__s
compts	12	52	1665	2	comp_ts
copals	10	50	1894	2	co_pals
copays	13	49	1127	2	co_pays
cowpats	14	3	771	2	cowpats
encompass	15	4	303	2	encompass
oompahs	14	3	426	2	oompahs
admass	9	5	714	3	adm_ass
amass	7	71	1968	3	_am_ass
biomass	11	5	599	3	biom_ass
bombast	13	4	822	3	bombast
bombasts	14	4	494	3	bombasts
bypass	13	4	504	3	_bypass
calpacs	13	31	1034	3	calpacs
camas	9	63	3352	3	cam_a_s
camases	11	42	1634	3	cam_ases
camisas	11	34	1192	3	camisas
campers	13	42	2028	3	campers
campos	12	52	1795	3	camp_os
camps	11	63	3026	3	camp__s
campus	12	52	1392	3	camp_us
campuses	14	3	777	3	campuses
canvass	12	37	687	3	canvass
carcass	11	3	1051	3	carcass
carpals	11	34	1462	3	carpals
champacs	19	3	462	3	champacs
champaks	21	3	409	3	champaks
chompers	17	36	957	3	chompers
chomps	15	51	1222	3	chomp__s
class	7	55	2548	3	c__lass
clomps	12	52	1223	3	clomp__s
coalas	8	74	1896	3	coala_s
coals	7	61	2960	3	co__als
coapts	10	46	1400	3	coap_ts
coast	7	52	3626	3	co__ast
coasts	8	57	1913	3	co__asts
coats	7	56	3499	3	co__ats
cobias	10	40	1497	3	cobia_s
cobras	10	40	1419	3	cobra_s
cocas	9	59	2657	3	co_ca_s
cocoas	10	49	1574	3	cocoa_s
codas	8	47	2424	3	co_da_s
coempts	13	3	568	3	coemp_ts
coevals	12	3	787	3	coevals
cognacs	12	5	604	3	cognacs
cogways	16	3	463	3	cogways
coheads	13	28	923	3	coheads
colas	7	54	3677	3	co_la_s
coleads	10	29	1142	3	coleads
collars	9	38	1657	3	collars
colzas	17	40	1050	3	colza_s
coma	8	71	3485	3	com_a__
comade	11	44	1532	3	com_ade
comae	9	71	2842	3	com_a_e
comake	14	44	1342	3	com_ake
comakes	15	44	1364	3	comakes
comal	9	51	2513	3	com_a_l
comate	10	41	2484	3	com_ate
comates	11	41	2363	3	comates
combat	12	3	1675	3	comba_t
combers	13	45	1661	3	combers
combes	12	53	2173	3	com_bes
combos	12	53	1661	3	com_bos
combs	11	61	2296	3	com__bs
combust	13	3	835	3	combust
combusts	14	4	549	3	combusts
comedos	12	32	907	3	comedos
comers	10	53	2808	3	com_ers
comes	9	72	4699	3	com__es
comets	10	58	2358	3	com_ets
comfits	14	32	874	3	comfits
comics	12	40	1556	3	com_ics
comings	12	40	1353	3	comings
comma	11	45	1479	3	comma__
command	14	39	921	3	command
commands	15	31	881	3	commands
commata	13	3	848	3	commata
commies	13	37	1844	3	commies
commits	13	38	1237	3	commits
commons	13	3	1104	3	commons
comose	10	50	1684	3	com_ose
comous	10	8	1650	3	com_ous
comp	10	67	3125	3	comp___
compadre	15	29	588	3	compadre
compadres	16	26	641	3	compadres
companies	15	3	1179	3	companies
compared	15	38	1182	3	compared
comparer	14	36	1136	3	comparer
comparers	15	31	938	3	comparers
compassing	17	4	654	3	compass~~ing~~
compassion	16	4	597	3	compass~~ion~~
comped	13	59	1987	3	comp_ed
compeer	13	38	1155	3	compeer
compeers	14	34	1001	3	compeers
compel	12	44	1289	3	comp_el
compend	14	40	1030	3	compend
compends	15	37	825	3	compends
compere	13	46	1662	3	compere
comperes	14	32	1797	3	comperes
compete	13	47	1655	3	compete
competes	14	41	1724	3	competes
compile	13	3	1244	3	compile
compiles	14	3	1198	3	compiles
comping	14	35	1859	3	comping
complain	14	4	875	3	complain
complains	15	4	917	3	complains
complex	20	3	724	3	complex
complies	14	3	1452	3	complies
complin	13	3	1207	3	complin
complins	14	3	1310	3	complins
complot	13	3	1068	3	complot
complots	14	3	816	3	complots
comply	15	28	1038	3	comp_ly
compo	11	53	1857	3	comp__o
compone	13	65	1719	3	compone
compony	16	130	1191	3	compony
comport	13	36	1684	3	comport
comports	14	34	1198	3	comports
composed	15	46	1206	3	composed
composer	14	50	1295	3	composer
composers	15	39	1061	3	composers
compote	13	56	1646	3	compote
compotes	14	47	1651	3	compotes
comprise	14	3	1081	3	comprise
comprises	15	5	1094	3	comprises
compt	11	63	2822	3	comp__t
compted	14	38	1352	3	compted
compute	13	45	1365	3	compute
computes	14	39	1453	3	computes
comrade	12	13	921	3	comrade
comrades	13	14	977	3	comrades
comtes	10	62	2281	3	com_tes
concuss	11	3	806	3	concuss
confabs	14	3	539	3	confabs
confess	12	39	990	3	confess
congas	9	44	1703	3	conga_s
coopers	11	40	1948	3	coopers
coops	9	62	2964	3	coop__s
coopts	10	58	1458	3	coop_ts
copal	9	56	2178	3	co_pa_l
copalm	12	50	1081	3	co_palm
copalms	13	36	754	3	co_palms
copay	12	65	1631	3	co_pa_y
copens	10	61	1996	3	co_pens
copers	10	46	2984	3	co_pers
copes	9	77	4710	3	co_p_es
copies	10	41	3030	3	co_pies
coppers	13	35	1975	3	coppers
coppras	13	32	783	3	coppras
coprahs	14	33	815	3	coprahs
copras	10	35	1715	3	co_pras
cops	8	67	5137	3	co_p__s
copse	9	56	2392	3	co_p_se
copses	10	49	2247	3	co_pses
corals	8	53	2514	3	co_rals
corbans	11	3	1317	3	corbans
corps	9	59	2704	3	corp__s
corpse	10	40	1340	3	corp_se
corpses	11	39	1380	3	corpses
corpus	10	60	1529	3	corp_us
corpuses	12	3	1006	3	corpuses
corrals	9	37	1385	3	corrals
corsacs	11	3	901	3	corsacs
coss	6	61	4349	3	co___ss
costars	9	42	1799	3	costars
cotans	8	13	1792	3	co_tans
cottars	9	44	1223	3	cottars
cottas	8	46	1557	3	cotta_s
cougars	10	3	842	3	cougars
coupes	10	50	2252	3	coup_es
couples	11	53	1705	3	couples
coupons	11	27	1055	3	coupons
coups	9	55	2247	3	coup__s
cowpat	13	3	1203	3	cowpa_t
cowpeas	14	3	727	3	cowpeas
cowpies	14	33	1428	3	cowpies
coxless	16	3	774	3	coxless
coyness	12	7	732	3	coyness
coypous	14	24	881	3	coypous
coypus	13	38	930	3	coyp_us
crass	7	63	2804	3	c__rass
cuirass	9	3	497	3	cuirass
cuppas	12	45	859	3	cuppa_s
cutlass	9	3	801	3	cutlass
cymars	13	59	914	3	cym_ars
cymas	12	64	1788	3	cym_a_s
cymbals	16	23	614	3	cymbals
dopas	8	50	1906	3	do_pa_s
impasse	11	24	646	3	_impasse
koppas	14	40	760	3	koppa_s
lampads	12	47	762	3	lampads
lampas	10	66	1595	3	lampa_s
lampases	12	6	729	3	lampases
limpas	10	55	1308	3	limpa_s
mass	6	60	4493	3	__m_ass
mommas	9	41	1065	3	momma_s
morass	8	46	1449	3	mo_rass
nomads	9	47	1160	3	nom_ads
nomas	7	47	2641	3	nom_a_s
nonpast	9	3	903	3	nonpast
nonpasts	10	4	655	3	nonpasts
nopals	8	49	1402	3	no_pals
omasa	7	4	948	3	_om_asa
oomiacs	11	3	568	3	oomiacs
oomiaks	13	4	412	3	oomiaks
oompah	13	3	425	3	oompa_h
oomphs	13	4	472	3	oomp_hs
opahs	10	54	1198	3	_o_pahs
opals	7	57	1835	3	_o_pals
outpass	9	3	971	3	outpass
pampas	12	49	1399	3	pampa_s
pass	6	52	3995	3	___pass
pompano	13	4	520	3	pompano
pompanos	14	4	524	3	pompanos
pompoms	15	3	533	3	pompoms
pompons	13	3	855	3	pompons
pompous	13	3	806	3	pompous
pomps	11	53	1619	3	pomp__s
poppas	9	37	1071	3	poppa_s
repass	8	41	1470	3	_repass
romans	8	46	2024	3	rom_ans
rompers	11	34	1224	3	rompers
rompish	14	3	669	3	rompish
romps	9	46	1754	3	romp__s
sampans	11	24	1100	3	sampans
somans	8	46	1930	3	som_ans
somas	7	60	3037	3	som_a_s
surpass	9	3	828	3	surpass
tampans	11	33	1098	3	tampans
tomans	8	54	1913	3	tom_ans
tombacs	13	24	843	3	tombacs
tombaks	15	24	685	3	tombaks
tomcats	11	12	777	3	tomcats
topmast	11	3	812	3	topmast
topmasts	12	4	496	3	topmasts
tympans	14	23	681	3	tympans
womans	11	46	1365	3	wom_ans
wombats	14	3	589	3	wombats

Search took 9 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.156	1145455.1
2	DLD Change Limit	134027	260	7.953	16852.4
3	Display Results	260	260	0.093	2795.7
	(SQL Overall)	178691	260	8.202	21786.3