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

387 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
sharked153613911sharked
sharker144313811sharker
charked174814012charked
hackee154921832_hackee
harked145422552_harked
harken135116342_harken
saree55044662s_ar_ee
shacked174015392shacked
shackle16409542shackle
shake124726402sha_k_e
shaken134113612sha_ken
shaker134319462sha_ker
shakes135024592sha_kes
shanked153212122shanked
share86437082shar__e
shared105829062shar_ed
sharer95025482shar_er
shares95236412shar_es
shark126225022shark__
sharkers154011052sharkers
sharks135019722shark_s
sharped134112052sharped
sharpen12389722sharpen
sharper124312702sharper
sharpie1238402sharpie
shirked153710462shirked
shirker143711342shirker
sparked143513142sparked
sparker133914362sparker
sparkle133710212sparkle
starker114114692starker
ackee115825373__ackee
akee85936813__a_kee
asparkle1443843asparkle
awardee1137563awardee
bargee94624443_bargee
barked135027313_barked
barkeep1536363_barkeep
barker124822863_barker
bidarkee1544583bidarkee
carked134024823_carked
chalked17449863chalked
charade13129913charade
chare105231983char__e
chared125423693char_ed
chares115631803char_es
charge125114213char_ge
charged144614023charged
charger133914063charger
charges134615983charges
charier124317903charier
chark144222713chark__
charka154011703chark_a
charkas164810963charkas
charkha19405153charkha
charks155219703chark_s
charley15118273charley
charlie123011923charlie
charmed154714253charmed
charmer144913663charmer
charnel124010053charnel
charred134614483charred
charted135116853charted
charter123918303charter
chickee183111553chickee
chirked173810333chirked
chirker16429323chirker
darked123919633_darked
darken114013443_darken
darker114718693_darker
darkey145212423_darkey
darkie113714013_darkie
darkle113813943_darkle
hacked164923513_hacked
hackees165014103_hackees
hacker154822693_hacker
hackie154615623_hackie
hackle154916813_hackle
hadjee174111823_hadjee
hake115637843_ha_k_e
hakeem15407383_ha_keem
hakes126034303_ha_kes
hanked144220603_hanked
hanker134622093_hanker
hankie133915713_hankie
harden105718533_harden
harder105022403_harder
hare76255733_har__e
hared95742183_har_ed
hareem114312063_hareem
harem104924453_har_em
hares86255543_har_es
hark115237393_hark__
harkened1637483_harkened
harkener1537573_harkener
harkens144112863_harkens
harks126333433_hark_s
harmed125218833_harmed
harmer114719553_harmer
harped124418403_harped
harper115018403_harper
hawked174712673_hawked
hawker164812663_hawker
hawkey19507633_hawkey
hawkie163810093_hawkie
hearken14338023hearken
hiree85427803_hir_ee
laree56036293_lar_ee
larked114519473_larked
larker104519243_larker
marked133921623_marked
marker124420393_marker
market123226043_market
narked114116743_narked
pardee93922023_pardee
parked134425143_parked
parker124121373_parker
pharisee1347603pharisee
rakee96031173_ra_kee
sacked135525213s_acked
sacker125124843s_acker
sake85244963s_a_k_e
saker95132023s_a_ker
sakes95540753s_a_kes
sarape84817573s_arape
sarees65329943s_arees
sarge65531133s_ar_ge
sarges75128593s_arges
sark84938973s_ark__
sarkier113413313s_arkier
sarks96632463s_ark_s
sarky125521783s_ark_y
sarode75317513s_arode
sarsen6314233s_arsen
scarce104013633scar_ce
scarcer113911373scarcer
scare75334463scar__e
scared95227293scar_ed
scarer84524613scar_er
scares85033003scar_es
scarey115016983scar_ey
scarfed134711183scarfed
scarfer124511083scarfer
scarier94017873scarier
scarlet91516943scarlet
scarped124314403scarped
scarper114814823scarper
scarred104512633scarred
scarted104816123scarted
scarves124511623scarves
scree720031713s_cr_ee
seared75232843sear_ed
searer65432023sear_er
shack145321753shack__
shackled18277603shackled
shackler17317973shackler
shackles173010593shackles
shacko153810113shack_o
shackoes17367853shackoes
shackos16429023shackos
shacks154817563shack_s
shade95125583sha__de
shaded114518873sha_ded
shader104218763sha_der
shades105924533sha_des
shadier113111153shadier
shafted14288813shafted
shagged134210133shagged
shagreen1243443shagreen
shakers144015563sha_kers
shakeup1632763sha_keup
shakier143411153shakier
shako125516093sha_k_o
shakoes144510023shakoes
shakos134912193sha_kos
shaky154616843sha_k_y
shale85332833sha__le
shaled105023953sha_led
shales94731253sha_les
shaley123714993sha_ley
shalier103116423shalier
shamble14149263shamble
shame105726703sha__me
shamed125120213sha_med
shames114726223sha_mes
shammed153911423shammed
shammer144613143shammer
shammes144312833shammes
shank125422193shank__
shanks135315583shank_s
shantey134210043shantey
shape105125113sha__pe
shaped125020103sha_ped
shapen114414653sha_pen
shaper114119933sha_per
shapes115124953sha_pes
sharable131910693sharable
shard96125963shar__d
shards104319173shar_ds
sharers104720623sharers
sharia93116733shar_ia
shariah132210533shariah
sharias102516003sharias
sharif122917123shar_if
sharifs13279903sharifs
sharing113723243sharing
sharking163912973sharking
sharklike1543933sharklike
sharn84823703shar__n
sharns95516983shar_ns
sharny124711833shar_ny
sharp104922533shar__p
sharpened1544483sharpened
sharpener1444583sharpener
sharpens13377813sharpens
sharpers133810943sharpers
sharpest1339153sharpest
sharpies13411233sharpies
sharply15406833sharply
sharps115516083shar_ps
sharpy145211033shar_py
shatter103615703shatter
shauled1148793shauled
shave114425893sha__ve
shaved135118383sha_ved
shaven124213303sha_ven
shaver123718913sha_ver
shaves125224933sha_ves
shavie124312423sha_vie
shavies134213213shavies
shawed134817233sha_wed
shawled1437773shawled
sheared114516003shear_ed
shearer104414683shear_er
shekel1338383sh_ekel
sherbet12311383sherbet
shereef1337743shereef
shicker163914823shicker
shikaree1544833shikar_ee
shikker13277023shikker
shikse1386073sh_ikse
shire84727133shir__e
shires95225573shir_es
shirk124817843shirk__
shirkers15319583shirkers
shirks134814123shirk_s
shirred113710503shirred
shivaree1445663shivar_ee
shocked174611813shocked
shocker163411433shocker
shore85432653shor__e
shored105723653shor_ed
shores94830413shor_es
shorted113614403shorted
shorten103511413shorten
shorter103515503shorter
shortie10411343shortie
shred98125613sh_r_ed
shrew119720173sh_r_ew
shriek134211103sh_riek
shrieve13417683sh_rieve
shrike134513243sh_rike
shrikes144412393shrikes
shrine94920053sh_rine
shrive125216953sh_rive
shrove125412233sh_rove
shucked17389833shucked
shucker163710103shucker
shvartze2341873shvartze
sickee124622223s_ickee
siree55238813s_ir_ee
sirree64017343s_irree
skanked11338103skanked
skanker10268483skanker
skee85431473s___kee
slacked143815453slacked
slacken13399933slacken
slacker133915293slacker
slake93724053sla_k_e
slaked114318273sla_ked
slaker104219273sla_ker
slakes104021883sla_kes
smacked163710993smacked
smacker153410583smacker
smarted105012613smarted
smarten9348863smarten
smarter94113133smarter
smartie9310173smartie
smerked14327283smerked
smirked14307233smirked
smirker13327423smirker
snacked144013113snacked
snacker133112603snacker
snake94821113sna_k_e
snaked115017593sna_ked
snakes103919603sna_kes
snakey135011273sna_key
snare54429983snar__e
snared74824553snar_ed
snarer64620843snar_er
snares65329033snar_es
snarfed11378753snarfed
snark95419943snark__
snarkier12336513snarkier
snarks104815733snark_s
snarky134210843snark_y
snarled83612363snarled
snarler73610633snarler
snorkel1135423snorkel
soaked114717593soa_ked
soaker105717533soa_ker
soared74324293soar_ed
soarer64522243soar_er
soiree62919483soir_ee
spackle15369573spackle
spahee11313443spa_hee
spake114322743spa_k_e
spanked143111733spanked
spanker133612353spanker
spare75135563spar__e
spared95427493spar_ed
sparer84524963spar_er
spares84834553spar_es
sparge94216053spar_ge
sparged113512763sparged
sparger103613083sparger
sparges104016343sparges
spark114920893spark__
sparkers144111313sparkers
sparkier14298033sparkier
sparkled15317733sparkled
sparkler14317983sparkler
sparkles143210493sparkles
sparklet143110593sparklet
sparkly16348133sparkly
sparks124616363spark_s
sparky154511523spark_y
sparred104512863sparred
sparse84516343spar_se
sparser94311483sparser
spree74830863s_pr_ee
stacked143416123stacked
stacker134416263stacker
stake95927533sta_k_e
staked114621943sta_ked
stakes103927293sta_kes
stalked123811173stalked
stalker113912253stalker
standee83514513standee
stare54440263star__e
stared75429873star_ed
starer64027363star_er
stares66038753star_es
stark95425623stark__
starkers123712393starkers
starkest1239723starkest
starkly14277033starkly
starlet71620123starlet
starred85013453starred
started84217323started
starter73817883starter
startle72511123startle
starve94613743star_ve
starved114911573starved
starver104611993starver
starves104614553starves
strake104017393strak_e
straked125415343straked
strakes114218073strakes
swacked173110523swacked
swanked15359543swanked
swanker14369483swanker
swarded1238153swarded
sware85828213swar__e
swarmed1367483swarmed
swarmer1247803swarmer
thacked173810203thacked
thanked15469153thanked
thanker14309593thanker
three87526913th_r_ee
warked144421213_warked
whacked20458623whacked
whacker19368503whacker
whangee14268613whangee
wharfed1734413wharfed
wharve15456203whar_ve
wharves16457133wharves

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273877.09318895.7
3Display Results3873870.1402764.3
 (SQL Overall)1786913877.63923391.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.