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

230 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
sharpie123840(None) 
sharpies13411231sharpies
chappie16298662chappie
charlie123011922charlie
harpies123818322_harpies
harpin113614382_harpin
scrapie115010942scrapie
shape105125112sha_p_e
share86437082shar__e
sharia93116732shar_ia
sharif122917122shar_if
sharp104922532sharp__
sharped134112052sharped
sharpen12389722sharpen
sharper124312702sharper
sharping143011372sharping
sharply15406832sharply
sharps115516082sharp_s
sharpy145211032sharp_y
shavie124312422sha_vie
shortie10411342shortie
smartie9310172smartie
barbie105018353_barbie
barmie103816393_barmie
carnie84421093_carnie
carpi94319393_carpi_
challie124012853challie
chape125221143cha_p_e
chappies172610103chappies
charade13129913charade
chare105231983char__e
charge125114213char_ge
charier124317903char_ier
charlies133414233charlies
charpai1436633charpai
charpais1536933charpais
charpoy1735713charpoy
charrier1378683charrier
cheapie1437563cheapie
chippie16297693chippie
chirpier15276303chirpier
crappie13298983crappie
darkie113714013_darkie
dearie73319813dear_ie
dharmic1535023dharmic
dhurrie1153953dhurrie
farcie114816473_farcie
garpike1435093_garpike
gharri10386163gharri_
gharries12318213gharries
gharris11306433gharris
hackie154615623_hackie
hairpin1245413_hairpin
hankie133915713_hankie
happier143312043_happier
hardier114721543_hardier
hardies114923233_hardies
hare76255733_har__e
harmin113117393_harmin
harmine122816193_harmine
harp96134293_harp__
harped124418403_harped
harper115018403_harper
harping134118383_harping
harpins123615703_harpins
harpist12312363_harpist
harps105926873_harp_s
harpy136418213_harp_y
harried113815533_harried
harrier104417753_harrier
harries103525493_harries
hatpin112610613_hatpin
hawkie163810093_hawkie
hempie132410563_hempie
hippie132811243_hippie
hirple11158973_hirple
magpie1139093_magpie
nappie104112263_nappie
pardie96021443_pardie
rhaphe1433423rha_phe
salpae84614273s_alpae
salpid9510883s_alpid
saltie63422433s_altie
sample104215013s_ample
sapid84720933s_a_pid
sappier113613123s_appier
sarape84817573s_arape
sardine83317393s_ardine
saree55044663s_ar_ee
sarge65531133s_ar_ge
sari45444043s_ar_i_
sarin55239253s_ar_in
saris54544953s_ar_is
sarkier113413313s_arkier
sarode75317513s_arode
scampi12469103scampi_
scampies1439333scampies
scape96921843sca_p_e
scarce104013633scar_ce
scare75334463scar__e
scarfpin1553033scarfpin
scarier94017873scar_ier
scarp95724103scarp__
scarped124314403scarped
scarper114814823scarper
scarph13429603scarp_h
scarphed1635443scarphed
scarphs14437413scarphs
scarping133312463scarping
scarps104718603scarp_s
scarrier10298453scarrier
schappe1635273scha_ppe
scrape105917573scrap_e
scrapies124612483scrapies
serape84818413serap_e
shabbier1535183shabbier
shackle16409543shackle
shade95125583sha__de
shadier113111153sha_dier
shaggier13116053shaggier
shake124726403sha__ke
shakier143411153sha_kier
shale85332833sha__le
shalier103116423sha_lier
shamble14149263shamble
shame105726703sha__me
shammied16265543shammied
shammies15259693shammies
shamois123210423shamois
shampoo1435373shampoo
shandies122714113shandies
shannies113411263shannies
shanti94014093shanti_
shanties113116593shanties
shantih13309643shantih
shantis103313103shantis
shaped125020103sha_ped
shapen114414653sha_pen
shaper114119933sha_per
shapes115124953sha_pes
shaping133116183sha_ping
sharable131910693sharable
shard96125963shar__d
shards104319173shar_ds
shared105829063shar_ed
sharer95025483shar_er
sharers104720623sharers
shares95236413shar_es
shariah132210533shariah
sharias102516003sharias
sharifs13279903sharifs
sharing113723243sharing
shark126225023shar__k
sharked153613913sharked
sharker144313813sharker
sharking163912973sharking
sharklike1543933sharklike
sharks135019723shar_ks
sharn84823703shar__n
sharns95516983shar_ns
sharny124711833shar_ny
sharpened1544483sharpened
sharpener1444583sharpener
sharpens13377813sharpens
sharpers133810943sharpers
sharpest1339153sharpest
sharpness1434943sharpness
shaslik1444513shaslik
shave114425893sha__ve
shavies134213213sha_vies
sheenie10159493sheenie
sheltie10109913sheltie
sherif122915243sher_if
sherpa1138093sherp_a
sherpas1238093sherpas
sherries111812893sherries
sherris10168803sherris
shilpit1247103shilpit
shire84727133shir__e
shirtier1137943shirtier
shoppe133110323sh_oppe
shore85432653shor__e
shortia1048193shortia
shorties11414583shorties
shrapnel1342133shrapnel
shri76021703sh_r_i_
shriek134211103sh_r_iek
shrike134513243sh_rike
shrine94920053sh_rine
shris84221453sh_r_is
shrive125216953sh_rive
shrove125412233sh_rove
shunpike1742153shunpike
shvartze2341873shvartze
sinopie948783sinopie
smarmier1235033smarmier
smarties10312873smarties
snappier1266223snappier
snare54429983snar__e
snarkier12336513snarkier
snarlier8278183snarlier
soapier93411713soa_pier
sortie63621993s_ortie
spare75135563spar__e
sparge94216053spar_ge
sparid94016933spar_id
sparkier14298033sparkier
sparkle133710213sparkle
sparlike1437673sparlike
sparoid102311543sparoid
sparrier10329143sparrier
sparse84516343spar_se
spavie113611383spa_vie
staggie9138463staggie
staple84415823sta_ple
stare54440263star__e
starlike1238813starlike
starlit71512913starlit
starrier8279463starrier
startle72511123startle
starve94613743star_ve
stripe85822443s_tripe
swabbie1484333swabbie
swaggie12135783swaggie
swampier1544593swampier
sware85828213swar__e
tawpie11339143_tawpie
thorpe113610093thorp_e
wharve15456203whar_ve
whoopie15295933whoopie

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272307.79617191.8
3Display Results2302300.0763026.3
 (SQL Overall)1786912308.27821586.3
 
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.