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

215 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
sharpest133914(None) 
chariest13315502chariest
hardest113118412_hardest
harpist12312352_harpist
harvest132112752_harvest
scarcest12169172scarcest
scariest101615942scariest
searest73322022sear_est
shadiest121711272shadiest
shakiest151910932shakiest
shaliest111415042shaliest
shapes115124942sha_pes_
shares95236412shar_es_
sharped134112042sharpe_d
sharpen12389722sharpe_n
sharpens13377812sharpens
sharper124312702sharpe_r
sharpers133810942sharpers
sharpies13411222sharpies_
sharpness1434932sharpness
sharps115516082sharp_s_
shortest11310772shortest
smartest10310182smartest
sparest94616422spar_est
sparsest1048812sparsest
starkest1239722starkest
anapest9311553ana_pest
arpent84822093__arpent
arrest63722633__arrest
barest85327693_bar_est
carpet104530093_carpe_t
carpets113915333_carpets
chapes135421873cha_pes_
chares115631803char_es_
charges134615983charges_
charriest1438253charriest
chartist131112133chartist
chastest1349703chastest
cheapest1536073cheapest
chirkest1735383chirkest
chirpiest16286473chirpiest
coarsest1039163coarsest
dampest12411043_dampest
darkest122512623_darkest
dearest83618673dear_est
dwarfest1543473dwarfest
earnest7318733_earnest
glariest92012523glariest
haddest122711993_haddest
hairiest11612463_hairiest
halest94823273_ha_lest
happiest152411673_happiest
hardiest123416333_hardiest
hardset113415833_hardset
hares86255543_har_es_
harness102413933_harness
harped124418403_harpe_d
harper115018403_harpe_r
harpers124916203_harpers
harpies123818313_harpies_
harpists1338093_harpists
harps105926863_harp_s_
harshest14310193_harshest
harvests14246173_harvests
haziest193313003_haziest
heppest14228143_heppest
herpes115517323_herpes_
hippest14219753_hippest
hoariest11312883hoariest
hoarsest1137133hoarsest
largest83715103_largest
leariest83117843leariest
nearest73415843near_est
peartest10311293peartest
phattest1336913phattest
rarest65725483_rar_est
rearrest8311603rearrest
saddest92412383s_addest
safest95016603s_a_fest
sagest74920263s_a_gest
sagiest82617983s_agiest
saltest71916513s_altest
sanest64426693s_a_nest
sappiest122612573s_appiest
sarapes94617743s_arapes_
sarees65329943s_arees_
sarges75128593s_arges_
sarkiest123615063s_arkiest
sarment9318763s_arment
sayest94217743s_a_yest
scaliest101714383scaliest
scantest101710183scantest
scapes105122263sca_pes_
scaredest1246633scaredest
scares85033003scar_es_
scarless10189053scarless
scarlet91516943scarle_t
scarlets10178573scarlets
scarped124314393scarpe_d
scarper114814823scarpe_r
scarpers124712513scarpers
scarphs14437413scarphs_
scarps104718603scarp_s_
scarriest11188393scarriest
scarves124511623scarves_
schappes1736033schappes_
scrapes116217663scrapes_
seamiest102715413seamiest
serapes95218103serapes_
serest64831613s_er_est
serpent92916283s_erpent
shabbiest1635323shabbiest
shades105924533sha_des_
shaggiest14156893shaggiest
shakes135024593sha_kes_
shakoes144510013shakoes_
shales94731253sha_les_
shames114726223sha_mes_
shammes144312833shammes_
shape105125113sha_pe__
shaped125020103sha_pe_d
shapely1536893sha_pely
shapen114414653sha_pe_n
shaper114119933sha_pe_r
shapers124016893sha_pers
shapeup1443293sha_peup
shards104319173shar_ds_
share86437083shar_e__
shared105829063shar_e_d
sharer95025483shar_e_r
sharers104720623shar_ers
sharias102516003sharias_
sharifs13279903sharifs_
sharked153613903sharke_d
sharker144313813sharke_r
sharkers154011053sharkers
sharks135019723shar_ks_
sharns95516983shar_ns_
sharp104922533sharp___
sharpened1544473sharpened
sharpener1444583sharpener
sharpie1238383sharp_ie
sharping143011373sharping
sharply15406833sharp_ly
sharpy145211033sharp__y
shaves125224933sha_ves_
shavies134213203shavies_
sheerest11310083sheerest
sherbert1348783sherbert
sherbet12311383sherbe_t
sherbets1335213sherbets
sherpas1238093sherpas_
shiest95821523sh__iest
shiniest113212493shiniest
shires95225573shir_es_
shirtiest1239323shirtiest
shoalest1168913shoalest
shoaliest1238493shoaliest
shoppes143411383shoppes_
shores94830403shor_es_
showiest1438783showiest
shyest125511833sh__yest
slackest14289393slackest
slatiest82616263slatiest
smallest1039403smallest
smarmiest1335903smarmiest
smeariest1138113smeariest
snakiest122110533snakiest
snappiest1346483snappiest
snares65329033snar_es_
snarkiest13207623snarkiest
snarliest91810193snarliest
soapiest102412843soapiest
sorest65027993s_or_est
sorriest8413883sorriest
sourest7515713sour_est
spaciest122310893spaciest
spares84834553spar_es_
sparges104016333sparges_
sparkiest15188093sparkiest
sparriest11198783sparriest
spheriest1438373spheriest
spiriest102513453spiriest
spriest92718643s_priest
spryest12247813s_pryest
squarest17338213squar_est
stablest103312943stablest
stagiest91613403stagiest
staidest939803staidest
stalest73720173sta_lest
stapes85028733sta_pes_
stardust946093stardust
stares66038753star_es_
starets73515923star_ets
starless81610843starless
starlet71620123starle_t
starlets81610083starlets
starriest9159763starriest
starves104614553starves_
steepest1038123steepest
sternest8314433sternest
stirpes95011293stirpes_
suavest10310623sua_vest
sugariest1038123sugariest
surest65026763s_ur_est
swampiest1635023swampiest
swankest15105933swankest
tartest72517533_tartest
teariest82417263teariest
thorpes125010353thorpes_
wariest105122503_wariest
warmest123113033_warmest
weariest112914793weariest
wharves16457133wharves_
yarest95018913_yar_est

Search took 10 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.1701051123.5
2DLD Change Limit1461622158.62616944.4
3Display Results2152150.1861155.9
 (SQL Overall)1786912158.98219894.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.