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

112 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
sheerness123627(None) 
cheeriness1545532cheeriness
cheerless1495292cheerless
queerness1844212queerness
seeress7311572s_eer_ess
sheeneys14294902shee_neys
sheerest11310082sheer_est
sheerlegs1343292sheerlegs
sheernesses1445842sheernesses
sheetless1235822sheetless
sleekness1344542sleekness
soberness1186462soberness
steepness1145722steepness
sweetness1245682sweetness
beeriness1137863_beeriness
cheapness1643743cheapness
cheekiness1944043cheekiness
cheekless1873883cheekless
cheerers13319543cheer_ers
cheeriest1438213cheeriest
cheesiness1544733cheesiness
chewiness1744823chewiness
clearness1135633clearness
cleverness1543223cleverness
dearness939973_dearness
deepness1136443_deepness
eagerness1046263eagerness
eeriness8311873__eeriness
fleetness1244753fleetness
freeness11710443free_ness
governess1346173governess
greenness1046793greenness
harness102413933_h_arness
heedless12278813_heedless
heelless11257653_heelless
heiress1036813_heir_ess
heirless1146053_heirless
innerness946913innerness
inverness1247133inverness
keenness1234883_keenness
leeriness938323_leeriness
meekness1434303_meekness
meetness1036653_meetness
nearness838313_nearness
otherness1245513otherness
peeress939503_peer_ess
peerless1037513_peerless
safeness11239633safe_ness
sageness92111983sage_ness
sameness102712683same_ness
saneness82313723sane_ness
seediness10219173seediness
seedless9319513s_eedless
selfness1135153s_elfness
serenes73222903s_erene_s
serenest82717623s_erenest
severeness1346123severeness
sewerless1244303sewerless
sexiness1537943s_exiness
shadiness1337463shadiness
shakiness1637083shakiness
sharpness1434933sharpness
shearers113911323shear_ers
shearlegs1342493shearlegs
sheened113511703shee_ne_d
sheeney13398933shee_ne_y
sheenies111411543shee_nies
sheeniest12158353sheeniest
sheens95116993shee_n__s
sheered113515453sheer_e_d
sheerer103813843sheer_e_r
sheers94322403sheer___s
sheeters113111863shee_ters
sheeves133911953shee_ve_s
shelterless1452043shelterless
shepherdess2051413shepherdess
sherbets1335213sh_erbets
shereefs1433863sh_ereefs
sherries111812893sherrie_s
sherrises12156863sherrises
shininess1237333shininess
shoeless1137803shoe_less
shoreless1236633shoreless
shortness1236733shortness
showerless1642543showerless
showiness1576073showiness
shrewdness1742533shrewdness
shyness1344993sh__yness
sidedness1146783sidedness
skewness1533763s_kewness
sleepiness1245133sleepiness
sleepless1144553sleepless
slenderness1243453slenderness
sneerers8309803sneer_ers
sneeriest939313sneeriest
soleness8814263sole_ness
somberness1443513somberness
soreness8914793sore_ness
sourness839543s_ourness
spareness1139863spareness
speediness1345223speediness
steeliness1046793steeliness
steerers82511353steer_ers
sternest8314433s_ternest
sternness946093sternness
superbness1446663superbness
sureness8912903sure_ness
sweeneys14294023swee_neys
tweeness11246403twee_ness
utterness946223utterness
wheelless1543763wheelless
wheeziness2542543wheeziness

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411126.75022020.9
3Display Results1121120.0631777.8
 (SQL Overall)1786911127.23624694.7
 
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.