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

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

80 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
comprised	16	4	805	(None)
comprise	14	3	1081	1	comprise_
comprises	15	5	1094	1	comprises
comprized	25	6	722	1	comprized
compassed	16	4	554	2	compassed
compiled	15	3	781	2	comp_iled
complied	15	3	967	2	compli_ed
composed	15	46	1206	2	comp_osed
compressed	17	4	584	2	compressed
comprisal	15	4	451	2	comprisal
comprize	23	6	873	2	comprize_
comprizes	24	6	894	2	comprizes
compromised	20	5	277	2	compromised
apprised	13	3	771	3	_apprised
campused	15	3	525	3	camp_used
coderived	16	4	479	3	coderived
cognised	12	5	631	3	co_gnised
colonised	12	24	872	3	colonised
colorized	21	22	1177	3	colorized
combined	15	26	918	3	com_bined
commixed	22	6	474	3	com_mixed
communised	17	4	495	3	communised
compacted	18	29	736	3	compacted
companied	16	4	802	3	companied
compared	15	38	1182	3	comp_ared
comparison	16	4	435	3	comparison
comparted	16	33	842	3	comparted
compasses	15	4	739	3	compasses
comped	13	59	1987	3	comp___ed
compeered	16	4	630	3	compeered
compelled	16	4	613	3	compelled
compered	15	34	1492	3	comp_ered
competed	15	41	1359	3	comp_eted
compile	13	3	1244	3	comp_ile_
compiler	14	3	837	3	comp_iler
compiles	14	3	1198	3	comp_iles
complained	17	17	579	3	complained
completed	16	28	1027	3	completed
complexed	23	29	598	3	complexed
complice	16	3	933	3	complice_
complices	17	3	925	3	complices
complier	14	3	1025	3	compli_er
complies	14	3	1452	3	compli_es
compline	14	3	1355	3	compline_
complines	15	3	1283	3	complines
comported	16	31	953	3	comported
compose	13	57	1666	3	comp_ose_
composer	14	50	1295	3	comp_oser
composes	14	50	1711	3	comp_oses
composited	17	5	600	3	composited
composted	16	37	881	3	composted
comprehend	20	7	394	3	comprehend
compress	14	3	905	3	compres_s
compresses	16	4	777	3	compresses
comprisals	16	4	370	3	comprisals
comprising	17	4	863	3	comprising
compromise	18	5	417	3	compromise_
compromiser	19	5	262	3	compromiser
compromises	19	5	418	3	compromises
compted	14	38	1352	3	comp__ted
computed	15	41	1095	3	comp_uted
computerised	19	19	369	3	comp~~ute~~rised
contrived	15	4	799	3	contrived
copied	11	46	1856	3	co_p_i_ed
coppiced	17	3	482	3	co_ppiced
coursed	10	41	1360	3	co_ur_sed
covaried	14	4	800	3	covari_ed
emprise	11	3	1072	3	_emprise_
emprises	12	3	1100	3	_emprises
memorised	14	11	822	3	memorised
motorised	12	4	726	3	motorised
polarised	12	6	923	3	polarised
porpoised	14	4	545	3	porpoised
prised	9	43	2220	3	___prised
reprised	11	20	1220	3	_reprised
romanised	12	4	792	3	romanised
solarised	10	6	804	3	solarised
surprised	12	4	531	3	surprised
temporised	15	5	512	3	temporised
womanised	15	4	575	3	womanised

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	148641	0.406	440125.6
2	DLD Change Limit	148641	80	7.390	20113.8
3	Display Results	80	80	0.033	2424.2
	(SQL Overall)	178691	80	7.829	22824.2