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

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

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

227 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
chandler	14	35	837	(None)
candler	10	35	1659	1	c_andler
chandlers	15	38	767	1	chandlers
chandlery	18	38	442	1	chandlery
handler	11	35	1616	1	_handler
candle	9	43	2148	2	c_andle_
candled	11	38	1574	2	c_andled
candlers	11	42	1410	2	c_andlers
candles	10	44	2234	2	c_andles
chancer	14	42	1563	2	chan_cer
chancier	15	3	882	2	chancier
chandelier	16	5	429	2	chandelier
changer	13	42	1554	2	chan_ger
channeler	14	4	460	2	channeler
chanter	12	39	1973	2	chan_ter
cradler	10	29	1051	2	cra_dler
dandler	9	44	1427	2	_dandler
hander	10	45	2643	2	_hand_er
handier	11	38	1744	2	_handier
handle	10	42	1929	2	_handle_
handled	12	41	1453	2	_handled
handlers	12	40	1414	2	_handlers
handles	11	40	2065	2	_handles
landler	8	41	1320	2	_landler
angler	7	40	1786	3	__angler
antler	6	46	1555	3	__antler
bander	9	39	2822	3	_band_er
blander	10	37	1516	3	bland_er
brander	10	39	1582	3	brand_er
bundler	10	40	1172	3	_bundler
cabler	10	45	1917	3	c_a_bler
cackler	15	38	1257	3	c_ackler
cadger	10	50	1391	3	c_a_dger
cajoler	16	39	839	3	c_ajoler
caller	8	51	2548	3	c_a_ller
canaled	10	36	1556	3	c_analed
canaller	10	3	895	3	c_analler
canceler	12	23	891	3	c_anceler
cancer	10	42	2092	3	c_an_cer
candela	10	8	974	3	c_andela
candider	12	3	734	3	c_andider
candied	11	38	1602	3	c_andied
candies	10	41	2561	3	c_andies
candor	9	45	1642	3	c_and_or
candour	10	42	1024	3	c_andour
caner	7	53	3477	3	c_an__er
canker	12	44	2252	3	c_an_ker
canner	8	46	2598	3	c_an_ner
cannier	9	40	1416	3	c_annier
canoer	8	51	2107	3	c_an_oer
canter	8	52	3011	3	c_an_ter
cantle	8	45	2215	3	c_antle_
cantles	9	47	2141	3	c_antles
canular	9	3	1032	3	c_anular
carder	9	45	2418	3	c_ard_er
caroler	9	38	1675	3	c_aroler
caudle	9	39	1291	3	c_audle_
caudles	10	39	1281	3	c_audles
caviler	12	4	906	3	c_aviler
chadar	12	3	935	3	cha_d_ar
chadless	14	3	640	3	cha_dless
chador	12	3	867	3	cha_d_or
chafer	14	47	1457	3	cha__fer
chaffer	18	38	947	3	cha_ffer
chaffier	19	3	547	3	chaffier
chaleh	14	37	1199	3	cha__leh
chalet	11	38	2599	3	cha__let
chalkier	17	3	675	3	chalkier
chamber	16	40	1106	3	cha_mber
chamfer	17	39	986	3	cha_mfer
champer	16	38	1341	3	cha_mper
chance	13	46	1709	3	chan_ce_
chanced	15	41	1321	3	chan_ced
chancel	14	40	1177	3	chan_cel
chancels	15	43	908	3	chancels
chancers	15	43	1349	3	chan_cers
chancery	18	36	665	3	chan_cery
chances	14	52	1809	3	chan_ces
chancre	14	34	878	3	chancre_
chancres	15	42	936	3	chancres
chandeliers	17	4	348	3	chandeliers
chandelle	15	4	522	3	chandelle
chandelled	17	4	427	3	chandelled
chandelles	16	4	534	3	chandelles
chandleries	17	4	433	3	chandler~~ies~~
change	12	41	1675	3	chan_ge_
changed	14	42	1414	3	chan_ged
changers	14	43	1320	3	chan_gers
changes	13	45	1758	3	chan_ges
channel	12	39	1048	3	chan_nel
channeled	15	4	491	3	channeled
channelers	15	4	385	3	channelers
channels	13	38	849	3	channels
chanted	13	40	1595	3	chan_ted
chanters	13	40	1674	3	chan_ters
chantey	15	41	1254	3	chan_tey
chanties	13	26	1580	3	chanties
chantor	12	37	1031	3	chan_tor
chapiter	15	3	660	3	chapiter
chaplet	14	5	1225	3	cha_plet
chapter	14	42	1385	3	cha_pter
charger	13	39	1406	3	cha_rger
charier	12	43	1790	3	cha_rier
charley	15	11	827	3	cha_rley
charmer	14	49	1366	3	cha_rmer
charrier	13	7	868	3	charrier
charter	12	39	1830	3	cha_rter
chaser	11	49	1838	3	cha__ser
chaster	12	47	1850	3	cha_ster
chatter	12	44	1664	3	cha_tter
chattier	13	3	751	3	chattier
chaufer	15	34	794	3	cha_ufer
chauffer	19	26	379	3	chauffer
chaunter	13	6	639	3	chaunter
chawer	14	43	1441	3	cha__wer
cheder	12	51	1349	3	ch_ed_er
chider	12	51	1605	3	ch_id_er
childlier	15	4	309	3	childlier
chiller	12	41	1218	3	ch_iller
chinkier	17	37	736	3	chinkier
chiseler	13	3	590	3	chiseler
choler	11	37	1715	3	ch__oler
chortler	13	33	684	3	chortler
chowder	16	38	781	3	chowd_er
chuckler	19	3	555	3	chuckler
chudder	14	24	594	3	ch_udder
chunkier	17	39	588	3	chunkier
chunter	12	39	1148	3	chun_ter
cinder	9	41	1912	3	c_ind_er
clanger	10	41	1349	3	clan_ger
clankier	14	32	708	3	clankier
coaler	8	41	2171	3	coa__ler
coddler	11	37	1083	3	c_oddler
colander	11	3	903	3	coland_er
condoler	11	34	1212	3	c_ondoler
cradle	9	33	1316	3	cra_dle_
cradled	11	34	1081	3	cra_dled
cradlers	11	30	920	3	cra_dlers
cradles	10	31	1413	3	cra_dles
cranker	13	36	1279	3	cran_ker
crankier	14	33	916	3	crankier
crankle	13	36	1006	3	crankle_
crankled	15	40	815	3	crankled
crankles	14	35	1015	3	crankles
crawler	12	35	1046	3	cra_wler
cuddler	11	38	1074	3	c_uddler
curdler	10	35	1156	3	c_urdler
dander	8	112	2299	3	_dand_er
dandier	9	37	1457	3	_dandier
dandle	8	42	1809	3	_dandle_
dandled	10	33	1354	3	_dandled
dandlers	10	39	1205	3	_dandlers
dandles	9	42	1853	3	_dandles
dangler	9	69	1281	3	_dangler
dawdler	12	35	679	3	_dawdler
fondler	11	34	888	3	_fondler
gander	8	43	2276	3	_gand_er
grander	9	33	1587	3	grand_er
hackler	16	35	1235	3	_hackler
haggler	12	32	893	3	_haggler
hailer	9	47	2034	3	_ha_iler
haler	8	50	3352	3	_ha__ler
hanaper	12	3	713	3	_hanaper
handcar	13	3	737	3	_handcar
handed	11	49	1998	3	_hand_ed
handers	11	42	2433	3	_hand_ers
handlebar	15	4	235	3	_handlebar
handless	12	35	1206	3	_handless
handover	15	12	682	3	_handover
handsel	11	30	872	3	_handsel
handset	11	30	1682	3	_handset
hanger	10	40	2325	3	_han_ger
hanker	13	46	2209	3	_han_ker
hantle	9	43	1820	3	_hantle_
hantles	10	41	1751	3	_hantles
harder	10	50	2240	3	_hard_er
hardier	11	47	2154	3	_hardier
hauler	9	50	1512	3	_ha_uler
hinder	10	41	2006	3	_hind_er
hondle	10	39	1452	3	_hondle_
hondled	12	35	1065	3	_hondled
hondles	11	36	1452	3	_hondles
huddler	12	37	942	3	_huddler
hurdler	11	36	1000	3	_hurdler
jangler	15	38	1183	3	_jangler
kindler	12	30	998	3	_kindler
ladler	7	43	1493	3	_la_dler
lander	7	40	2848	3	_land_er
landlers	9	43	1283	3	_landlers
mangler	10	32	1564	3	_mangler
meander	10	4	997	3	meand_er
paddler	11	37	1155	3	_paddler
pander	9	37	2552	3	_pand_er
panhandler	16	5	254	3	panhandler
randier	8	36	1847	3	_randier
rehandle	12	4	617	3	rehandle_
rehandled	14	4	476	3	rehandled
rehandles	13	4	559	3	rehandles
saddler	9	38	1196	3	_saddler
sander	7	48	2853	3	_sand_er
sandier	8	40	1784	3	_sandier
shackler	17	31	797	3	shackler
shader	10	42	1876	3	sha_d_er
shadier	11	31	1115	3	sha_dier
shandies	12	27	1410	3	shandies
shingler	12	26	863	3	shingler
slander	8	40	1544	3	sland_er
spindler	11	29	798	3	spindler
stander	8	43	1616	3	stand_er
swindler	12	25	772	3	swindler
tangler	8	35	1507	3	_tangler
thaler	9	46	1310	3	tha__ler
thanker	14	30	959	3	than_ker
thunder	11	3	696	3	thund_er
trundler	9	25	615	3	trundler
twaddler	13	31	464	3	twaddler
twangler	12	4	411	3	twangler
unhandier	13	4	488	3	unhandier
unhandled	14	4	570	3	unhandled
waddler	12	40	1079	3	_waddler
wander	10	44	2371	3	_wand_er
wandle	10	53	1666	3	_wandle_
wangler	11	33	1265	3	_wangler
whaler	12	46	1197	3	wha__ler
wheedler	15	4	354	3	wheedler
wrangler	12	4	547	3	wrangler
zander	16	34	1711	3	_zand_er

Search took 9 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	146162	0.420	425454.8
2	DLD Change Limit	146162	227	7.546	19369.5
3	Display Results	227	227	0.080	2837.5
	(SQL Overall)	178691	227	8.046	22208.7