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

313 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
sharpies1341123(None) 
harpies123818321_harpies
sharpie1238401sharpie_
chappies172610102chappies
charlies133414232charlies
gharries12318222gharries
hardies114923232_hardies
harpins123615702_harpins
harries103525502_harries
scampies1439332scampies
scrapies124612492scrapies
shammies15259692shammies
shandies122714112shandies
shannies113411262shannies
shanties113116592shanties
shapes115124952sha_p_es
shares95236412shar__es
sharias102516002shar_ias
sharifs13279902shar_ifs
sharped134112052sharp_ed
sharpen12389722sharp_en
sharpens13377812sharpens
sharper124312702sharp_er
sharpers133810942sharpers
sharpest1339152sharp_est
sharping143011372sharping
sharpness1434942sharpness
sharps115516082sharp__s
shavies134213212sha_vies
sherries111812902sherries
shorties11414582shorties
smarties10312872smarties
armies85123693__armies
barbies114519593_barbies
caries85147623_car_ies
carnies94123963_carnies
carries94328013_carries
challies133915643challies
chammies172910163chammies
chanties132615803chanties
chapes135421873cha_p_es
chappie16298663chappie_
charades141310853charades
charases131312763charases
chares115631803char__es
charges134615983char_ges
charier124317903char_ier
chariest13315513char_iest
charities14312743charities
charlie123011923charlie_
charpais1536933charpais
charpoys1834533charpoys
charrier1378693charrier
charriest1438263charriest
cheapies1539033cheapies
cherries131812993cherries
chippies17309763chippies
chirpier15276303chirpier
chirpiest16286483chirpiest
claries93422203clar_ies
crappies142911173crappies
darbies104216983_darbies
darkies124015753_darkies
dearies83526273dear_ies
dhurries1255583dhurries
diaries83321953diar_ies
farcies125317883_farcies
garpikes1534373_garpikes
gharris11306433gharri_s
ghazies2036913gha_zies
hackies163418243_hackies
hairpins1365433_hairpins
hankies143617763_hankies
happier143312043_happier
happiest152411683_happiest
hardier114721543_hardier
hardiest123416343_hardiest
hares86255543_har__es
harmines132715143_harmines
harmins123716723_harmins
harped124418403_harp_ed
harper115018403_harp_er
harpers124916203_harpers
harpin113614383_harpi_n
harping134118383_harping
harpings14379773_harpings
harpist12312363_harpist
harpists1338103_harpists
harps105926873_harp__s
harried113815543_harried
harrier104417763_harrier
harriers113712433_harriers
hatpins123410643_hatpins
hawkies173311243_hawkies
hearties11315423hearties
herpes115517323_herp_es
herries104025083_herries
hippies142813753_hippies
hirples12149643_hirples
hurdies114015663_hurdies
hurlies103315333_hurlies
hurries103919653_hurries
magpies12310363_magpies
marries93825283_marries
nappies114613403_nappies
ovaries10312653ovar_ies
pappies103214833_pappies
paries84742513_par_ies
parries93925843_parries
parties93230863_parties
pharoses13310323pharoses
quarries1749943quarries
rhaphes1534703rha_phes
salaries8319593salar_ies
sallies73227813s_allies
salpids1038193s_alpids
salties73725773s_alties
samples112815453s_amples
sanies63031953s_a_nies
sapiens9310173s_a_piens
sappier113613123s_appier
sappiest122612583s_appiest
sarapes94617753s_arapes
sardines92815573s_ardines
sardius839553s_ardius
sarees65329943s_ar_ees
sarges75128593s_ar_ges
sarins63932623s_ar_ins
saris54544953s_ar_i_s
sarkier113413313s_arkier
sarkiest123615073s_arkiest
sarodes84216143s_arodes
saroses73619333s_aroses
sassies74719263s_assies
satrapies1147723satrapies
sauries72821623s_auries
savvies1337603s_avvies
scabies11613333sca_bies
scanties103215423scanties
scapes105122263sca_p_es
scares85033003scar__es
scarfpins1653043scarfpins
scarier94017873scar_ier
scariest101615953scar_iest
scarifies1439603scarifies
scarped124314403scarp_ed
scarper114814823scarp_er
scarpers124712513scarpers
scarphed1635443scarphed
scarphs14437413scarp_hs
scarping133312463scarping
scarps104718603scarp__s
scarrier10298453scarrier
scarriest11188403scarriest
scarves124511623scar_ves
schappes1736043scha_ppes
scrapes116217663scrap_es
scrapie115010953scrapie_
scries85226823s_cr_ies
scurries102911483scurries
scurvies13248123scurvies
searches132112903searches
serapes95218103serap_es
series64540973s_er_ies
serries73925353s_erries
shabbier1535183shabbier
shabbiest1635333shabbiest
shackles173010593shackles
shackoes17367853shackoes
shades105924533sha__des
shadflies1643833shadflies
shadier113111153sha_dier
shadiest121711283sha_diest
shaggier13116053shaggier
shaggiest14156903shaggiest
shakes135024593sha__kes
shakier143411153sha_kier
shakiest151910943sha_kiest
shakoes144510023sha_koes
shales94731253sha__les
shalier103116423sha_lier
shaliest111415063sha_liest
shambles15159043shambles
shames114726223sha__mes
shammes144312833sha_mmes
shammied16265543shammied
shamois123210423shamoi_s
shampoos1544603shampoos
shamuses1336153shamuses
shantihs14276213shantihs
shantis103313103shanti_s
shape105125113sha_p_e_
shaped125020103sha_p_ed
shapen114414653sha_p_en
shaper114119933sha_p_er
shapers124016893sha_pers
shaping133116183sha_ping
shards104319173shar__ds
share86437083shar__e_
shared105829063shar__ed
sharer95025483shar__er
sharers104720623shar_ers
sharia93116733shar_i_a
shariah132210533shar_iah
shariahs14206393shariahs
sharif122917123shar_i_f
sharing113723243shar_ing
sharked153613913shar_ked
sharker144313813shar_ker
sharkers154011053sharkers
sharking163912973sharking
sharks135019723shar__ks
sharns95516983shar__ns
sharp104922533sharp___
sharpened1544483sharpened
sharpener1444583sharpener
sharpeners1543893sharpeners
sharply15406833sharp_ly
sharpy145211033sharp__y
shasliks1544143shasliks
shaves125224933sha__ves
shavie124312423sha_vie_
sheenies111411543sheenies
shelties111111383shelties
sherifs13299683sher_ifs
sherpas1238093sherp_as
sherris10168803sherri_s
sherrises12156873sherrises
shies86136553sh___ies
shimmies15287803shimmies
shindies122610503shindies
shinnies113010923shinnies
shires95225573shir__es
shirtier1137943shirtier
shirtiest1239333shirtiest
shoddies1336053shoddies
shoppes143411403sh_oppes
shores94830413shor__es
shortias1148093shortias
shortie10411343shortie_
shrapnel1342133shrapnel
shriek134211103sh_r_iek
shrieks14377673sh_r_ieks
shrikes144412393sh_rikes
shrines104618693sh_rines
shris84221453sh_r_i_s
shrives134416173sh_rives
shunpikes1841903shunpikes
shvartzes2442103shvartzes
skerries12168673skerries
slurries82710413slurries
smarmier1235033smarmier
smarmiest1335913smarmiest
smartie9310173smartie_
snappier1266223snappier
snappiest1346503snappiest
snares65329033snar__es
snarkier12336513snarkier
snarkiest13207643snarkiest
snarlier8278183snarlier
snarliest91810213snarliest
soapier93411713soa_pier
soapiest102412853soa_piest
sorties74126403s_orties
spares84834553spar__es
sparges104016343spar_ges
sparids103512123spar_ids
sparkier14298033sparkier
sparkiest15188103sparkiest
sparkles143210493sparkles
sparoids11218713sparoids
sparrier10329143sparrier
sparriest11198793sparriest
spavies123012953spa_vies
spies76037623s___pies
spurries102311323spurries
staggies101210323staggies
stapes85028733sta_p_es
staples93617213sta_ples
starches131912913starches
stares66038753star__es
starrier8279463starrier
starriest9159773starriest
startles82111963startles
starves104614553star_ves
stirpes95011293stirp_es
stories7324273stor_ies
stripes95320573s_tripes
sturdies92110273sturdies
sudaries9312753sudar_ies
svarajes1843513svarajes
swabbies15115713swabbies
swaggies13136693swaggies
swamies123712063swa_mies
swampier1544593swampier
swampiest1635033swampiest
swarajes1843743swarajes
syncarpies1743683syncarpies
tardies84225863_tardies
tarries73324263_tarries
tawpies12309873_tawpies
therapies1447723therapies
thirties1139723thirties
thorpes125010353thorp_es
varies94330873_var_ies
wearies103020233wear_ies
whammies18265513whammies
wharves16457143whar_ves
wherries14179033wherries
whirlies14167373whirlies
whirries14136703whirries
whoopies16267373whoopies
yearlies1137603yearlies

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.420425454.8
2DLD Change Limit1461623136.62622058.9
3Display Results3133130.1262484.1
 (SQL Overall)1786913137.17224915.1
 
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.