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

229 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
spicule1126993(None) 
spicula11259291spicula
spiculae12218601spiculae
spicules12219801spicules
spinule9299991spinule
apiculi1145112apiculi
epicure1136822epicure
pickle144215652_pickle
picul95015362_picul_
piculs103511752_piculs
pilule8411122_pilule
saccule1136742saccule
sickle124418322s_ickle
spackle15369572spackle
speckle15297552speckle
specula11187412specula
spicae104313702spic_ae
spicate113214192spicate
spice95528812spic__e
spicily1438652spicily
spicular12238902spicular
spiculate132210162spiculate
spiculum1464212spiculum
spile75230082spi__le
spindle103210092spindle
spinula9257902spinula
spinulae10276962spinulae
spinules10249332spinules
spirula9257702spirula
spirulae10216572spirulae
spittle937922spittle
sporule937272sporule
stickle132410972stickle
stipule936722stipule
acicula11228133acicula
aciculae12267703aciculae
apical10913903apical_
apicals1159923apicals
apiculate13279883apiculate
apiculus1245413apiculus
bascule1136573bascule
brickle15279933brickle
bricole112810493bricole
chicle134312543chic_le
cicale10314503_cicale
epical10413393epical_
epicene1148593epicene
epicures1246513epicures
epicycle1743393epicycle
epistle957893epistle
espiegle1142603espiegle
fascicule1643063fascicule
fickle153912973_fickle
icicle1036583icic_le
ligule74010833_ligule
locule83412033_locule
lodicule1143263lodicule
macule104115273_macule
mickle143715133_mickle
nickle123814483_nickle
opercule1245283opercule
opuscule1242823opuscule
oscule838193_oscule
ossicle944483ossic_le
papule102212133_papule
pical95524373_pical_
pice84641093_pic__e
pickled164011883_pickled
pickles153215443_pickles
picture1158613_picture
piddle103514913_piddle
piffle14418233_piffle
pile65649693_pi__le
pilules9510623_pilules
pimple123512963_pimple
pinnule936003_pinnule
pinole83218783_pinole
pintle83818263_pintle
pique16410173_piqu_e
pizzle16279493_pizzle
prickle153611013prickle
pule65040953_p__ule
reticule1049303reticule
ridicule1144393ridicule
saccules1237033saccules
sacculi1145043sacculi
saice75424053saic__e
sanicle91210263sanic_le
scale74629143s__cale
sculk115112463s__culk
scull75315763s__cull
sculp95314843s__culp
scute75520943s__cute
secure8513533s_ecure
seiche11811833seic_he
seisure738193seisure
seizure1634683seizure
shackle16409543shackle
shingle117711283shingle
sice65545593s_ic__e
sickee124622223s_ickee
sickie123715743s_ickie
sickled144713433s_ickled
sickles133417543s_ickles
sickly153110483s_ickly
sidle65124033s_i_dle
silicle937753silic_le
silicula1065393silicula
siliculae1154283siliculae
simile83115633s_imile
simple104315173s_imple
single74520603s_ingle
sizzle14309613s_izzle
skiable1338883skiable
skiffle17225203skiffle
skittle1135533skittle
slice74925823slic__e
slickly1635853slickly
smile74823923smi__le
sniffle13287653sniffle
sniggle9316833sniggle
socle7419573s_oc_le
soilure736233soilure
space95325673spac__e
spackled17297803spackled
spackles16319953spackles
spale74929213sp__ale
spangle1038403spangle
spansule1043623spansule
sparkle133710213sparkle
spatula935893spatula
spatzle1834583spatzle
specie10412223spec_ie
speckled17255833speckled
speckles16268133speckles
spectre11297773spectre
specular12217613specular
speculate13239193speculate
speculum1474193speculum
spherule1343843spherule
spic85227433spic___
spica94717943spic__a
spicas104715823spic_as
spicated13309903spicated
spiced115218313spic_ed
spiceless1335923spiceless
spicer104719313spic_er
spicers113815553spicers
spicery14499013spicery
spices104326033spic_es
spicey134414233spic_ey
spicier115112463spicier
spicing123914533spicing
spick134519073spic__k
spicks144814993spic_ks
spics94123243spic__s
spicy125417713spic__y
spiegel1034553spiegel
spiel74623913spi_el_
spieled104811883spi_eled
spieler93111233spi_eler
spiels85317953spi_els
spike114922843spi__ke
spikelet1446533spikelet
spikily1635873spikily
spiled94621993spi__led
spiles84227913spi__les
spill74821163spi__ll
spilled103613623spi_lled
spiller92914333spi_ller
spills84717463spi_lls
spilt75532223spi__lt
spinage10289653spinage
spinal84915313spinal_
spinals93911863spinals
spinate93114813spinate
spindled12287643spindled
spindler11297983spindler
spindles112710353spindles
spindly13257383spindly
spine76534423spi__ne
spinel85317333spinel_
spinelle1046223spinelle
spinels94512443spinels
spinose937943spinose
spinulose1142913spinulose
spiracle1255803spiracle
spiral83715343spiral_
spiraled1137733spiraled
spirals93212513spirals
spire75828693spi__re
spireme11478363spireme
spirulas10207203spirulas
spital83813873spital_
spitals93011593spitals
spite75430663spi__te
spittles1038333spittles
splice104915103splic__e
sporules1037703sporules
spouse84112513sp_ouse
sprinkle1434893sprinkle
spruce103910873sp_ruce
sprue74717633sp_ru_e
spue66025523sp__u_e
spume95817313sp__ume
spurtle937453spurtle
stickled15298973stickled
stickler14259573stickler
stickles142512103stickles
stifle93611903sti_fle
stile54931573sti__le
stimuli944513stimuli
stipple1146623stipple
stipuled1134453stipuled
stipules1037053stipules
strickle1467793strickle
subcult1149603subcult
subrule939643subrule
suckle124015963s_uckle
suicide1038893suicide
swindle11389183swindle
swingle113510563swingle
swiple11379233swi_ple
swipple1444633swipple
swizzle1854103swizzle
tickle124616743_tickle
trickle133613443trickle
upscale11136323upscale
veinule1056243veinule

Search took 7 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.403443402.0
2DLD Change Limit1340272296.14321817.8
3Display Results2292290.0932462.4
 (SQL Overall)1786912296.63926915.3
 
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.