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 “sematic” 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.

247 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
sematic11171688(None) 
hematic141816751hematic
nematic111714001nematic
semantic1249551semantic
somatic111916471somatic
acmatic13311702acmatic
comatic131816942comatic
demotic12412352demotic
emetic10614452_emetic
enatic8317562_enatic
haematic151310222haematic
hematics151712192hematics
hematin121516022hematin
hepatic141712772hepatic
neumatic1258532neumatic
osmatic11179992osmatic
rhematic15188932rhematic
schematic1847842schematic
sciatic11910172sciatic
sebacic1346392sebacic
sebasic1146892sebasic
semantics1346822semantics
sememic1336502sememic
semiotic12710632semiotic
septic102713192se_ptic
smectic1336612smectic
somitic111512632somitic
spermatic1548712spermatic
static83118682s_tatic
stemmatic1546012stemmatic
stomatic12312002stomatic
thematic152011492thematic
venatic12311522venatic
agnatic10310973agnatic
aposematic1654253aposematic
aquatic1838113aquatic
aromatic12315643aromatic
aseptic1137373ase_ptic
astatic9514193astatic
asthmatic1647583asthmatic
aviatic1239253aviatic
bemata10411693bemat_a
bregmatic1644083bregmatic
ceramic1339823ceramic
ceratin93020163ceratin
cerotic11415063cerotic
cinematic1546383cinematic
clematis1248653clematis
climatic1448733climatic
comatik15139723comatik
cometic131215723cometic
cymatia1446443cymatia
dalmatic1348693dalmatic
deictic1237703deictic
deistic10311173deistic
deltaic1037023deltaic
deltic9312503de_ltic
demic105119193dem__ic
demonic12311223demonic
demotics1338753demotics
deontic1038883deontic
dogmatic1447633dogmatic
dramatic1369433dramatic
ectatic11310123ectatic
elastic93013393_elastic
email74715103_ema_il
emetics11610723_emetics
emetin8613463_emetin
emic86422753_em__ic
empathic1764663_empathic
emphatic1747863_emphatic
eremitic1248553eremitic
erotic82620273_erotic
erratic9311123erratic
etic66123953_e__tic
exotic153112653_exotic
fanatic12610703fanatic
fumaric1446313fumaric
gametic12310003gametic
gelati73814533gelati_
gelatin83514733gelatin
gelatis83313513gelatis
gematria1175693gematria
genetic101211783genetic
geomantic1445983geomantic
germanic1367503germanic
gestic9312773ge_stic
haematics16157033haematics
haematin13148893haematin
hebetic1438633hebetic
hectic132311523he_ctic
hematal1238953hematal
hematein1387013hematein
hematine131614673hematine
hematinic1645203hematinic
hematins131714683hematins
hematite131612153hematite
hematitic1647203hematitic
hematoid1449753hematoid
hematuric1645233hematuric
hemic125718623hem__ic
hepatica15177593hepatica
hepatics15198933hepatics
heretic12314833heretic
hermetic15310243hermetic
hermitic1539653hermitic
hexadic2045413hexadic
hieratic1349223hieratic
himatia1248593himatia
kenotic1359713kenotic
keramic1537233keramic
keratin113314153keratin
ketotic1348643ketotic
kinematic1744913kinematic
komatik12135203komatik
lentic83515743le_ntic
lunatic938753lunatic
mafic125615463__mafic
magic105818663__magic
magmatic1548403magmatic
malic94525663__malic
manic94629443__manic
mantic104120903__mantic
mastic103119173__mastic
matin75132853__matin
meiotic11410933meiotic
melanic11310403melanic
memetics1447803memetics
mimetic1338653mimetic
nepotic11310563nepotic
neritic91314333neritic
neustic937943neustic
nomadic1248033nomadic
operatic1249933operatic
osmotic11127613osmotic
pectic122913873pe_ctic
pedantic1346583pedantic
pelagic1237863pelagic
pelitic111814653pelitic
peptic122113153pe_ptic
phatic133014413_phatic
piratic11314293piratic
pneumatic1545843pneumatic
prelatic12311293prelatic
psoatic1139303psoatic
remail85017123rema_il
remain85919863rema_in
rematch1436193rematch
remate84428683remat_e
remated103522473remated
remates93827123remates
remating112322423remating
rheumatic1654533rheumatic
romantic1249243romantic
sabbatic1445323sabbatic
salic73424713s__alic
satanic939933satanic
sati45539333s__ati_
satin55935223s__atin
satis55633683s__atis
sceptic1337833sceptic
schematics1945673schematics
sciatica12106113sciatica
sciatics12117273sciatics
seasick1346193se_asick
seat47575563se_at__
seated75131063se_ated
seater64534163se_ater
seating84130683se_ating
seats54844343se_at_s
sedarim1047113sedarim
sedate73019813sedat_e
sedated93714353sedated
sedater83713633sedater
sedates83418043sedates
sedating103014113sedating
sedation9312453sedation
sedative1238853sedative
seismic1145753seismic
selenic9410663selenic
semantical1445733semantical
semeiotic1364653semeiotic
semi65127223sem__i_
semiarid1147793semiarid
semifit1249973semifit
semiotics1376913semiotics
semis74623533sem__is
semitist10413323semitist
semitonic1347353semitonic
semplice1447013semplice
senarii7269143senarii
senate63725173senat_e
senates73322613senates
senator7313073senator
seniti64317223seniti_
senti56226703se_nti_
sepic94617053se__pic
septics112810433se_ptics
serac75925203sera__c
serai56830163sera_i_
serail64222673sera_il
serais64326133sera_is
seraphic1546633seraphic
seriatim1049223seriatim
sermonic1248883sermonic
sextain14257103sextain
shamanic1546573shamanic
sialic8313633s_ialic
simpatico1543853simpatico
skeptic1545203skeptic
smalti84111193s_malti_
smartie9310173s_martie
solatia7312253solatia
somata8312383somat_a
sonantic1048273sonantic
soritic91414433soritic
spastic11310383spastic
spathic1437543s_pathic
spermatia1346743spermatia
spermatid1448043spermatid
statice92614033s_tatice
statics93314533s_tatics
statin63921473s_tatin
stearic939423stearic
stenotic1048083stenotic
stigmatic1445733stigmatic
strati63518903strati_
stromatic13410213stromatic
strumatic1345773strumatic
styptic1445453styptic
sumac99514883suma__c
syenitic1346743syenitic
sylvatic1645353sylvatic
sympatico1844313sympatico
sympatric1864453sympatric
synaptic1546283synaptic
systematic1755283systematic
termitic1249283termitic
tetanic9810133tetanic
thematics16188113thematics
uratic83016363_uratic
vatic10316423__vatic
viatic11311453_viatic
xerotic16410863xerotic
zeatin15412823ze_atin
zeugmatic2342633zeugmatic
zymotic2345713zymotic

Search took 8 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 Filter1786911340270.406440125.6
2DLD Change Limit1340272476.87319500.5
3Display Results2472470.0932655.9
 (SQL Overall)1786912477.37224239.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.