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

119 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
smectic133661(None) 
emetic10614452eme_tic
hectic132311522_hectic
orectic1138822orectic
pectic122913872_pectic
sceptic1337832sceptic
sematic111716882sematic
septic102713192s_eptic
skeptic1545202skeptic
smectite1245772smectite
smectitic1543432smectitic
synectic1546332synectic
acetic10314503ace_tic
amebic1239113ame_bic
amentia9310153amentia
amnestic1247053amnestic
arctic10313513_arctic
asbestic1245383asbestic
ascetic11310063asce_tic
aseptic1137373aseptic
atactic11410083atactic
cometic131215723come_tic
cosmetic1447783cosme_tic
cretic102816283cre_tic
deictic1237703deictic
deltic9312503_deltic
demotic12412353demotic
docetic1239913docetic
domestic1347813domestic
dyslectic1773843dyslectic
eclectic1156073eclectic
electric1249183electric
elenctic1245883elenctic
emetics11610723eme_tics
emetin8613463eme_tin
etic66123953__e_tic
eutectic1245503eutectic
gametic12310003game_tic
gestic9312773_gestic
hematic141816753hematic
homeotic1548283homeotic
ictic9311803__ictic
identic1038043identic
kismetic1644883kisme_tic
lactic10713493_lactic
lectin82515013_lectin
lentic83515743_lentic
luetic8310383lue_tic
mantic104120903_mantic
mastic103119173_mastic
medic104619653_me_dic
meiotic11410933_meiotic
melic94722333_me_lic
mesic93617863_me_sic
metis75025903_me_tis
metric10314683_metric
mimetic1338653mime_tic
miotic103715753_miotic
mycotic1647713_mycotic
myotic133112313_myotic
mystic132711643_mystic
nematic111714003nematic
noetic8514043noe_tic
osmatic11179993osm_atic
osmotic11127613osm_otic
osteitic1046943osteitic
pectin102615533_pectin
peptic122113153_peptic
poetic10416843poe_tic
practic13312253practic
recti73619623_recti_
scenic10510513sce_nic
sceptics1455663sceptics
sciatic11910173sciatic
sect67443623s_ect__
sectile9311973s_ectile
section92515663s_ection
sector83415933s_ector
sects75622893s_ect_s
semantic1249553semantic
semeiotic1364653semeiotic
sememic1336503sememic
semiotic12710633semiotic
senti56226703s_enti_
sepic94617053s_e_pic
septics112810433s_eptics
sheltie10109913sheltie
skeptics1653863skeptics
smalti84111193smalti_
smartie9310173smartie
smectites1344623smectites
smelt74726783smelt__
smelted10399093smelted
smelter93311913smelter
smelting11339713smelting
smelts85412773smelt_s
somatic111916473somatic
somitic111512633somitic
soritic91414433soritic
spastic11310383spastic
specie10412223spec_ie
specific1744703specific
specter113111733specter
spectra11275833spectra
spectre11297773spectre
spermic1338523spermic
static83118683s_tatic
stearic939423stearic
stelic8313083ste_lic
stenotic1048083stenotic
steric8317063ste_ric
stichic1446243stichic
styptic1445453styptic
sweetie10157873sweetie
syenitic1346743syenitic
tactic10612753_tactic
thetic11412893the_tic
uretic82914353ure_tic
uveitic1244683uveitic

Search took 7 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.390458182.1
2DLD Change Limit1340271195.97022450.1
3Display Results1191190.0303966.7
 (SQL Overall)1786911196.39027964.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.