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

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

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

211 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
logicians	12	4	417	(None)
logician	11	4	522	1	logician_
logicises	12	5	620	2	logicises
logicizes	21	4	593	2	logicizes
magicians	14	4	457	2	magicians
clinicians	14	5	350	3	clinicians
colicins	12	3	1285	3	colici_ns
ethicians	14	4	528	3	ethicians
hominians	14	4	591	3	hominians
lochans	12	4	883	3	lo__chans
logans	7	63	1906	3	log___ans
loggias	9	35	678	3	log_gia_s
logical	10	3	851	3	logic_a_l
logicise	11	4	611	3	logici_se
logicised	13	4	394	3	logicised
logicising	14	4	372	3	logicising
logicize	20	4	604	3	logici_ze
logicized	22	4	499	3	logicized
logicizing	23	4	481	3	logicizing
logicless	12	4	252	3	logicless
logics	9	57	1112	3	logic___s
logins	7	78	2064	3	log__i_ns
logions	8	62	1129	3	log__ions
logisticians	15	6	240	3	log~~ist~~icians
longicorns	13	5	156	3	longicorns
magician	13	4	613	3	magician_
morticians	14	4	570	3	morticians
musicians	13	4	549	3	musicians
opticians	13	4	554	3	opticians
actinians	11	16	700	4	actinians
algicides	13	4	486	4	algicides
allicins	10	4	965	4	allici_ns
alogical	11	4	776	4	alogic_a_l
alopecias	13	4	441	4	alopecia_s
aphidians	15	4	405	4	aphidians
ascidians	12	4	450	4	ascidians
boccias	13	30	719	4	bo_ccia_s
bogans	9	57	1481	4	bog___ans
bogbeans	13	4	345	4	bog_beans
bohemians	16	4	344	4	bohemians
boliviano	14	5	220	4	boliviano
bolivianos	15	5	199	4	bolivianos
bolivias	13	4	539	4	bolivia_s
civilians	14	4	359	4	civilians
clinician	13	4	433	4	clinician_
cocains	11	13	1392	4	co__cains
codicils	13	4	604	4	codici_ls
coercions	13	4	620	4	coercions
cognitions	13	4	604	4	cognitions
coitions	10	3	1285	4	co_itions
colicin	11	3	1374	4	colici_n_
colicine	12	3	1299	4	colici_ne
colicines	13	3	1120	4	colicines
comedians	14	4	582	4	comedians
conidian	11	6	838	4	conidian_
conquians	20	4	518	4	conquians
cooncans	12	4	627	4	coonc_ans
countians	11	4	733	4	countians
crucians	12	4	529	4	_crucians
dieticians	13	4	412	4	dieticians
domiciles	14	4	542	4	domiciles
domicils	13	4	507	4	domici_ls
dominions	12	12	655	4	dominions
ethician	13	4	660	4	ethician_
ficins	11	35	1398	4	__fici_ns
floricane	14	4	483	4	floric_ane
floricanes	15	4	484	4	floric_anes
folacins	13	3	720	4	folaci_ns
gloxinias	17	4	249	4	gloxinia_s
gorgonians	12	5	181	4	gorgonians
hogans	10	59	1431	4	hog___ans
homicides	17	4	585	4	homicides
hominian	13	5	709	4	hominian_
indicans	11	4	766	4	indic_ans
indicias	11	4	741	4	indicia_s
lagans	7	57	1778	4	lag___ans
laicises	10	3	957	4	l_aicises
laicisms	12	4	712	4	l_aicisms
laicizes	19	3	740	4	l_aicizes
laminins	10	3	913	4	lamini_ns
legacies	11	3	904	4	legaci_es
legations	10	27	1192	4	legations
leggins	9	25	947	4	leg_gi_ns
legions	8	46	1178	4	leg__ions
legumins	11	4	499	4	legumi_ns
lenitions	9	3	947	4	lenitions
lesbians	10	4	360	4	l_esbians
leucins	9	3	810	4	l_euci_ns
lexicons	17	4	389	4	lexic_ons
lichens	12	35	1068	4	l__ichens
ligans	7	68	1773	4	l__i_gans
ligations	10	21	1199	4	ligations
lignans	8	39	885	4	l__ignans
lignins	8	40	1049	4	lig_ni_ns
ligroins	9	4	682	4	ligroi_ns
limans	8	48	1630	4	l__i_mans
linins	6	59	2214	4	l__ini_ns
lipins	8	50	1688	4	l__ipi_ns
loans	5	60	2646	4	lo____ans
lobations	11	21	961	4	lobations
lobefins	13	4	482	4	lobefi_ns
lobelias	10	4	720	4	lobelia_s
locals	8	37	1450	4	lo__c_als
locations	11	25	1274	4	locations
lochan	11	3	909	4	lo__chan_
locutions	11	20	706	4	locutions
lodicules	12	4	336	4	lodicules
logan	6	81	2328	4	log___an_
logania	8	4	783	4	logania__
loggats	9	28	645	4	log__gats
loggia	8	45	705	4	log_gia__
logging	10	33	1680	4	log_gi_ng
loggings	11	39	823	4	log_gings
logia	6	81	1660	4	log__ia__
logic	8	82	1783	4	logic____
logically	15	4	897	4	logically
logicalness	14	5	324	4	logicalness
login	6	60	2500	4	log__i_n_
loginess	9	3	1016	4	logi_ness
logion	7	60	1372	4	log__ion_
logistician	14	6	298	4	log~~ist~~ician_
logistics	12	4	506	4	logistics
logjams	17	4	358	4	log__jams
logograms	13	5	469	4	logograms
logons	7	98	1817	4	log___ons
logways	14	3	451	4	log__ways
loiding	9	33	1340	4	lo_idi_ng
loins	5	67	2842	4	lo___i_ns
lomeins	9	6	947	4	lo_mei_ns
longans	8	45	1081	4	lo__ngans
longicorn	12	5	221	4	longicorn_
lorans	6	51	1760	4	lo___rans
lorica	8	3	1044	4	loric_a__
loricae	9	3	825	4	loric_a_e
loricate	10	3	1066	4	loric_ate
loricates	11	3	1012	4	loricates
lotions	7	46	1476	4	lo__tions
lunarians	9	4	551	4	lunarians
lyricises	14	98	1087	4	lyricises
lyricisms	16	197	901	4	lyricisms
lyricists	14	79	835	4	lyricists
lyricizes	23	78	784	4	lyricizes
lyricons	13	4	358	4	lyric_ons
magians	10	3	1075	4	mag__ians
meridians	12	4	554	4	meridians
monecian	12	4	728	4	monecian_
monitions	11	3	1088	4	monitions
mortician	13	4	699	4	mortician_
musician	12	4	669	4	musician_
noggins	9	28	845	4	nog_gi_ns
noticing	11	3	945	4	notici_ng
noviciate	14	4	442	4	noviciate
noviciates	15	4	376	4	noviciates
obsidians	12	4	315	4	obsidians
oceans	8	12	1100	4	_o__ceans
ocicats	11	13	741	4	_ocic_ats
octans	8	14	1114	4	_o__ctans
officials	17	4	340	4	officials
officiant	17	4	506	4	officiant
officiants	18	5	342	4	officiants
oilcans	9	3	681	4	_o_ilcans
omicrons	12	7	519	4	_omicrons
oolachans	14	12	271	4	oolachans
ophidians	15	4	302	4	ophidians
opinions	10	4	593	4	_opinions
optician	12	4	724	4	optician_
orcins	8	33	1343	4	_o_rci_ns
origans	8	3	997	4	_ori_gans
origins	8	3	1046	4	_origi_ns
ovicides	14	4	546	4	_ovicides
pagurians	12	4	339	4	pagurians
patricians	14	5	628	4	patricians
pelicans	12	3	809	4	pelic_ans
pemicans	14	4	703	4	pemic_ans
physicians	20	5	328	4	physicians
pogonias	11	4	851	4	pogonia_s
poinciana	13	4	248	4	poinciana
poincianas	14	6	225	4	poincianas
policies	12	24	1566	4	polici_es
policing	13	3	1167	4	polici_ng
politicians	15	5	551	4	politicians
positions	11	8	1150	4	positions
prosimians	14	6	511	4	prosimians
quotidians	20	5	170	4	quotidians
regicides	13	4	581	4	regicides
ricins	8	36	1870	4	__rici_ns
rogations	10	15	1082	4	rogations
rosarians	9	4	579	4	rosarians
rubricians	14	5	319	4	rubricians
salicins	10	3	1093	4	salici_ns
sericins	10	3	1246	4	serici_ns
simians	9	5	920	4	__simians
slogans	8	40	798	4	slog___ans
socials	9	9	963	4	so__cials
solicitant	12	5	424	4	solicitant
solicitants	13	5	217	4	solicitants
solicits	10	3	1102	4	solici_ts
soricine	10	7	1088	4	sorici_ne
tacticians	14	4	423	4	tacticians
titians	7	27	1045	4	__titians
tolidins	9	4	802	4	tolidi_ns
toucans	9	3	758	4	to_uc_ans
toxicant	17	4	629	4	toxic_ant
toxicants	18	4	383	4	toxic_ants
viridians	13	4	367	4	viridians
voicing	13	27	908	4	vo_ici_ng
voicings	14	27	461	4	vo_icings
volitions	12	8	866	4	volitions
wiccans	14	3	460	4	__wiccans
yoginis	11	45	768	4	yogini__s
yogins	10	51	1410	4	yog__i_ns

Search took 19 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	165329	0.186	960704.3
2	DLD Change Limit	165329	211	18.000	9184.9
3	Display Results	211	211	0.093	2268.8
	(SQL Overall)	178691	211	18.279	9775.8