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

282 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
sparkle13371021(None) 
asparkle1443841asparkle
spackle15369571spackle
sparkled15317731sparkled
sparkler14317981sparkler
sparkles143210491sparkles
sparklet143110591sparklet
sparkly16348131sparkly
darkle113813942_darkle
parle75836162_par_le
parole84425252_parole
shackle16409542shackle
spackled17297802spackled
spackles16319952spackles
spake114322742spa_k_e
spale74929212spa__le
spangle1038402spangle
sparable121611982sparable
spare75135562spar__e
sparely123410672sparely
sparge94216052spar_ge
spark114920892spark__
sparked143513142sparked
sparker133914362sparker
sparkier14298032sparkier
sparkily1735022sparkily
sparklers15315642sparklers
sparklets15275842sparklets
sparklier1554362sparklier
sparks124616362spark_s
sparky154511522spark_y
sparse84516342spar_se
spatzle1834582spatzle
speckle15297552speckle
sporule937272sporule
spurtle937452spurtle
starkly14277032starkly
startle72511122startle
ankle95220253__ankle
argle65421563__argle
cackle143416923_cackle
carle74535703_car_le
crackle153611253crackle
crankle133610063crankle
darkie113714013_darkie
darkled13378723_darkled
darkles124011933_darkles
darkly145411073_darkly
dartle73714833_dartle
escarole1045743escarole
farle86929243_far_le
garble94118453_garble
gargle84215463_gargle
grackle14338893grackle
hackle154916813_hackle
mackle143716433_mackle
marble104219103_marble
outsparkle1691853outsparkle
packly17228333_packly
paddle104615143_paddle
padle84522343_pa_dle
pale66055013_pa__le
papule102212133_papule
parable111819773_parable
parade94720643_parade
parae76335703_par_ae
parcel103915473_parcel
pardee93922023_pardee
pardie96021443_pardie
pare66760843_par__e
pareve114613013_pareve
parge85831853_par_ge
park105237493_park__
parka115120883_park_a
parkade1437583_parkade
parkas125018023_parkas
parked134425143_parked
parker124121373_parker
parklike1337493_parklike
parks116134463_park_s
parled94626293_par_led
parles86334403_par_les
parley116718363_par_ley
parol74826273_parol_
paroled104217633_paroled
parolee94119643_parolee
paroles95025883_paroles
parols84722613_parols
parrel84515983_parrel
parse75236993_par_se
parsley1247803_parsley
partlet92720363_partlet
partly116315473_partly
parure8312523_parure
parve109824853_par_ve
pickle144215653_pickle
prole74527793_p_role
purfle112511183_purfle
purple102712683_purple
rackle123917293_rackle
rankle103414883_rankle
sable74732163s_a_ble
saddle83915493s_addle
safrole1037253safrole
sake85244963s_a_k_e
sale44959703s_a__le
sample104215013s_ample
saprobe1137333saprobe
sarape84817573s_arape
saree55044663s_ar_ee
sarge65531133s_ar_ge
sark84938973s_ark__
sarkier113413313s_arkier
sarks96632463s_ark_s
sarky125521783s_ark_y
sarode75317513s_arode
scabble13168653scabble
scale74629143sca__le
scarce104013633scar_ce
scare75334463scar__e
scarily12311703scarily
scarlet91516943scar_let
separable1348673separable
separate10310783separate
shackled18277603shackled
shackler17317973shackler
shackles173010593shackles
shake124726403sha_k_e
shale85332833sha__le
shamble14149263shamble
sharable131910693sharable
share86437083shar__e
shark126225023shark__
sharked153613913sharked
sharker144313813sharker
sharklike1543933sharklike
sharks135019723shark_s
sharpie1238393sharpie
sharply15406833sharply
sickle124418323s_ickle
skatole1135693skatole
slackly1635263slackly
slake93724053sla_k_e
smartie9310173smartie
smartly12497433smartly
snaffle13216253snaffle
snake94821113sna_k_e
snare54429983snar__e
snark95419943snark__
snarkier12336513snarkier
snarkily1534583snarkily
snarks104815733snark_s
snarky134210843snark_y
snarl54921083snar_l_
snarled83612363snar_led
snarler73610633snar_ler
snarls64016873snar_ls
snarly93815003snar_ly
snorkel1135423snorkel
space95325673spa__ce
spade84423323spa__de
spadille1145193spadille
spae65034323spa___e
spaetzle1942243spaetzle
spahee11313443spa_hee
spail74921553spa_il_
spails84817823spa_ils
spales84728103spa__les
spall74919303spa__ll
spalled103113133spa_lled
spaller92713473spa_ller
spalls84217343spa_lls
spancel1147363spancel
spangled1236153spangled
spangles1138893spangles
spangly1336473spangly
spaniel948923spaniel
spank115919573spank__
spanked143111733spanked
spanker133612353spanker
spanks124514123spank_s
spansule1043623spansule
spar65433303spar___
sparables13167163sparables
spareable1337263spareable
spared95427493spar_ed
sparer84524963spar_er
sparers94519613sparers
spares84834553spar_es
sparest94616423sparest
sparged113512763sparged
sparger103613083sparger
sparges104016343sparges
sparid94016933spar_id
sparids103512123sparids
sparing104823873sparing
sparkers144111313sparkers
sparkiest15188093sparkiest
sparking152812543sparking
sparkish17276973sparkish
sparkliest1644573sparkliest
sparkling16226353sparkling
sparkplug1881203sparkplug
sparlike1437673sparlike
sparoid102311543sparoid
sparred104512863sparred
sparrier10329143sparrier
sparrow1234263sparrow
sparry115111303spar_ry
spars75431543spar__s
sparsely1335123sparsely
sparser94311483sparser
spartan948333spartan
spate74731583spa__te
spathe115115693spa_the
spatula935893spatula
spatzles1935303spatzles
spavie113611383spa_vie
speckled17255833speckled
speckles16268133speckles
spherule1343843spherule
spicule11269933spicule
spike114922843sp_ik_e
spile75230083sp__ile
spindle103210093spindle
spinule9299993spinule
spiracle1255803spiracle
spiral83715343spiral_
spiraled1137733spiraled
spirals93212513spirals
spire75828693spir__e
spireme11478363spireme
spirula9257703spirula
spirulae10216573spirulae
spittle937923spittle
splake1259783splak_e
spoke114818663sp_ok_e
sporal82915453sporal_
spore75428593spor__e
sporules1037703sporules
spraddle12194163spraddle
sprattle1054763sprattle
sprawl11188063sprawl_
sprawled1434523sprawled
sprawler1334653sprawler
sprawls12176373sprawls
sprawly15166043sprawly
spree74830863sp_r_ee
sprinkle1434893sprinkle
sprite84421773sp_rite
spruce103910873sp_ruce
sprue74717633sp_r_ue
spryly1435513sp_ryly
spunkie13215303spunkie
spurge93711323spur_ge
spurtles1037783spurtles
stabile9312063stabile
stable83921643sta_ble
staddle9288093staddle
stake95927533sta_k_e
stale55637103sta__le
staple84415823sta_ple
stare54440263star__e
stark95425623stark__
starker114114693starker
starlet71620123star_let
startled9208563startled
startler8248793startler
startles82111963startles
starve94613743star_ve
sterile7316603sterile
stickle132410973stickle
strake104017393strak_e
suable83920553sua_ble
subrule939643subrule
suckle124015963s_uckle
swaddle12276743swaddle
swale85221593swa__le
sware85828213swar__e
tackle123815733_tackle
warble113516603_warble
warsle93112923_warsle

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.406440125.6
2DLD Change Limit1340272826.12621878.4
3Display Results2822820.1062660.4
 (SQL Overall)1786912826.63826919.4
 
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.