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

335 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
sparkier1429803(None) 
sarkier113413311s_arkier
snarkier12336511snarkier
sparker133914361spark_er
sparkler14317981sparkler
sparklier1554361sparklier
sparrier10329141sparrier
barkier133814482_barkier
larkier113711522_larkier
parker124121372_park_er
parrier93717652_parrier
partier93520712_partier
pawkier16236612_pawkier
perkier133813122_perkier
porkier133712342_porkier
scarier94017872scar_ier
scarrier10298452scarrier
shakier143411152sha_kier
sharker144313812shark_er
skankier11184882skankier
smarmier1235032smarmier
smirkier1444432smirkier
snakier112810002sna_kier
snarlier8278182snarlier
spacier114011632spa_cier
spanker133612352spank_er
sparer84524962spar__er
sparger103613082spar_ger
sparked143513142spark_ed
sparkers144111312spark_ers
sparkiest15188092sparkiest
sparkily1735022sparkily
sparking152812542sparking
sparkish17276972sparkish
sparkle133710212sparkle_
sparkled15317732sparkled
sparklers15315642sparklers
sparkles143210492sparkles
sparklet143110592sparklet
sparser94311482spar_ser
spikier13369982sp_ikier
spirier93214072spir_ier
spookier14175492spookier
sportier102010052sportier
sprier84119062sp_r_ier
spunkier14235812spunkier
spurrier10297692spurrier
stalkier1257072stalkier
starker114114692stark_er
starrier8279462starrier
swankier15225502swankier
artier63419733__artier
asparkle1443843asparkle_
balkier134111983_balkier
barker124822863_bark_er
barmier114313043_barmier
barnier93213673_barnier
barrier94017733_barrier
beakier134012163bea_kier
brakier133812363bra_kier
cakier123115243_ca_kier
carrier93619583_carrier
chalkier1736753chalkier
charier124317903char_ier
charrier1378683charrier
clankier14327083clankier
corkier133114303_corkier
crankier14339163crankier
darker114718693_dark_er
darkie113714013_darkie_
darkies124015753_darkies
darklier1335013_darklier
dorkier122810023_dorkier
earlier72612743_earlier
espalier1036363espa_lier
farrier103514893_farrier
flakier143910203fla_kier
forkier144311593_forkier
gawkier15326523_gawkier
glarier84112203glar_ier
gnarlier9255163gnarlier
hardier114721543_hardier
harrier104417753_harrier
heartier1139093heartier
hoarier104211743hoar_ier
jerkier18407273_jerkier
lakier104716273_la_kier
lankier113711633_lankier
lardier83518343_lardier
larker104519243_lark_er
leakier114010993lea_kier
learier73415663lear_ier
marker124420393_mark_er
marlier92614773_marlier
marrier93817523_marrier
mirkier13319053_mirkier
murkier133110273_murkier
nearlier836793nearlier
oakier104011393_oa_kier
pacier105018683_pa_cier
packer144223403_pack_er
palier85023563_pa_lier
pallier94417163_pallier
palmier113312173_palmier
panier84425503_pa_nier
pannier93613353_pannier
pappier103511593_pappier
parader103914863_parader
pardie96021443_pardie_
pardner10239473_pardner
parer75839903_par__er
paries84742513_par_ies
parked134425143_park_ed
parkers133816873_park_ers
parking143423043_parking
parried103615723_parried
parriers103612903_parriers
parries93925843_parries
parser84822373_par_ser
partied103516553_partied
partiers103514243_partiers
parties93230863_parties
partner92811393_partner
partyer12337873_partyer
pastier94320383_pastier
peakier134411443_peakier
pearlier1037323pearlier
peckier153910523_peckier
peskier13319113_peskier
pickier153912973_pickier
pockier153911603_pockier
pokier124914633_p_okier
porker124917543_pork_er
porkies133416493_porkies
pornier93413133_pornier
prier75027763_p_r_ier
punkier133512793_punkier
pursier94012753_pursier
purtier93214093_purtier
quackier23215373quackier
quakier20239203qua_kier
quarrier1736843quarrier
quartier1737543quartier
quirkier2134163quirkier
sacker125124843s_ack_er
saggier92912063s_aggier
sagier73717163s_a_gier
saker95132023s_a_k_er
sallier73320423s_allier
saltier74318633s_altier
sandier84017843s_andier
sappier113613113s_appier
sarkiest123615063s_arkiest
sassier73413233s_assier
saucier9810283s_aucier
savvier1335483s_avvier
scabbier1435133scabbier
scalier94316913sca_lier
scantier10309983scantier
scarcer113911373scar_cer
scareder1135783scareder
scarer84524603scar__er
scarfer124511083scar_fer
scarifier1446653scarifier
scarper114814823scar_per
scattier10267583scattier
scurfier13267053scurfier
scurvier13255883scurvier
seamier93114633sea_mier
searcher13209103searcher
searer65432023sear__er
shabbier1535183shabbier
shackler17317973shackler
shadier113111153sha_dier
shaggier13116053shaggier
shaker134319463sha_k_er
shalier103116423sha_lier
sharer95025483shar__er
sharked153613913shark_ed
sharkers154011053shark_ers
sharking163912973sharking
sharper124312703shar_per
sharpie1238393sharpie_
sharpies13411223sharpies
shirker143711343shirk_er
shirtier1137943shirtier
silkier114411643s_ilkier
skanker10268483skank_er
skier95119593s___kier
skunkier11174283skunkier
slacker133915293slack_er
slaggier10126953slaggier
slaker104219273sla_k_er
slangier9117933slangier
slatier74016813sla_tier
sleekier1245573sleekier
slinkier12206933slinkier
smacker153410583smack_er
smarter94113133smar_ter
smartie9310173smartie_
smarties10312873smarties
smearier1036953smear_ier
smirker13327423smirk_er
smokier1356703s_mokier
snacker133112603snack_er
snaggier10136303snaggier
snappier1266213snappier
snarer64620843snar__er
snarkiest13207633snarkiest
snarkily1534583snarkily
snarler73610633snar_ler
snazzier1642483snazzier
sneakier1245143sneakier
soaker105717533soa_k_er
soapier93411713soa_pier
soarer64522243soar__er
sorrier72313733s_orrier
spacer104917793spa__cer
spackle15369573spackle_
spackled17297803spackled
spackles16319953spackles
spader94317133spa__der
spake114322743spa_k_e_
spaller92713473spa_ller
spammer133410433spa_mmer
spanglier1244193spanglier
spaniel948923spa_niel
spanked143111733spank_ed
spankers14369863spank_ers
spanking153911973spanking
spanner94312563spa_nner
spare75135563spar__e_
spared95427493spar__ed
sparers94519613spar__ers
spares84834553spar__es
sparge94216053spar_ge_
sparged113512763spar_ged
spargers11389733spar_gers
sparges104016343spar_ges
sparging122611133sparging
sparid94016933spar_i_d
sparids103512123spar_ids
sparing104823873spar_ing
spark114920893spark___
sparklets15275843sparklets
sparkliest1644573sparkliest
sparkling16226353sparkling
sparkly16348133spark_ly
sparks124616363spark__s
sparky154511523spark__y
sparlike1437673sparlike
sparling112714533sparling
sparoid102311543sparoi_d
sparoids11218713sparoids
sparred104512863spar_red
sparriest11198783sparriest
sparring113112223sparring
sparse84516343spar_se_
sparsity1345463sparsity
spartina1037983spartina
spatter94016523spa_tter
spavie113611383spa_vie_
spavies123012943spa_vies
spaviet123011923spa_viet
spawner12347363spa_wner
speaker133311213speak_er
spearer93913663spear__er
speedier1146623speedier
spendier1147143spendier
spherier1337783spherier
spicier115112463sp_icier
spier75728033sp___ier
spiffier16255883spiffier
spiker124315663sp_ik_er
spinier93715163sp_inier
splashier1443593splashier
splurgier1252343splurgier
spongier1135733spongier
spoonier10167653spoonier
sporter93616553spor_ter
spottier10207313spottier
sprawler1334643sprawler
sprawlier1443293sprawlier
sprayer12369043sp_rayer
sprucer11317683sp_rucer
sprucier1254793sprucier
spryer11418533sp_r_yer
spumier1137903sp_umier
spunkie13215293spunkie_
spunkies14227583spunkies
spurner9269653spur_ner
spurrer93710223spur_rer
spurriers11245063spurriers
spurries102311323spurries
spurter94013003spur_ter
stacker134416263stack_er
staggier10167513staggier
stagier83513443sta_gier
stalker113912253stalk_er
starchier1436643starchier
starer64027363star__er
starkers123712393stark_ers
starter73817883star_ter
startler8248793startler
starver104611993star_ver
stickier14229763stickier
stinkier12278543stinkier
stockier14217253stockier
stormier1036103stormier
strawier1137483strawier
striker113714173s_triker
sturdier9216963sturdier
suckier133613973s_uckier
sugarier937393sugar_ier
sulkier113811963s_ulkier
surfier102613543s_urfier
surlier72915443s_urlier
swampier1544593swampier
swanker14369483swank_er
swarmer1247803swar_mer
swarthier1543783swarthier
swirlier1135213swirlier
tackier133712523_tackier
talkier114011843_talkier
tardier859719993_tardier
tarrier74323173_tarrier
tarsier74119253_tarsier
tartier74123263_tartier
tearier73815613tear_ier
varier94619353_var_ier
wackier16369733_wackier
warier93722893_war_ier
wartier103413913_wartier
wearier103613283wear_ier
whackier2044673whackier

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.1731032896.0
2DLD Change Limit1461623357.48319532.5
3Display Results3353350.1232723.6
 (SQL Overall)1786913357.77922970.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.