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

233 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
sparkler1431798(None) 
sparker133914361spark_er
sparkier14298031sparkier
sparkle133710211sparkle_
sparkled15317731sparkled
sparklers15315641sparklers
sparkles143210491sparkles
sparklet143110591sparklet
sparklier1554361sparklier
asparkle1443842asparkle_
parker124121372_park_er
sarkier113413312s_arkier
shackler17317972shackler
sharker144313812shark_er
snarkier12336512snarkier
snarler73610632snar_ler
spackle15369572spackle_
spackled17297802spackled
spackles16319952spackles
spaller92713472spa_ller
spanker133612352spank_er
sparer84524962spar__er
sparger103613082spar_ger
sparked143513142spark_ed
sparkers144111312spark_ers
sparklets15275842sparklets
sparkly16348132sparkl_y
sparrier10329142sparrier
sparser94311482spar_ser
sprawler1334642sprawler
starker114114692stark_er
startler8248792startler
barker124822863_bark_er
barkier133814483_barkier
cackler153812573_cackler
caroler93816753_caroler
darker114718693_dark_er
darkle113813943_darkle_
darkled13378723_darkled
darkles124011933_darkles
darklier1335013_darklier
garbler104012563_garbler
gargler93710263_gargler
hackler163512353_hackler
larker104519243_lark_er
larkier113711523_larkier
marbler113511673_marbler
marker124420393_mark_er
packer144223403_pack_er
paddler113711553_paddler
paler75436933_pa__ler
parader103914863_parader
pardner10239473_pardner
parer75839903_par__er
parked134425143_park_ed
parkers133816873_park_ers
parle75836163_par_le_
parled94626283_par_led
parles86334403_par_les
parley116718353_par_ley
parlor8312673_par_lor
parole84425253_parole_
paroled104217623_paroled
parolee94119633_parolee
paroles95025883_paroles
parrier93717653_parrier
parser84822373_par_ser
parsley1247793_parsley
partier93520713_partier
partlet92720363_partlet
partner92811393_partner
partyer12337873_partyer
pawkier16236613_pawkier
pearler9310373pear_ler
perkier133813123_perkier
porker124917543_pork_er
porkier133712343_porkier
purfler12248733_purfler
purpler11289263_purpler
sacker125124843s_ack_er
saddler93811963s_addler
sailer63526103s_a_iler
saker95132023s_a_k_er
sampler113212013s_ampler
scaler84321603sca__ler
scarcer113911373scar_cer
scareder1135783scareder
scarer84524603scar__er
scarfer124511083scar_fer
scarier94017873scar_ier
scarlet91516943scar_let
scarper114814823scar_per
scarrier10298453scarrier
scrawler1345883scrawler
sealer63928963sea__ler
searcher13209103searcher
searer65432023sear__er
shackle16409543shackle_
shackled18277603shackled
shacklers18336033shacklers
shackles173010593shackles
shaker134319463sha_k_er
shakier143411153sha_kier
sharer95025483shar__er
sharked153613913shark_ed
sharkers154011053shark_ers
sharper124312703shar_per
shirker143711343shirk_er
skanker10268483skank_er
skankier11184883skankier
slacker133915293slack_er
slaker104219273sla_k_er
smacker153410583smack_er
smaller93410333sma_ller
smarmier1235033smarmier
smarter94113133smar_ter
smirker13327423smirk_er
smirkier1444433smirkier
snacker133112603snack_er
snakier112810003sna_kier
snarer64620843snar__er
snarled83612363snar_led
snarlers8298753snar_lers
snarlier8278183snarlier
snorkeler1342663snorkeler
soaker105717533soa_k_er
soarer64522243soar__er
spacer104917793spa__cer
spacier114011633spa_cier
spader94317133spa__der
spake114322743spa_k_e_
spale74929213spa__le_
spales84728103spa__les
spalled103113133spa_lled
spallers102910733spa_llers
spammer133410433spa_mmer
spangle1038403spangle_
spangled1236153spangled
spangles1138893spangles
spanglier1244193spanglier
spanked143111733spank_ed
spankers14369863spank_ers
spanner94312563spa_nner
sparable121611983sparable_
sparables13167163sparables
spare75135563spar__e_
spared95427493spar__ed
sparely123410673sparel_y
sparers94519613spar__ers
spares84834553spar__es
sparge94216053spar_ge_
sparged113512763spar_ged
spargers11389733spar_gers
sparges104016343spar_ges
spark114920893spark___
sparkiest15188093sparkiest
sparkily1735023sparkily
sparking152812543sparking
sparkish17276973sparkish
sparkliest1644573sparkliest
sparkling16226353sparkling
sparkplug1881203sparkplug
sparks124616363spark__s
sparky154511523spark__y
sparred104512863spar_red
sparse84516343spar_se_
sparsely1335123sparsely
spatter94016523spa_tter
spatular1044653spatular
spatzle1834583spatzle_
spatzles1935303spatzles
spawner12347363spa_wner
speaker133311213speak_er
spearer93913663spear__er
speckle15297553speckle_
speckled17255833speckled
speckles16268133speckles
speller95415143sp_eller
spieler93111233sp_ieler
spiker124315663sp_ik_er
spikier13369983sp_ikier
spiller92914333sp_iller
spindler11297983spindler
spiraled1137733spiraled
spirier93214073spir_ier
spoiler93310683sp_oiler
spookier14175493spookier
spooler93711383sp_ooler
sporter93616553spor_ter
sportier102010053sportier
sporular1065223sporular
sporule937273sporule_
sporules1037703sporules
sprawled1434523sprawled
sprawlers1433893sprawlers
sprawlier1443293sprawlier
sprayer12369043sp_rayer
sprier84119063sp_r_ier
sprinkler1543573sprinkler
sprucer11317683sp_rucer
spryer11418533sp_r_yer
spunkier14235813spunkier
spurner9269653spur_ner
spurrer93710223spur_rer
spurrier10297693spurrier
spurter94013003spur_ter
spurtle937453spurtle_
spurtles1037783spurtles
stabler94014933sta_bler
stacker134416263stack_er
staler64025823sta__ler
stalker113912253stalk_er
stalkier1257073stalkier
stapler93913633sta_pler
starer64027363star__er
starkers123712393stark_ers
starkly14277033starkl_y
starlet71620123star_let
starrier8279463starrier
starter73817883star_ter
startle72511123startle_
startled9208563startled
startlers9236743startlers
startles82111963startles
starver104611993star_ver
stickler14259573stickler
suckler133413093s_uckler
swanker14369483swank_er
swankier15225503swankier
swarmer1247803swar_mer
tackler134013323_tackler
warbler123211463_warbler
warsler10289893_warsler

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 Filter1786911461620.203880251.2
2DLD Change Limit1461622337.11020557.2
3Display Results2332330.0932505.4
 (SQL Overall)1786912337.40624127.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.