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

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

133 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
congrats	11	3	1143	(None)
congas	9	44	1703	2	cong_a_s
congeals	11	30	985	2	congeals
congests	11	35	1038	2	congests
congress	11	3	807	2	congress
contracts	13	22	1201	2	contracts
contras	9	30	1562	2	contra_s
contrast	10	26	1478	2	contrast
contrasts	11	22	1104	2	contrasts
bogarts	10	4	774	3	bo_garts
cantraps	12	31	911	3	cantraps
carats	8	59	2902	3	c__arats
centrals	10	27	1203	3	centrals
coagents	11	3	845	3	coagents
coats	7	56	3500	3	co___ats
cobras	10	40	1419	3	co_bra_s
cocomats	14	4	940	3	cocomats
coffrets	16	4	536	3	coffrets
cognacs	12	5	604	3	co_gnacs
cognate	10	3	1220	3	co_gnate
cognates	11	3	1158	3	co_gnates
cogways	16	3	463	3	co_gways
cohorts	12	34	1110	3	cohor_ts
colorants	11	4	986	3	colorants
combats	13	3	1168	3	co_mbats
comparts	14	42	1083	3	comparts
conatus	9	3	1046	3	con__atus
conceals	12	31	1101	3	conceals
conceits	12	28	1361	3	conceits
concents	12	25	1660	3	concents
concepts	14	31	1030	3	concepts
concerts	12	30	1606	3	concerts
conchas	14	40	1331	3	concha_s
concocts	11	3	863	3	concocts
concordats	15	4	419	3	concordats
concrete	12	4	1108	3	concrete
concretes	13	4	1147	3	concretes
conducts	13	11	871	3	conducts
conduits	11	12	1006	3	conduits
conelrads	12	4	426	3	conelrads
conepate	12	7	1253	3	conepate
conepates	13	9	1228	3	conepates
conepatl	12	8	670	3	conepatl
conepatls	13	8	534	3	conepatls
confabs	14	3	539	3	con_fabs
confects	15	31	1087	3	confects
confits	12	28	1142	3	con_fits
conflate	13	3	1117	3	conflate
conflates	14	3	1113	3	conflates
confronts	14	4	706	3	confronts
conga	8	54	1987	3	cong_a__
congaed	11	39	974	3	cong_aed
congeal	10	40	1168	3	congea_l
congees	10	35	1792	3	cong_ees
congeries	12	3	1640	3	congeries
congers	10	42	2323	3	cong_ers
conges	9	49	2817	3	cong__es
congest	10	46	1877	3	congest_
congius	10	32	1007	3	cong_ius
congoes	10	36	1730	3	cong_oes
congos	9	42	1988	3	cong__os
congous	10	36	1508	3	cong_ous
congregants	15	5	315	3	congregants
congregate	14	4	524	3	congregate
congregates	15	4	550	3	congregates
congruity	15	4	441	3	congruity
congruous	12	4	434	3	congruous
connate	9	3	1575	3	con_nate
connects	12	30	1056	3	connects
consents	10	27	1589	3	consents
consists	10	3	1059	3	consists
consorts	10	15	1234	3	consorts
constants	11	4	1091	3	constants
consults	10	21	998	3	consults
contacts	12	32	1521	3	contacts
contents	10	40	1821	3	contents
contests	10	34	1338	3	contests
contexts	17	37	865	3	contexts
contorts	10	11	1264	3	contorts
contra	8	33	1470	3	contra__
contract	12	29	1563	3	contract
contrail	10	4	1098	3	contrail
contrails	11	4	1054	3	contrails
contralti	11	4	774	3	contralti
contralto	11	4	709	3	contralto
contraltos	12	4	676	3	contraltos
contrary	13	4	749	3	contrary
contrasty	14	21	719	3	contrasty
contrite	10	3	1854	3	contrite
controls	10	3	1139	3	controls
convects	15	34	1099	3	convects
convents	13	26	1460	3	convents
converts	13	32	1355	3	converts
convicts	15	33	771	3	convicts
coppras	13	32	783	3	coppra_s
coprahs	14	33	815	3	co_prahs
copras	10	35	1715	3	co_pra_s
copycats	17	4	508	3	copycats
corals	8	53	2514	3	co__rals
cordgrass	13	4	301	3	cordgrass
corrals	9	37	1385	3	co_rrals
cougars	10	3	844	3	coug_ars
courants	10	3	1080	3	co_urants
courts	8	42	1617	3	co_ur_ts
coverts	12	48	1381	3	cover_ts
cowpats	14	3	771	3	co_wpats
cutgrass	11	4	434	3	cutgrass
dingbats	12	4	501	3	dingbats
dongas	8	49	1461	3	dong_a_s
engrafts	12	9	470	3	_engrafts
engrams	10	3	807	3	_engrams
ingrafts	12	10	580	3	_ingrafts
ingrate	8	7	1512	3	_ingrate
ingrates	9	5	1417	3	_ingrates
korats	10	54	1606	3	ko__rats
loggats	9	28	645	3	lo_ggats
longans	8	45	1081	3	long_ans
longboats	12	4	392	3	longboats
longways	15	4	387	3	longways
monerans	10	3	1034	3	monerans
mongrels	11	3	533	3	mongrels
monocrats	13	4	853	3	monocrats
monograms	14	7	826	3	monograms
nonarts	7	3	1130	3	nonar_ts
nongays	11	17	653	3	nong_ays
nougats	8	42	741	3	noug_ats
orgeats	8	3	835	3	_orgeats
pangrams	13	3	715	3	pangrams
pingrass	11	4	600	3	pingrass
sonograms	12	9	630	3	sonograms
sonorants	9	4	708	3	sonorants
tangrams	11	3	616	3	tangrams
tongas	7	43	1552	3	tong_a_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	133	7.003	20871.3
3	Display Results	133	133	0.046	2891.3
	(SQL Overall)	178691	133	7.469	23924.4