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

199 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
secular9221153(None) 
seculars10219391seculars
specular12217611specular
escolar946052escolar
facular122810442facular
fecula113310052fecula_
feculae12339202feculae
jocular1637302jocular
locular938952locular
macular113011942macular
nebular956482nebular
ocular8610132_ocular
oscular937932oscular
peculiar1245452peculiar
regular838422regular
saccular1246892saccular
scalar83612432s_calar
secpar1037922sec_par
secularly1445222secularly
securer958252securer
simular938672simular
specula11187412specula_
spicular12238902spicular
tegular836602tegular
venular1037682venular
acicular12218663acicular
alular6311353_alular
angular838533angular
annular737693annular
avicular13237273avicular
bacula103112673bacula_
canular9310323canular
cedula977643cedula_
cedulas1058503cedulas
cellar84514983ce_llar
cellular1045163cellular
circular1247903circular
copular113810603copular
cupular11317623cupular
declare10411223dec_lare
declaw1266703dec_law
decolor1087033decolor
decuman1236573decuman
desugar944033desugar
eclair836813_ec_lair
eclat7523603_ec_lat
escar74011993esc__ar
eschar1136523esc_har
escolars1045343escolars
fabular12288693fabular
facula112912233facula_
faculae123210353faculae
ferula93011173ferula_
ferulae10309603ferulae
ferulas103110753ferulas
feuar8310243fe_u_ar
fibular12267973fibular
frenular1144633frenular
furcular1345703furcular
gular6314833__gular
hamular1236973hamular
heckler16278573heckler
insular7138703insular
jugular1534513jugular
lacunar9136293lacunar
ligular8348533ligular
lobular936663lobular
lunular736013lunular
macula103013673macula_
maculae113412863maculae
maculas113114023maculas
medlar93010463me_dlar
medullar1143463medullar
modular1087363modular
molecular1344003molecular
morular978223morular
muscular1246243muscular
mutular936643mutular
nebula857333nebula_
nebulae955493nebulae
nebulas957583nebulas
nectar838853nec_tar
neurular844003neurular
nodular876703nodular
ocellar936533ocellar
oculars948363_oculars
opercular1345083opercular
oracular1047533oracular
oscula837293oscula_
ossicular1144083ossicular
ovular946833_ovular
pabular11259473pabular
papular11299763papular
peculate122414663peculate
peculator1387863peculator
peculia1147133peculia
peculiars1343453peculiars
pedicular1445773pedicular
pedlar93311273pe_dlar
pendular1144943pendular
piacular1246573piacular
pilular938203pilular
popular11319563popular
radular837833radular
ranular739433ranular
reclad9311873rec_lad
recolor978693recolor
recur74116843recu__r
recusal968673recusal
regulars936253regulars
reticular1147113reticular
scalare93311833s_calare
scalars93711903s_calars
scaler84321603s_caler
scapular1245373scapular
scar66434203s_c__ar
schedular1562463schedular
scholar1236953scholar
scuba94211593s_cuba_
scubas103710223s_cubas
sculch13226213s_culch
sculk115112463s_cul_k
sculker13318323s_culker
sculks123610263s_culks
scull75315763s_cul_l
sculler99812153s_culler
sculls84613883s_culls
sculp95314843s_cul_p
sculps104611753s_culps
sculpt104412693s_culpt
scuta75815753s_cuta_
sealer63928963se_aler
sear47353843se___ar
seceder10329573seceder
seclude1035233seclude
seconal9310073seconal
secpars1138413sec_pars
sectary1238273sec_tary
sector83415923sec_tor
secularise12146593secularise
secularism14165483secularism
secularist12177293secularist
secularity1545773secularity
secularize21167203secularize
secund937103secu_nd
secure8513533secu_re
secured1059723secured
securers1057153securers
secures9613163secures
seducer1056503seducer
seggar8357813se_ggar
selah8319613se__lah
seller63824593se_ller
seminar979753seminar
sequela1663993sequela_
sequelae1753673sequelae
serovar1046143serovar
serumal938783serumal
settler73410653settler
settlor7314733settlor
sewar85421093se__war
sexual1338413sexu_al
similar937853similar
simulars1047073simulars
singular9327563singular
solar55927343s__olar
solunar735283solunar
soucar839323s_oucar
spatular1044653spatular
specularly1753403specularly
speculate13239183speculate
speculator1484883speculator
speculum1474193speculum
spherular1442893spherular
spicula11259293spicula_
spiculae12218603spiculae
sporular1065223sporular
stelar64013863s_telar
stellar72610423stellar
stellular942733stellular
stipular1045843stipular
stylar9358113s_tylar
subalar9118073subalar
suckler133413093suckler
sugar6312913s__ugar
tabular9279763tabular
templar1145643templar
titular737523titular
tubular9267473tubular
tumular9236543tumular
undular837123undular
ungular836773ungular
uvular955563_uvular
vacuolar1353483vacuolar
vascular1346293vascular
vehicular1744283vehicular
velar85817633ve__lar
vesicular1445473vesicular
zonular1656493zonular

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.1561145455.1
2DLD Change Limit1340271996.95319276.1
3Display Results1991990.0762618.4
 (SQL Overall)1786911997.18524870.0
 
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.