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

100 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
spicular1223890(None) 
specular12217611specular
spicula11259291spicula_
spiculae12218601spiculae
acicular12218662acicular
avicular13237272avicular
ossicular1144082ossicular
piacular1246572_piacular
pilular938202_pilular
saccular1246892saccular
secular92211532s_ecular
simular938672s_imular
spatular1044652spatular
specula11187412specula_
spiculate132210162spiculate
spicule11269932spicul_e
spicules12219802spicules
spiculum1464212spiculum
spinula9257902spinula_
spinulae10276962spinulae
spiracular1453582spiracular
spirula9257702spirula_
spirulae10216572spirulae
spirulas10207202spirulas
sporular1065222sporular
stipular1045842stipular
acicula11228133acicula_
aciculae12267703aciculae
aciculas12228563aciculas
apiculate13279883apiculate
apiculi1145113apicul_i
apiculus1245413apiculus
articular1179383articular
auricular1146313auricular
canicular1346463canicular
capitular1343773capitular
circular1247903circular
cuticular1345183cuticular
facular122810443_facular
fascicular1753293fascicular
fibular12267973_fibular
funicular14114753funicular
furcular1345703furcular
jocular1637303_jocular
ligular8348533_ligular
locular938953_locular
macular113011943_macular
muscular1246243muscular
navicular1444693navicular
ocular8610133__ocular
opercular1345083opercular
opuscular1343273opuscular
oracular1047533oracular
orbicular1344683orbicular
oscular937933_oscular
pabular11259473_pabular
papular11299763_papular
peculiar1245453_peculiar
pedicular1445773pedicular
picul95015363_picul__
piculs103511753_picul_s
pilar75221503_pi__lar
pillar8314023_pi_llar
pinnular1044433_pinnular
popular11319563_popular
radicular1245883radicular
reticular1147113reticular
scalar83612433s__calar
scapular1245373scapular
seculars10219393s_eculars
silicula1065393silicula_
siliculae1154283siliculae
similar937853s_imilar
simulars1047073s_imulars
singular9327563singular
spatula935893spatula_
spatulas1045473spatulas
specularly1753403specularly
speculate13239183speculate
speculator1484883speculator
speculum1474193speculum
spherular1442893spherular
spica94717943spic__a_
spicae104313703spic__ae
spicas104715823spic__as
spicer104719313spic__er
spicier115112463spic_ier
spicily1438653spicil_y
spieler93111233spi_eler
spiller92914333spi_ller
spindler11297983spindler
spinule9299993spinul_e
spinules10249333spinules
stickler14259573stickler
testicular1254553testicular
titular737523_titular
utricular1145773utricular
vascular1346293vascular
vehicular1744283vehicular
vesicular1445473vesicular

Search took 9 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 Limit1461621008.09318060.3
3Display Results1001000.0462173.9
 (SQL Overall)1786911008.29521542.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.