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

274 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
scalpel1137771(None) 
scalped124411991scalped
scalpels12345881scalpels
scalper113912921scalper
carpel105418472_carpel
scalded11409762scalded
scale74629142scal_e_
scaled94822442scal_ed
scaler84321602scal_er
scales84529312scal_es
scalier94316912scalier
scall74420372scal__l
scalp95217982scalp__
scalpers123710862scalpers
scalps104315232scalp_s
scamped144711962scamped
scamper134613162scamper
scape96921842sca_pe_
scaped115519552sca_ped
scapes105122262sca_pes
scarped124314402scarped
scarper114814822scarper
scauper11379452scauper
sculped12398252sculped
acaleph1453443acaleph
appel94615893__appel
calces104420053_calces
calipee11412913_calipee
caliper11410963_caliper
calked134617403_calked
calker124917083_calker
call66838673_cal__l
called94126733_called
callee84327293_callee
caller85125483_caller
callet84536763_callet
calmed114816383_calmed
calmer105216933_calmer
calomel1138073_calomel
calpac123211063_calpac
calve105919923_calve_
calved125215453_calved
calves115119283_calves
calxes154113033_calxes
camel96822803_ca_mel
camped134720233_camped
camper124722213_camper
cancel105316683_cancel
cannel84216403_cannel
cape87242783_ca_pe_
caped104931803_ca_ped
caper94831623_ca_per
capes95441923_ca_pes
caplet104226813_caplet
capped134721853_capped
capper124421983_capper
carcel105018673_carcel
carpal103716253_carpal
carped115923763_carped
carpels115315463_carpels
carper104923633_carper
carpet104530093_carpet
carrel84718633_carrel
cartel85022533_cartel
carvel114817573_carvel
chapel134911373_chapel
compel124412893_compel
cupel9514303_c_upel
diallel845683diallel
escalope1244523escalope_
escaloped1443983escaloped
escalopes1344773escalopes
escape103811663esca_pe_
escaped12388853esca_ped
escapee113310463esca_pee
escaper11368843esca_per
escapes113811673esca_pes
escarped1355163escarped
graupel1034133graupel
hallel93514093_hallel
lapel73716683_la_pel
palpal104112053_palpal
palped114513643_palped
rappel104211953_rappel
salal55425703s_al_al
sale44959703s_al_e_
salep77022953s_al_ep
saleps85014903s_aleps
sales56055593s_al_es
sall44544683s_al__l
sallet63734543s_allet
salol55222143s_al_ol
salp64534093s_alp__
salpa75018353s_alp_a
salpae84614273s_alpae
salpas85116923s_alpas
salpid9510883s_alpid
salps74423243s_alp_s
salted74121203s_alted
salter64325083s_alter
salve85022133s_alve_
salved103916423s_alved
salver94617753s_alver
salves94221763s_alves
samiel8313333s_amiel
sample104215013s_ample
sapped114422013s_apped
sapper103822353s_apper
saurel6511993s_aurel
scabbed14408223scabbed
scabble13168653scabble
scabies11613333scabies
scalable121710233scalable
scalably15166703scalably
scalade10359263scalade
scalades11258803scalades
scalado10276473scalado
scalage103110533scalage
scalages113010253scalages
scalar83612433scal_ar
scalare93311833scalare
scalares103210983scalares
scalars93711903scalars
scald84818123scal__d
scaldic1235943scaldic
scalds94813693scal_ds
scalene9310773scalene
scaleni936883scaleni
scalepan1244513scalepan
scalers93817263scalers
scaleup1134483scaleup
scaliest101714403scaliest
scaling103519373scaling
scallop11237643scallop
scalloped1444463scalloped
scalloper1344453scalloper
scalls84218203scal_ls
scalping133410453scalping
scaly104718723scal__y
scammed14479543scammed
scammer133611973scammer
scamp115717313scamp__
scampers143611033scampers
scampi12469103scamp_i
scampies1439333scampies
scamps125014173scamp_s
scandal1038673scandal
scanned104110893scanned
scanner94411813scanner
scanted104114393scanted
scanter94215183scanter
scapula1136343sca_pula
scarce104013633scarce_
scarcely1534313scarcely
scarcer113911373scarcer
scare75334463sca_re_
scared95227293sca_red
scarer84524613sca_rer
scares85033003sca_res
scarey115016983sca_rey
scarfed134711183scarfed
scarfer124511083scarfer
scarier94017873scarier
scarlet91516943scarlet
scarp95724103scarp__
scarpers124712513scarpers
scarph13429603scarp_h
scarphed1635443scarphed
scarphs14437413scarphs
scarps104718603scarp_s
scarred104512633scarred
scarted104816123scarted
scarves124511623scarves
scathe114414993scathe_
scathed134012643scathed
scathes124515713scathes
scatted103512773scatted
scatter93815173scatter
scaup95515993scaup__
scaupers12378173scaupers
scaups105411933scaup_s
schappe1635273schappe_
schappes1736043schappes
schlep1347093schl_ep
schlepp1662953schlepp
schleps1445483schleps
scolded11358863scolded
scolder103210343scolder
scolex1538243scol_ex
scooped124611753scooped
scooper113812033scooper
scope94821483sc_ope_
scoped115116663sc_oped
scopes104719593sc_opes
scrannel1044033scrannel
scrape105917573scrape_
scraped124313143scraped
scraper114513423scraper
scrapes116217663scrapes
scrapped1556543scrapped
scrapper1466973scrapper
scrapple1434683scrapple
scruple1137193scruple
sculked14307183sculked
sculker13318323sculker
scull75315763scul__l
sculled102911693sculled
sculler99812153sculler
sculp95314843sculp__
sculpin11236653sculpin
sculps104611753sculp_s
sculpt104412693sculp_t
sculpted1354883sculpted
sculpts11377063sculpts
scupper1367423scupper
sealed74328363seal_ed
sealer63928963seal_er
shale85332833shal_e_
shaled105023953shal_ed
shales94731253shal_es
shaley123714993shal_ey
shalier103116423shalier
shall85024053shal__l
shape105125113sha_pe_
shaped125020103sha_ped
shapely1536893sha_pely
shapen114414653sha_pen
shaper114119933sha_per
shapes115124953sha_pes
sharped134112053sharped
sharpen12389723sharpen
sharper124312703sharper
skelped1435203skelped
slapped123511853slapped
slapper113512473slapper
small74016263smal__l
smaller93410333smaller
snapped124611203snapped
snapper113512073snapper
soaped95817973soa_ped
soaper84517873soa_per
solgel737963s_olgel
spale74929213spal_e_
spales84728103spal_es
spall74919303spal__l
spalled103113133spalled
spaller92713473spaller
spalpeen1252503spalpeen
spancel1147363spancel
spaniel948923spaniel
stale55637103stal_e_
staled74728103stal_ed
stalely1039213stal_ely
staler64025823stal_er
stales65538293stal_es
stalked123811173stalked
stalker113912253stalker
stall54722353stal__l
stalled83515693stalled
stammel11607533stammel
stamped124812813stamped
stamper113714403stamper
stapes85028733sta_pes
staple84415823staple_
stapled103613703stapled
stapler93913633stapler
staples93617213staples
stipel84412123s_tipel
swale85221593swal_e_
swales93920763swal_es
swamped15498443swamped
swamper14349313swamper
swapped15429143swapped
swapper14359703swapper

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.423422437.4
2DLD Change Limit1340272747.25018486.5
3Display Results2742740.1102490.9
 (SQL Overall)1786912747.78322959.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.