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

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

81 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
wigwag	14	4	372	(None)
wigwags	15	4	329	1	wigwags
wigwam	15	4	472	1	wigwam
bigwig	13	3	334	2	bigwig
wigan	9	51	1439	2	wig_an
wigwams	16	4	388	2	wigwams
zigzag	16	4	296	2	zigzag
airbag	9	5	696	3	airbag
airway	12	3	769	3	airway
bagwig	13	4	308	3	bagwig
bigwigs	14	4	300	3	bigwigs
chinwag	16	4	355	3	chinwag
cigar	8	9	1180	3	cig_ar
cogway	15	6	618	3	cogway
diwan	9	57	1255	3	di_wan
gag	5	77	5363	3	__g_ag
giga	6	67	2094	3	gig_a_
gigas	7	54	1558	3	gig_as
highway	20	4	426	3	highway
igg	5	71	1679	3	_ig__g
jigsaw	17	4	249	3	jigsaw
kitbag	13	3	497	3	kitbag
ligan	6	79	2028	3	lig_an
lignan	7	55	1032	3	lignan
logway	13	3	591	3	logway
midway	15	32	715	3	midway
migg	8	57	1680	3	mig__g
oilway	12	3	574	3	oilway
ragbag	10	4	546	3	ragbag
ragtag	8	3	664	3	ragtag
sigla	6	45	1520	3	sigla_
sigma	8	45	1383	3	sigma_
sigmas	9	41	1136	3	sigmas
signa	6	61	1470	3	signa_
signage	9	3	777	3	signage
signal	7	37	1148	3	signal
swag	8	75	2673	3	__swag
tagrag	8	3	704	3	tagrag
viga	8	56	2296	3	vig_a_
vigas	9	48	1788	3	vig_as
vigia	9	48	1327	3	vigia_
vigias	10	41	1089	3	vigias
wag	7	64	5175	3	___wag
waging	11	43	1838	3	waging
wicca	12	4	725	3	wicca_
wiccan	13	3	503	3	wiccan
wiccas	13	3	654	3	wiccas
wifing	13	35	1339	3	wifing
wig	7	67	4038	3	wi___g
wigans	10	45	1170	3	wigans
wigeon	10	3	722	3	wigeon
wigged	12	44	1358	3	wigged
wigging	13	34	1383	3	wigging
wiggle	11	37	1301	3	wiggle
wiggly	14	55	968	3	wiggly
wiggy	13	45	1073	3	wig_gy
wight	12	37	2557	3	wig_ht
wights	13	33	1578	3	wights
wiglet	10	55	1915	3	wiglet
wigs	8	49	3125	3	wig__s
wigwagged	19	4	133	3	wigwagged
wigwagger	18	5	137	3	wigwagger
wiling	10	30	2429	3	wiling
windage	12	3	793	3	windage
windbag	14	4	412	3	windbag
windway	17	4	515	3	windway
wing	8	63	3922	3	wi__ng
winging	12	37	1871	3	winging
wingman	13	3	638	3	wingman
wining	10	36	2505	3	wining
wiping	12	39	1671	3	wiping
wireway	16	4	604	3	wireway
wiring	10	45	2102	3	wiring
wirra	8	32	1082	3	wirra_
wisha	11	49	1085	3	wisha_
wising	10	33	1822	3	wising
witan	8	38	1650	3	wi_tan
withal	12	3	893	3	withal
witing	10	35	2282	3	witing
wiving	13	33	1660	3	wiving
zigzags	17	4	227	3	zigzags

Search took 5 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	112716	0.123	1452772.4
2	DLD Change Limit	112716	81	4.813	23419.1
3	Display Results	81	81	0.030	2700.0
	(SQL Overall)	178691	81	4.966	35982.9