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

249 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
sharpens1337781(None) 
sharpen12389721sharpen_
sharpers133810941sharpers
arpens84814822__arpens
happens14359172_happens
hardens113815022_hardens
harkens144112862_harkens
harpers124916202_harpers
harpins123615702_harpins
resharpens1542562resharpens
sarsens7311392s_arsens
scarpers124712512scarpers
shagreens1342632shagreens
shapen114414652sha_pen_
shapers124016892sha_pers
shapes115124942sha_pe_s
sharers104720622shar_ers
shares95236412shar_e_s
sharkers154011052sharkers
sharns95516982shar__ns
sharped134112052sharpe_d
sharpened1544482sharpened
sharpener1444582sharpener
sharpeners1543892sharpeners
sharper124312702sharpe_r
sharpest1339142sharpest
sharpies13411222sharpies
sharping143011372sharping
sharpness1434932sharpness
sharps115516082sharp__s
shippens15316802shippens
shortens11288992shortens
smartens10286662smartens
arpen74418043__arpen_
arpent84822093__arpent
arpents93613083__arpents
aspens85013353__aspens
barrens94414323_barrens
careens94514703_careens
carpels115315463_carpels
carpers114521253_carpers
carpets113915333_carpets
champers173311623champers
chapels14429153cha_pels
chapes135421873cha_pe_s
chares115631803char_e_s
chargers144011323chargers
charges134615983charge_s
charleys1695633charleys
charmers154211333charmers
charnels13328173charnels
charpais1536933charpais
charpoys1834533charpoys
charters134115583charters
chastens13429183chastens
chazzens21253943chazzens
cheapens15305943cheapens
chirpers15358133chirpers
chortens13308793chortens
coarsens10348123coarsens
dampens12348563_dampens
darkens12409873_darkens
gardens93312093_gardens
hairpins1365433_hairpins
hampers143616953_hampers
happen134812193_happen_
haptens124511343_haptens
harden105718533_harden_
hardpans1436453_hardpans
hareems12428203_hareems
harems115513823_har_ems
hares86255543_har_e_s
harken135116343_harken_
harmers124116593_harmers
harmins123716723_harmins
harness102413933_harness
harped124418403_harpe_d
harper115018403_harpe_r
harpies123818313_harpies
harpin113614383_harpin_
harping134118383_harping
harpings14379773_harpings
harpoons1337483_harpoons
harps105926873_harp__s
harshens1437603_harshens
hastens106214813_hastens
hatpins123410643_hatpins
hausens1077633_hausens
havens124514043_ha_vens
hearkens15336693hearkens
heartens113010153heartens
herpes115517323_herpe_s
hoarsens11306023hoarsens
khazens2332663kha_zens
martens93714953_martens
playpens1534073playpens
rehardens13104673rehardens
resharpen1443423resharpen_
saddens9309603s_addens
sampans112411003s_ampans
sapiens9310173s_apiens
sappers113518903s_appers
sarans64224433s_ar_ans
sarapes94617743s_arape_s
sarees65329943s_ar_ees
sarges75128593s_arge_s
sarins63932623s_ar_ins
sarment9318763s_arment
sarments10311963s_arments
sarsen6314233s_arsen_
sateens73710753s_ateens
scalpels12345883scalpels
scalpers123710863scalpers
scampers143611033scampers
scapes105122263sca_pe_s
scarers94618513scar_ers
scares85033003scar_e_s
scarfers13408463scarfers
scarfpins1653043scarfpins
scarless10189053scarless
scarlets10178573scarlets
scarped124314403scarpe_d
scarper114814823scarpe_r
scarphs14437413scarp_hs
scarping133312463scarping
scarps104718603scarp__s
scarves124511623scarve_s
scaupers12378173scaupers
schappes1736033schappe_s
scrapers125510533scrapers
scrapes116217663scrape_s
screens95212183s_creens
serapes95218103serape_s
serpent92916283s_erpent
serpents102410373s_erpents
shaders115915553sha_ders
shades105924533sha_de_s
shagreen1243443shagreen_
shairns10276783sha_irns
shaitans1136413shaitans
shaken134113613sha_ken_
shakers144015563sha_kers
shakes135024593sha_ke_s
shakoes144510023shakoe_s
shales94731253sha_le_s
shamans123610903sha_mans
shames114726223sha_me_s
shamisens1442603shamisens
shammers153710843shammers
shammes144312833shamme_s
shampoos1544603shampoos
shanteys14395513shanteys
shape105125113sha_pe__
shaped125020103sha_pe_d
shapely1536893sha_pely
shaper114119933sha_pe_r
shapeup1443293sha_peup
shapeups1542723sha_peups
shaping133116183sha_ping
shards104319173shar__ds
share86437083shar_e__
shared105829063shar_e_d
sharer95025483shar_e_r
shariahs14206393shariahs
sharias102516003shar_ias
sharifs13279903shar_ifs
sharing113723243shar_ing
sharked153613913sharke_d
sharker144313813sharke_r
sharking163912973sharking
sharks135019723shar__ks
sharn84823703shar__n_
sharny124711833shar__ny
sharp104922533sharp___
sharpening1644883sharpening
sharpie1238393sharp_ie
sharply15406833sharp_ly
sharpy145211033sharp__y
shatters113313913shatters
shaven124213303sha_ven_
shavers134115093sha_vers
shaves125224933sha_ve_s
shavies134213203shavie_s
shearers113911323shear_ers
shearlegs1342493shearlegs
shebeens1343333shebeens
sheens95116993sh__eens
sherbets1335213sherbets
shereefs1433863shereefs
sherpas1238093sherp_as
shippen14298863shippen_
shippers153012313shippers
shippons15255663shippons
shires95225573shir_e_s
shirkers15319583shirkers
shoppers153010763shoppers
shoppes143411393shoppe_s
shorans102812413shor_ans
shores94830413shor_e_s
shorten103511413shorten_
shrapnel1342133shrapnel
shreds105613053sh_r_eds
shrews129313923sh_r_ews
shrieks14377673sh_rieks
shrines104618693sh_rines
shwanpans1741013shwanpans
sirens65318153s_ir_ens
slackens14367713slackens
slappers123710943slappers
smarten9348863smarten_
snappers123510173snappers
snarers74216663snar_ers
snares65329033snar_e_s
snarlers8298753snarlers
soapers93715923soa_pers
soarers74118093soar_ers
spalpeens1341843spalpeens
sparers94519613spar_ers
spares84834553spar_e_s
spargers11389733spargers
sparges104016343sparge_s
sparkers144111313sparkers
stamens93411483sta_mens
stampers124211603stampers
stapes85028733sta_pe_s
starers74522313star_ers
stares66038753star_e_s
starets73515923star_ets
starkers123712393starkers
starless81610843starless
starlets81610083starlets
starters83714773starters
starvers11459643starvers
starves104614553starve_s
steepens10277113steepens
stirpes95011293stirpe_s
swampers15317473swampers
swanpans1343423swanpans
swappers15358083swappers
swarmers1346323swarmers
syrens94911993s_yr_ens
tarpans92513533_tarpans
tarpons92612213_tarpons
thorpes125010353thorpe_s
wardens113711903_wardens
warpers123413583_warpers
warrens103810893_warrens
whappers18276743whappers
wharves16457133wharve_s

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.483369960.7
2DLD Change Limit1461622496.62622058.9
3Display Results2492490.0932677.4
 (SQL Overall)1786912497.20224811.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.