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

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

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.

45 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
trompes	11	41	1162	(None)
trompe	10	56	1126	1	trompe_
tromped	12	42	1029	1	tromped
tromps	10	49	1170	1	tromp_s
tropes	8	48	2435	1	tro_pes
troupes	9	41	1285	1	troupes
bromes	10	47	1976	2	brom_es
croupes	11	46	1310	2	croupes
gropes	9	52	2040	2	gro_pes
prompts	13	3	747	2	prompts
romped	11	45	1365	2	_romped
romper	10	42	1368	2	_romper
rompers	11	34	1224	2	_rompers
romps	9	46	1754	2	_romp_s
ropes	7	59	4006	2	_ro_pes
thorpes	12	50	1035	2	thorpes
tomes	7	60	3738	2	t_om_es
topes	7	69	4176	2	t_o_pes
tramped	12	43	1243	2	tramped
tramper	11	38	1216	2	tramper
trampers	12	32	1039	2	trampers
tramples	12	26	1020	2	tramples
tramps	10	51	1445	2	tramp_s
trapes	8	50	2446	2	tr_apes
tripes	8	53	2487	2	tr_ipes
troches	12	37	1534	2	troches
trokes	10	40	1926	2	tro_kes
trommel	11	31	536	2	trommel
trommels	12	25	433	2	trommels
tromp	9	58	1580	2	tromp__
trones	6	56	2928	2	tro_nes
trooped	10	40	1072	2	trooped
trooper	9	42	1036	2	trooper
troopers	10	28	944	2	troopers
troops	8	57	1278	2	troop_s
trope	7	57	2580	2	tro_pe_
troupe	8	48	1243	2	troupe_
trouped	10	39	1098	2	trouped
trouper	9	38	1143	2	trouper
troupers	10	35	944	2	troupers
troves	9	47	1911	2	tro_ves
trumped	12	43	971	2	trumped
trumpet	11	38	1072	2	trumpet
trumpets	12	31	557	2	trumpets
trumps	10	46	1188	2	trump_s

Search took 4 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	107671	0.373	479064.3
2	DLD Change Limit	107671	45	3.343	32207.9
3	Display Results	45	45	0.033	1363.6
	(SQL Overall)	178691	45	3.749	47663.6