Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

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

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

190 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
ecesic1036922(None) 
ecesis84611201ecesis
acetic10314502acetic
ceric94023092_ceric
echoic1339042echoic
edenic9310222edenic
emesis84712622emesis
emetic10614452emetic
mesic93617862_mesic
scenic10510512scenic
acedia9310393acedia
acerbic1335643acerbic
aces67645093aces__
acetin8314693acetin
acidic113612133acidic
acinic104713543acinic
acmic11312333ac_mic
amebic1239103amebic
amnesic1137183amnesic
anemic102713693anemic
anisic8313793anisic
areic73219393are_ic
ascesis938373ascesis
ascetic11310063ascetic
atelic8313703atelic
atresic9310003atresic
axenic154210003axenic
basic96220523_basic
benefic1446043benefic
caseic103212373_caseic
cebid104314063_cebid
cedi74919273_cedi_
cedis84317083_cedis
cees65941593cees__
ceil65725063_ce_il
celiac101910433_celiac
cerci93716393_cerci
ceria75125353_ceria
cesium1039583_cesium
cess65326053_ces_s
cesta75419483_cesta
cesti75217423_cesti
chemic153012093chemic
chic115925203_c_hic
civic123412543_civic
cleric10612133cleric
colic95726173_colic
comic114721813_comic
conic95329793_conic
cosec96320183_cosec
cosie74728263_cosie
cosmic12410343_cosmic
cretic102816283cretic
crisic103611843crisic
cubic114313413_cubic
cusec94614903_cusec
cyesis1148573cyesis
cynic124712423_cynic
cystic132710653_cystic
deceit93018213dece_it
demic105119193_demic
diesis74013493diesis
docetic1239913docetic
ecbolic1345623ecbolic
ecclesia1244103ecclesia
ecdysis1343223ecdysis
ecesises1037023ecesises
eches106322163eches__
eclair836813eclair
eclectic1156073eclectic
ectasis9249613ectasis
ectatic11310123ectatic
ectopic1338153ectopic
ecumenic1484823ecumenic
ecus65421463ecus__
eerie55228533e_erie
egest65222343eges_t
egesta7428653egesta
egests74411253egests
eidetic1039743eidetic
eirenic939003eirenic
ekes86726603ekes__
ekistic1377843ekistic
elastic93013393elastic
elegiac1045453elegiac
elegit71212893elegit
elemi7312503elemi_
elemis8312383elemis
emes65434663emes__
emeses86114963emeses
emetics11610723emetics
emetin8613463emetin
emic86422743__emic
enatic8317563enatic
endemic1237893endemic
enolic8413353enolic
enosis63816423enosis
enteric9314213enteric
eosin55220923e_osin
epeiric1145313epeiric
ephebic1646513ephebic
epic86921303__epic
erepsin937383erepsin
erethic1257723erethic
eristic9814083eristic
erotic82620263erotic
eses45336103eses__
etesian757853etesian
etheric12311783etheric
ethic101511223e_thic
ethnic1148853ethnic
etic66123953__etic
eugenic1038603eugenic
eves76230463eves__
ewes76328703ewes__
excess1546053exces_s
exec135313943exe__c
exes116530813exes__
exilic1597783exilic
exonic153211413exonic
exosmic1844373exosmic
exotic153112643exotic
eyelid1038433eyelid
eyes75837883eyes__
feces105625363feces__
felsic1147053felsic
generic101310753generic
genesis82510823genesis
genetic101211783genetic
genic85119393_genic
geodesic1243563geodesic
gestic9312773_gestic
haemic133210083haemic
hebetic1438633hebetic
hectic132311513hec_tic
hemic125718623_hemic
heretic12314833heretic
hyenic1438723hyenic
ices66129643ices__
iconic10411593iconic
icteric1138023icteric
ictic9311793ic_tic
irenic8311103irenic
kinesic13257023kinesic
leucemic1443133leucemic
lexemic1844283lexemic
luetic8310383luetic
medic104619653_medic
melic94722333_melic
music94316403_music
nemesis937373nemesis
noesis6311443noesis
noetic8514043noetic
oceanic1146163oceanic
oleic7313333ole_ic
pectic122913873pec_tic
phasic133612053phasic
physic16288473physic
poetic10416843poetic
pyemic1537893pyemic
racemic1336983racemic
recess8314263reces_s
relic74623363_relic
resid64124093_resid
resin54131053_resin
resit54241043_resit
scenics1137773scenics
sceptic1337823sceptic
sebasic1146893sebasic
selenic9410663selenic
sememic1336503sememic
sepic94617053_sepic
sic55847873___sic
stelic8313083stelic
steric8317063steric
technic1496903technic
telesis7310793telesis
telestic10118953telestic
telic76019823_telic
tenesmic1244293tenesmic
terebic1137983terebic
thesis94913733thesis
thetic11412883thetic
tmesis8529793tmesis
ureic74514463ure_ic
uremic103410513uremic
uretic82914353uretic
vesica11157913_vesica
xenic144114643_xenic
xeric144315663_xeric

Search took 10 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911127160.203880251.2
2DLD Change Limit1127161909.04612460.3
3Display Results1901900.0802375.0
 (SQL Overall)1786911909.32919154.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.