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

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

69 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
concretion	14	4	929	(None)
concretions	15	4	929	1	concretions
conception	16	4	1045	2	conception
concertino	14	9	1084	2	concertino
concoction	13	4	823	2	concoction
concreting	15	3	987	2	concreting
concretism	16	5	545	2	concretism
concretist	14	4	819	2	concretist
concretize	23	16	671	2	concretize
contrition	12	4	1141	2	contrition
incretion	11	4	905	2	_incretion
accretion	13	4	593	3	_accretion
coaction	12	3	1077	3	coac__tion
codirection	16	4	474	3	codirection
coloration	12	9	1318	3	coloration
completion	16	4	730	3	completion
conation	10	14	2088	3	con__ation
conceptions	17	4	1059	3	conceptions
concerti	12	29	1260	3	concerti__
concertina	14	4	1061	3	concertina
concerting	15	3	1389	3	concerting
concertinos	15	15	812	3	concertinos
concertize	23	16	935	3	concertize
concerto	12	33	1161	3	concert_o_
concertos	13	27	1113	3	concert_os
concession	14	14	813	3	concession
concision	13	4	849	3	conc_ision
conclusion	14	4	522	3	conclusion
concoctions	14	4	825	3	concoctions
concrete	12	4	1108	3	concret__e
concreted	14	3	941	3	concret_ed
concretely	17	5	390	3	concretely
concretes	13	4	1147	3	concret_es
concretionary	20	6	286	3	concretion~~ary~~
concretisms	17	6	443	3	concretisms
concretists	15	5	546	3	concretists
concretized	25	17	467	3	concretized
concretizes	24	16	600	3	concretizes
concretizing	26	5	430	3	concretizing
concussion	14	15	557	3	concussion
condition	12	4	1116	3	con_dition
conduction	15	4	996	3	conduction
confection	17	4	1118	3	confection
conflation	15	4	1208	3	conflation
congestion	13	4	904	3	congestion
congregation	16	22	676	3	congregation
conjuration	20	4	951	3	conjuration
connation	11	3	1426	3	con_nation
connection	14	4	1053	3	connection
connexion	18	7	460	3	con_nexion
conniption	14	4	627	3	conniption
conscription	18	5	533	3	conscription
consecration	16	4	978	3	consecration
contention	12	4	1222	3	contention
contortion	12	4	866	3	contortion
contraction	15	4	1124	3	contraction
contraption	15	4	810	3	contraption
contritions	13	4	1091	3	contritions
conurbation	15	4	746	3	conurbation
convection	17	4	1112	3	convection
convention	15	4	1056	3	convention
conversion	15	4	842	3	conversion
conviction	17	4	818	3	conviction
correction	14	4	881	3	co_rrection
cunctation	14	7	691	3	cunctation
discretion	13	4	752	3	discretion
excretion	18	4	671	3	_excretion
incretions	12	4	865	3	_incretions
secretion	11	11	830	3	_secretion

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	140603	0.440	406115.9
2	DLD Change Limit	140603	69	5.843	24063.5
3	Display Results	69	69	0.030	2300.0
	(SQL Overall)	178691	69	6.313	28305.2