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

145 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
spicula1125929(None) 
specula11187411specula
spiculae12218601spiculae
spicular12238901spicular
spicule11269931spicule
spinula9257901spinula
spirula9257701spirula
acicula11228132acicula
apiculi1145112apiculi
picul95015362_picul_
piculs103511752_piculs
silicula1065392silicula
spatula935892spatula
specular12217612specular
spica94717942spic__a
spicily1438652spicily
spiculate132210162spiculate
spicules12219802spicules
spiculum1464212spiculum
spinulae10276962spinulae
spinule9299992spinule
spirulae10216572spirulae
spirulas10207202spirulas
aciculae12267703aciculae
acicular12218663acicular
aciculas12228563aciculas
apical10913903apical_
apicals1159923apicals
apiculate13279883apiculate
apiculus1245413apiculus
auricula1045803auricula
avicular13237273avicular
bacula103112673_bacula
capitula1244983capitula
cicala10310053_cicala
cubicula1444073cubicula
cuticula1244953cuticula
epical10413393epical_
epicure1136823epicure
facula112912233_facula
fecula113310053_fecula
fibula11258053_fibula
furcula1245793furcula
inocula947263inocula
ligula7359673_ligula
macula103013673_macula
opercula1244993opercula
opuscula1242793opuscula
oscula837293_oscula
ossicular1144083ossicular
papula103011113_papula
peculia1147133_peculia
piacular1246573_piacular
pica85831493_pic__a
pical95524373_pical_
picara10311903_picara
pickle144215653_pickle
pilular938203_pilular
pilule8411123_pilule
pinnula934913_pinnula
primula1145713primula
pula65129373_p__ula
reticula1047413reticula
saccular1246893saccular
saccule1136743saccule
sacculi1145043sacculi
scapula1136343scapula
scilla8310943sci_lla
scopula1154993scopula
scuba94211593s__cuba
sculk115112463s__culk
scull75315763s__cull
sculp95314843s__culp
scuta75815753s__cuta
secular92211533s_ecular
shicksa1634103shicksa
sickle124418323s_ickle
sickly153110483s_ickly
sigla64515203s_i_gla
siliculae1154283siliculae
simular938673s_imular
slickly1635853slickly
spacial1138763spacial
spackle15369573spackle
spatular1044653spatular
spatulas1045473spatulas
special11310303special
speckle15297553speckle
spectra11275833spectra
speculate13239193speculate
speculum1474193speculum
spic85227433spic___
spicae104313703spic_ae
spicas104715823spic_as
spicate113214193spicate
spice95528813spic__e
spiced115218313spic_ed
spicer104719313spic_er
spicers113815553spicers
spicery14499013spicery
spices104326033spic_es
spicey134414233spic_ey
spicier115112463spicier
spicing123914533spicing
spick134519073spic__k
spicks144814993spic_ks
spics94123243spic__s
spicy125417713spic__y
spiel74623913spi_el_
spiels85317953spi_els
spikily1635873spikily
spile75230083spi__le
spill74821163spi__ll
spills84717463spi_lls
spilt75532223spi__lt
spinal84915313spinal_
spinals93911863spinals
spindle103210093spindle
spindly13257383spindly
spinel85317333spinel_
spinels94512443spinels
spinules10249333spinules
spiracular1453583spiracular
spiraea9407983spiraea
spiral83715343spiral_
spirals93212513spirals
spirea84015633spi_rea
spirilla1045073spirilla
spirulina1143423spirulina
spital83813873spital_
spitals93011593spitals
spittle937923spittle
sporular1065223sporular
sporule937273sporule
sputa74612963sp__uta
stickle132410973stickle
stimuli944513stimuli
stipular1045843stipular
stipule936723stipule
subcult1149603subcult
succuba1343443succuba
vascula1245853vascula
vesicula1345223vesicula
vicuna11115903_vicuna
vincula1246393vincula

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.420425454.8
2DLD Change Limit1340271456.73619897.1
3Display Results1451450.0632301.6
 (SQL Overall)1786911457.21924752.9
 
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.