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

220 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
sparkling1622635(None) 
spackling18266501spackling
sparking152812541spark_ing
sparling112714531spar_ling
darkling1437482_darkling
parking143423042_park_ing
parling103823762_par_ling
paroling113316212_paroling
shackling19286172shackling
sharking163912972shark_ing
snarling92513182snar_ling
spalling113213462spa_lling
spangling1336372spangling
spanking153911972spank_ing
sparging122611132spar_ging
sparing104823872spar__ing
sparklier1554362sparklier
sparlings12257152spar_lings
sparring113112222spar_ring
speckling18235582speckling
spiraling1237952spiraling
sprawling15175122sprawling
starling93017122star_ling
startling1037372startling
ankling122912063__ankling
appareling1543423appareling
argling92812733__argling
barking144724183_bark_ing
cackling172610943_cackling
carking144322853_cark_ing
carling103727063_car_ling
caroling113317003_caroling
charking183512613chark_ing
crackling18157003crackling
crankling16147293crankling
darking134217343_dark_ing
darklings1533983_darklings
darling93418363_dar_ling
dartling1039563_dartling
garbling12249453_garbling
gargling11239203_gargling
gnarling10217603gnar_ling
hackling183310163_hackling
harking154120943_hark_ing
imparking1834713impark_ing
larking123718253_lark_ing
mackling172710063_mackling
marbling13179883_marbling
marking144020133_mark_ing
marling103322763_mar_ling
narking124015383_nark_ing
outsparkling1951653outsparkling
packing164420723_pack_ing
paddling13218643_paddling
paiking143814813_paik_ing
paling93530133_pa__ling
palling104024483_pa_lling
paneling111013623_paneling
parading12313863_parading
parawing14310583_parawing
parceling1438443_parceling
parching164313053_parching
parging113318603_par_ging
paring94236493_par__ing
parkings153610683_park_ings
parkland1545373_parkland
parklike1337493_parklike
parring103222063_par_ring
parrying14168133_parrying
parsing103819553_par_sing
parting103527383_par_ting
partying14168893_partying
pearling11912013pear_ling
periling11316863_periling
perking143716463_perk_ing
pickling17239203_pickling
porking143515813_pork_ing
purfling1467763_purfling
purling103620293_pur_ling
purpling1368543_purpling
rankling132610113_rankling
reparking1638923repark_ing
sacking144122703s_ack_ing
saddling11239593s_addling
sailing83927373s_a_iling
sampling13510643s_ampling
sandling102214413s_andling
sapling103217863s_a_pling
scabbling1634863scabbling
scaling103519373sca__ling
scantling12107233scantling
scarfing14309713scar_fing
scaring103421973scar__ing
scarphing1735243scarphing
scarping133312463scar_ping
scarring112511513scar_ring
scarting113415263scar_ting
scrawling15195583scrawling
sealing83528563sea__ling
searching1538343searching
searing83330923sear__ing
separating1348643separating
shacking184014083shack_ing
shaking153317253sha_k_ing
shambling1735593shambling
shanking163612283shank_ing
sharing113723243shar__ing
sharklike1543933sharklike
sharping143011373shar_ping
shauling1249393sha_uling
shaveling1646843shaveling
shawling1558223sha_wling
shearling1336923shear_ling
shirking163210473shirk_ing
sickling152910333s_ickling
skanking12288743skank_ing
skirling13249063skir_ling
slacking153914133slack_ing
slaking123717473sla_k_ing
smacking173510763smack_ing
smarting113212453smar_ting
smerking15258473smerk_ing
smirking15277233smirk_ing
snacking153411703snack_ing
snaffling1643763snaffling
snailing92912973sna_iling
snaking123915303sna_k_ing
snarfing12358663snar_fing
snaring83920953snar__ing
snorkeling1542973snorkeling
soaking123116613soa_k_ing
soaring83521893soar__ing
spacing123614493spa__cing
spading113114383spa__ding
spaeing103413543spa__eing
spamming15317603spa_mming
spanceling1543943spanceling
spankings16215003spank_ings
spanning113311083spa_nning
sparkier14298033spark_ier
sparkily1735023spark_ily
sparkish17276973spark_ish
sparkle133710213sparkl__e
sparkled15317733sparkl_ed
sparkler14317983sparkl_er
sparklers15315643sparklers
sparkles143210493sparkl_es
sparklet143110593sparkl_et
sparklets15275843sparklets
sparkliest1644573sparkliest
sparkly16348133sparkl__y
sparkplug1881203sparkplug
sparlike1437673spar_like
sparteine1185483sparteine
spartina1037983spar_tina
spasming13227203spa_sming
spatting113111763spa_tting
spawning14296913spa_wning
spaying133014623spa__ying
speaking153212493speak_ing
spearing113216103spear__ing
specking17359733speck_ing
speeling112713123sp_eeling
speiling113612973sp_eiling
spelling113315233sp_elling
spieling113212523sp_ieling
spiking144312883sp_ik_ing
spiling102919703sp__iling
spilling113113943sp_illing
spindling13136273spindling
spiralling1343963spiralling
spiring103918183spir__ing
spiriting1238413spiriting
spirting112913633spir_ting
spirulina1143423spirulina
spoiling112911553sp_oiling
spoking143212223sp_ok_ing
spooking15269803spook_ing
spooling113212563sp_ooling
sporing104319413spor__ing
sporting112415463spor_ting
spraddling1542313spraddling
spraining1248153spraining
sprattling1363053sprattling
spraying14299883sp_raying
spring94526013sp_r__ing
sprinkling1743823sprinkling
sprucing1336893sp_rucing
spunking15258063spunk_ing
spurning11258663spur_ning
spurring11339763spur_ring
spurting113111633spur_ting
stabling112913653sta_bling
stacking154215083stack_ing
staking123919803sta_k_ing
staling83925423sta__ling
stalking133512223stalk_ing
stalling95116703sta_lling
stapling112813153sta_pling
starching1538593starching
staring84527053star__ing
starlings10237923star_lings
starring92312953star_ring
starting93116173star_ting
starveling1444263starveling
starving122510173star_ving
sterling93615553ster_ling
stickling1647003stickling
suckling152410023s_uckling
swaddling1543813swaddling
swanking16399963swank_ing
swarding1359003swar_ding
swarming1458223swar_ming
swirling12249143swir_ling
tackling153211123_tackling
warbling14198943_warbling
warking153519573_wark_ing
warsling12198593_warsling
weakling16106763wea_kling
yearling1297883year_ling

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 Filter1786911486410.423422437.4
2DLD Change Limit1486412207.54619698.0
3Display Results2202200.0932365.6
 (SQL Overall)1786912208.06222164.6
 
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.