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

80 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
saccular124689(None) 
acicular12218662_acicular
facular122810442fa_cular
macular113011942ma_cular
sacculate1349022sacculate
saccule1136742saccul_e
saccules1237032saccules
sacculi1145042saccul_i
sacculus1244812sacculus
scapular1245372scapular
secular92211532s_ecular
specular12217612specular
spicular12238902spicular
vascular1346292vascular
accusal11136003_accusal
accuser11347933_accuser
acicula11228133_acicula_
aciculae12267703_aciculae
aciculas12228563_aciculas
alular6311353_a_lular
angular838533_angular
annular737693_annular
avascular1443733avascular
avicular13237273avicular
bacillar1276533bacillar
bacula103112673ba_cula_
calycular1643483calycular
canicular1346463canicular
cannular1046283cannular
canular9310323ca_nular
capsular1245403capsular
circular1247903circular
fabular12288693fa_bular
facula112912233fa_cula_
faculae123210353fa_culae
fascicular1753293fascicular
furcular1345703furcular
hamular1236973ha_mular
jocular1637303_jocular
lacunar9136293la_cunar
locular938953_locular
macula103013673ma_cula_
maculae113412863ma_culae
maculas113114023ma_culas
muscular1246243muscular
navicular1444693navicular
ocular8610133__ocular
oracular1047533oracular
oscular937933_oscular
ossicular1144083ossicular
pabular11259473pa_bular
papular11299763pa_pular
piacular1246573piacular
radicular1245883radicular
radular837833ra_dular
ranular739433ra_nular
sacculated1546623sacculated
scalar83612433s__calar
scapula1136343scapula_
scapulae1255433scapulae
scapulars1343873scapulars
scapulary1643203scapulary
scapulas1246133scapulas
scholar1236953s_cholar
seculars10219393s_eculars
simular938673s_imular
singular9327563singular
spatular1044653spatular
specula11187413specula_
spicula11259293spicula_
spiculae12218603spiculae
sporular1065223sporular
stipular1045843stipular
succuba1343443succuba_
succubae1443083succubae
succubas1443853succubas
tabular9279763ta_bular
vacuolar1353483vacuolar
valvular1443463valvular
vascula1245853vascula_

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 Filter1786911461620.593301333.9
2DLD Change Limit146162808.64316911.0
3Display Results80800.0302666.7
 (SQL Overall)178691809.26619284.6
 
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.