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 “specular” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

95 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
specular1221761(None) 
secular92211531s_ecular
specula11187411specula_
spicular12238901spicular
opercular1345082opercular
peculiar1245452_peculiar
saccular1246892saccular
seculars10219392s_eculars
spatular1044652spatular
specularly1753402specularly
speculate13239182speculate
speculator1484882speculator
speculum1474192speculum
spherular1442892spherular
spicula11259292spicula_
spiculae12218602spiculae
sporular1065222sporular
acicular12218663acicular
avicular13237273avicular
circular1247903circular
facular122810443_facular
fecula113310053_fecula_
feculae12339203_feculae
frenular1144633frenular
furcular1345703furcular
jocular1637303_jocular
locular938953_locular
macular113011943_macular
molecular1344003molecular
muscular1246243muscular
nebular956483_nebular
ocular8610133__ocular
opercula1244993opercula_
operculars1443683operculars
opuscular1343273opuscular
oracular1047533oracular
oscular937933_oscular
ossicular1144083ossicular
pabular11259473_pabular
papular11299763_papular
peculate122414663_peculate
peculator1387863_peculator
peculia1147133_peculia
peculiars1343453_peculiars
pedicular1445773_pedicular
pedlar93311273_pe_dlar
pendular1144943_pendular
piacular1246573piacular
pilular938203_pilular
popular11319563_popular
regular838423_regular
scalar83612433s__calar
scapular1245373scapular
schedular1562463schedular
secpar1037923s_ec_par
secularly1445223s_ecularly
securer958253s_ecurer
simular938673s_imular
singular9327563singular
spatula935893spatula_
spatulas1045473spatulas
spear75821063spe___ar
special11310303spec_ial
specialer1344733specialer
specials1238033specials
speckle15297553speckl_e
speckled17255833speckled
speckles16268133speckles
spectacular1762313spectacular
specter113111733spec_ter
spectra11275833spectra_
spectral12246193spectral
specularity1853963specularity
speculated15186613speculated
speculates14237903speculates
speculators1564133speculators
speculums1562903speculums
speller95415143spe_ller
spiculate132210163spiculate
spicule11269933spicul_e
spicules12219803spicules
spiculum1464213spiculum
spinula9257903spinula_
spinulae10276963spinulae
spiracular1453583spiracular
spirula9257703spirula_
spirulae10216573spirulae
spirulas10207203spirulas
stelar64013863ste__lar
stellar72610423ste_llar
stellular942733stellular
stipular1045843stipular
tegular836603_tegular
vascular1346293vascular
venular1037683_venular

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 Filter1786911461620.1561145455.1
2DLD Change Limit146162957.29620033.2
3Display Results95950.0332878.8
 (SQL Overall)178691957.48523873.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.