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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

104 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
guiles	7	39	1928	(None)
guides	8	41	1828	1	guides
guilds	8	38	835	1	guilds
guile	6	45	2113	1	guile_
guiled	8	43	1538	1	guiled
guilts	7	41	1123	1	guilts
guises	7	42	1631	1	guises
gules	6	48	3104	1	gu_les
audiles	8	31	1261	2	audiles
beguiles	11	4	610	2	beguiles
biles	7	55	4214	2	_biles
bugles	9	48	2244	2	bugles
builds	9	37	849	2	builds
butles	8	44	2391	2	butles
chiles	11	54	2530	2	chiles
ediles	7	40	1698	2	ediles
exiles	13	48	1640	2	exiles
files	8	54	4127	2	_files
fugles	10	47	1578	2	fugles
gables	9	42	2233	2	gables
gales	6	54	4248	2	g_ales
gibes	8	44	2252	2	g_ibes
gies	5	56	4142	2	g_i_es
gilds	7	54	1752	2	g_ilds
gills	6	47	2819	2	g_ills
gilts	6	49	2426	2	g_ilts
gites	6	56	3018	2	g_ites
gives	9	53	2487	2	g_ives
glides	8	45	1886	2	glides
glimes	9	47	1752	2	glimes
grides	8	44	2236	2	grides
grilles	8	37	1502	2	grilles
grills	7	43	1480	2	grills
grilse	7	39	950	2	grilse
grilses	8	31	915	2	grilses
grimes	9	46	1903	2	grimes
gripes	9	46	1987	2	gripes
gudes	7	45	2081	2	gu_des
guggles	10	34	1054	2	guggles
guglet	8	40	1822	2	guglet
guglets	9	36	969	2	guglets
guide	7	50	1988	2	guide_
guided	9	40	1411	2	guided
guider	8	43	1352	2	guider
guiders	9	41	1111	2	guiders
guids	7	55	1615	2	gui_ds
guild	7	53	1275	2	guil_d
guilder	9	4	591	2	guilder
guilders	10	3	551	2	guilders
guilt	6	51	2557	2	guil_t
guilty	10	41	823	2	guilty
guimpes	12	4	507	2	guimpes
guinea	7	3	761	2	guinea
guineas	8	3	675	2	guineas
guiros	7	38	909	2	guiros
guise	6	47	1771	2	guise_
guised	8	46	1217	2	guised
gulfs	9	49	1530	2	gu_lfs
gulled	8	45	2137	2	gulled
gullet	7	49	2483	2	gullet
gullets	8	40	1371	2	gullets
gulley	10	42	1316	2	gulley
gulleys	11	43	852	2	gulleys
gullies	8	47	1731	2	gullies
gulls	6	52	2298	2	gu_lls
gulps	8	47	1507	2	gu_lps
guls	5	59	3085	2	gu_l_s
gumless	10	22	827	2	gumless
gunites	8	3	1312	2	gunites
gunless	8	29	963	2	gunless
gurges	8	47	1686	2	gurges
gurgles	9	43	1287	2	gurgles
gushes	10	47	1903	2	gushes
gutless	8	26	1071	2	gutless
guttles	8	30	1193	2	guttles
guzzles	16	32	804	2	guzzles
jubiles	16	28	937	2	jubiles
juices	15	4	942	2	juices
mailes	8	43	2911	2	mailes
miles	7	46	4507	2	_miles
mules	7	50	3429	2	mu_les
piles	7	47	4261	2	_piles
pules	7	45	3881	2	pu_les
quills	15	38	1185	2	quills
quilts	15	41	1254	2	quilts
quires	15	40	1575	2	quires
riles	5	53	4364	2	_riles
rubles	8	39	2170	2	rubles
rules	5	52	3425	2	ru_les
rutiles	7	43	1584	2	rutiles
smiles	8	45	2229	2	smiles
spiles	8	42	2791	2	spiles
stiles	6	43	2877	2	stiles
suites	6	37	2740	2	suites
tiles	5	55	4210	2	_tiles
toiles	6	39	2351	2	toiles
tuilles	7	24	1192	2	tuilles
tules	5	45	3279	2	tu_les
tulles	6	32	1889	2	tulles
uglies	7	4	1232	2	uglies
voiles	9	46	1644	2	voiles
whiles	12	44	1801	2	whiles
wiles	8	54	3787	2	_wiles
yules	8	45	2158	2	yu_les

Search took 3 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	82551	0.330	541487.9
2	DLD Change Limit	82551	104	2.453	33653.1
3	Display Results	104	104	0.030	3466.7
	(SQL Overall)	178691	104	2.813	63523.3