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

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

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.

57 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
apprentices	17	5	356	(None)
apprentice	16	5	432	1	apprentice_
apprenticed	18	5	274	1	apprenticed
appendices	17	4	346	2	app_endices
prentices	13	11	1190	2	__prentices
appendixes	22	5	244	3	app_endixes
appetites	13	4	751	3	app_e_tites
apprenticeship	22	7	86	3	apprentices~~hip~~
apprenticing	19	6	230	3	apprenticing
prentice	12	10	1235	3	__prentice_
prenticed	14	11	806	3	__prenticed
adventives	17	4	512	4	a_dventives
agentives	13	4	644	4	a__gentives
anorectics	14	4	451	4	anorectic_s
anoretics	11	4	864	4	anore_tic_s
apparentness	16	5	202	4	apparentness
appendages	16	5	324	4	app_endages
apperceives	20	5	280	4	apperceives
appetences	16	4	459	4	app_etences
appetencies	17	5	373	4	appetenci_es
appetiser	13	4	444	4	app_e_tiser
appetisers	14	4	293	4	app_e_tisers
appetite	12	5	849	4	app_e_tite_
appetizer	22	4	443	4	app_e_tizer
appetizers	23	4	302	4	app_e_tizers
applesauces	17	5	171	4	applesauces
appointees	14	5	304	4	appoint_ees
appointive	17	9	380	4	appointive_
appositives	18	5	425	4	appositives
appraises	13	4	742	4	appr__aises
appreciates	17	5	472	4	appreciates
apprenticeships	23	8	76	4	apprentice~~ship~~s
apprises	12	3	1096	4	appr___ises
apprizes	21	3	779	4	appr___izes
appurtenances	19	6	127	4	appurtenances
apyretic	15	4	684	4	apyre_tic__
arenites	8	9	1710	4	a__ren_ites
argentines	11	4	694	4	a_rgentines
argentites	11	4	702	4	a_rgentites
asperities	12	4	976	4	asperiti_es
entices	9	16	1633	4	____entices
malpractices	20	6	160	4	malpractices
parentages	13	4	548	4	_parentages
parentings	13	5	561	4	_parentings
paretics	12	23	1244	4	_pare_tic_s
percentiles	15	4	620	4	_percentiles
phrenitides	17	5	371	4	_phrenitides
phrenitises	16	4	449	4	_phrenitises
phrensies	14	4	574	4	_phrensi_es
plenties	10	3	1469	4	__plenti_es
practices	15	5	799	4	__practices
preprices	15	6	926	4	__preprices
preslices	13	3	821	4	__preslices
prestiges	12	3	1059	4	__prestiges
pretties	10	6	1513	4	__pretti_es
serpentines	13	5	529	4	serpentines
turpentines	13	5	321	4	turpentines

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	148819	0.420	425454.8
2	DLD Change Limit	148819	57	8.203	18142.0
3	Display Results	57	57	0.033	1727.3
	(SQL Overall)	178691	57	8.656	20643.6