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

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

58 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
cantaloupes	15	18	255	(None)
cantaloupe	14	13	246	1	cantaloupe_
cantaloups	14	15	337	1	cantaloup_s
cantaloup	13	15	428	2	cantaloup__
antelopes	11	4	687	3	_antelo_pes
cataloes	10	3	1165	3	ca_talo__es
catalogues	13	6	434	3	ca_talogues
cattaloes	11	4	618	3	cattalo__es
gantelopes	13	4	325	3	gantelo_pes
gantlopes	12	4	428	3	gant_lo_pes
pantalones	12	4	672	3	pantalo_nes
tantalous	9	4	619	3	tantalou__s
tantaluses	10	10	459	3	tantal_uses
analogies	10	19	1064	4	_an_alogies
analogues	10	12	618	4	_an_alogues
antelope	10	4	730	4	_antelo_pe_
antilogies	11	4	1031	4	_antilogies
antipopes	13	6	861	4	_antipo_pes
callouses	11	4	768	4	ca__llouses
canalises	11	5	1549	4	can_al_ises
canalizes	20	11	1378	4	can_al_izes
canapes	11	12	1308	4	can_a___pes
cantabiles	14	4	576	4	canta_biles
cantalas	10	40	1352	4	cantal___as
cantals	9	39	1957	4	cantal____s
cantatrices	15	5	344	4	cantatrices
cantillates	13	4	663	4	cantillates
cantles	9	47	2141	4	cant_l___es
catalases	11	4	944	4	ca_tal_ases
catalexes	18	4	591	4	ca_tal_exes
cataloged	13	6	530	4	ca_talo_ged
cataloger	12	6	535	4	ca_talo_ger
catalogers	13	7	444	4	ca_talogers
catalogs	11	4	803	4	ca_talo__gs
catalogue	12	5	445	4	ca_talogue_
catalogued	14	7	303	4	ca_talogued
cataloguer	13	7	295	4	ca_taloguer
cataloguers	14	8	209	4	ca_taloguers
catalos	9	4	1416	4	ca_talo___s
catalpas	12	4	673	4	ca_tal__pas
catalyses	14	4	743	4	ca_tal_yses
catalyzes	23	4	605	4	ca_tal_yzes
catamounts	14	5	229	4	ca_tamounts
cathouses	14	3	943	4	ca_t_houses
cattalos	10	3	793	4	cattalo___s
gantelope	12	4	340	4	gantelo_pe_
gantlope	11	4	441	4	gant_lo_pe_
pantalettes	13	5	326	4	pantalettes
pantalone	11	4	683	4	pantalo_ne_
pantaloons	12	4	361	4	pantalo_ons
santalols	9	4	477	4	santalo__ls
scandalous	13	4	359	4	scandalou__s
tantalates	10	10	670	4	tantal_ates
tantalises	10	10	1010	4	tantal_ises
tantalites	10	9	928	4	tantal_ites
tantalizes	19	10	994	4	tantal_izes
tantalums	11	4	310	4	tantal_u_ms
tantalus	8	3	637	4	tantal_u__s

Search took 10 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	58	8.690	17125.3
3	Display Results	58	58	0.030	1933.3
	(SQL Overall)	178691	58	9.140	19550.4